UGJcdkUF

1CREATE TABLE IF NOT EXISTS `contribuents` (
2  `idCon` int(11) NOT NULL AUTO_INCREMENT,
3  `NIF` varchar(9) DEFAULT NULL,
4  `NOM` varchar(50) DEFAULT NULL,
5  `DOMICILI` varchar(50) DEFAULT NULL,
6  PRIMARY KEY (`idCon`),
7  UNIQUE KEY `NIF` (`NIF`)
8) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
9
10CREATE TABLE IF NOT EXISTS `moviments` (
11  `ID` int(11) NOT NULL AUTO_INCREMENT,
12  `ABM` char(1) DEFAULT NULL,
13  `TIPUS` char(2) DEFAULT NULL,
14  `DATA` date DEFAULT NULL,
15  `MATRICULA` varchar(7) DEFAULT NULL,
16  `N_BASTIDOR` int(20) unsigned DEFAULT NULL,
17  `DNI` varchar(9) DEFAULT NULL,
18  `N_MOTOR` int(20) DEFAULT NULL,
19  `COGNOM_NOM` varchar(50) DEFAULT NULL,
20  `ADREÇA` varchar(50) DEFAULT NULL,
21  `ARXIU` varchar(50) DEFAULT NULL,
22  `DATA_MOV` date DEFAULT NULL,
23  PRIMARY KEY (`ID`)
24) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
25
26CREATE TABLE IF NOT EXISTS `vehicles` (
27  `idVe` int(11) NOT NULL AUTO_INCREMENT,
28  `Matricula` varchar(7) DEFAULT NULL,
29  `N_Motor` int(20) DEFAULT NULL,
30  `N_Bastidor` int(20) DEFAULT NULL,
31  `Data_Alta` date DEFAULT NULL,
32  `Tipus_Baixa` char(2) DEFAULT NULL,
33  `Data_Baixa` date DEFAULT NULL,
34  PRIMARY KEY (`idVe`),
35  UNIQUE KEY `Matricula` (`Matricula`)
36) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
37
38CREATE TABLE IF NOT EXISTS `historic` (
39  `idCon` int(11) NOT NULL,
40  `idVe` int(11) NOT NULL,
41  `Data_Alta` date DEFAULT NULL,
42  `Data_Baixa` date DEFAULT NULL,
43  PRIMARY KEY (`idCon`,`idVe`),
44  KEY `FK_historic_vehicles` (`idVe`),
45  CONSTRAINT `FK_historic_contribuents` FOREIGN KEY (`idCon`) REFERENCES `contribuents` (`idCon`) ON DELETE CASCADE ON UPDATE CASCADE,
46  CONSTRAINT `FK_historic_vehicles` FOREIGN KEY (`idVe`) REFERENCES `vehicles` (`idVe`) ON DELETE CASCADE ON UPDATE CASCADE
47) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;