HifQTCFf

1CREATE TABLE IF NOT EXISTS `Car` (
2  `idCar` int(6) unsigned NOT NULL AUTO_INCREMENT,
3  `Brand` varchar(200) NOT NULL,
4  `Model` varchar(200) NOT NUIL,
5  PRIMARY KEY (`idCar`)
6) DEFAULT CHARSET=utf8;
7
8INSERT INTO `Car` (`Brand`, `Model`) VALUES
9  ('Mercedes', 'A180d'),
10  ('Renault', 'Twingo'),
11  ('Renault', 'Clio'),
12  ('Renault', 'Mégame'),
13  ('Renault', 'Kadjar'),
14  ('Renault', 'Talisman'),
15  ('Nissan', 'Quasqai'),
16  ('Nissan', 'Skyline'),
17  ('Nissan', 'Micra'),
18  ('Nissan', 'Juke'),
19  ('Volvo', 'XC40'),
20  ('Volvo', 'XC80'),
21  ('Volvo', 'XC60'),
22  ('Fiat', 'Bravo'),
23  ('Fiat', 'Panda'),
24  ('Fiat', '500'),
25  ('Honda', 'Jazz'),
26  ('Hyundai', 'i10'),
27  ('Kia', 'Rio'),
28  ('Mazda', '2'),
29  ('Nissan', 'Micra '),
30  ('Opel', 'Adam'),
31  ('Opel', 'Karl'),
32  ('Opel', 'Corsa'),
33  ('Renault', 'Twingo'),
34  ('Renault', 'Zoe'),
35  ('Renault', 'Clio'),
36  ('Skoda', 'Citigo'),
37  ('Skoda', 'Fabia'),
38  ('Suzuki', 'Swift'),
39  ('Toyota', 'Yaris');
40
41CREATE TABLE IF NOT EXISTS `Proprietary` (
42  `idUser` int(6) unsigned NOT NULL AUTO_INCREMENT,
43  `Name` varchar(200) NOT NULL,
44  `FirstName` varchar(200) NOT NULL,
45  `idCar` int(6) unsigned NULL ,
46  PRIMARY KEY (`idUser`)
47) DEFAULT CHARSET=utf8;
48
49INSERT INTO `Proprietary` (`Name`, `FirstName`, `idCar`) VALUES
50  ('Dupont', 'Jean', 1)
51  ('Dupont', 'Céline', 2),
52  ('Philippe', 'Jean', null),
53  ('Doux', 'Thomas', 9);