1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76
| CREATE TABLE `marque` (
`id` tinyint(4) NOT NULL auto_increment,
`nom` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
);
insert into `marque` values
(1,'HONDA'),
(2,'KAWASAKI'),
(3,'KTM'),
(4,'SUZUKI'),
(5,'YAMAHA');
CREATE TABLE `modele` (
`id` tinyint(4) NOT NULL auto_increment,
`modele` varchar(50) NOT NULL,
`idMarque` tinyint(4) default NULL,
PRIMARY KEY (`id`)
) ;
insert into `modele` values
(1,'CR125R',1),
(2,'CR250R',1),
(3,'CRF250R',1),
(4,'CRF450R',1),
(5,'KX125',2),
(6,'KX250',2),
(7,'KX250F',2),
(8,'KX450F',2),
(9,'125SX',3),
(10,'144SX',3),
(11,'150SX',3),
(12,'250SX',3),
(13,'250SX-F',3),
(14,'350SX-F',3),
(15,'450SX-F',3),
(16,'RM125',4),
(17,'RM250',4),
(18,'RM-Z250',4),
(19,'RM-Z450',4),
(20,'YZ125',5),
(21,'YZ250',5),
(22,'YZ250F',5),
(23,'YZ450F',5);
CREATE TABLE `annee` (
`id` tinyint(4) NOT NULL auto_increment,
`annee` varchar(50) NOT NULL,
`idModele` tinyint(4) default NULL,
PRIMARY KEY (`id`)
) ;
insert into `annee` values
(1,'2007',1),
(2,'2006',1),
(3,'2005',1),
(4,'2004',1),
(5,'2008',2),
(6,'2007',2),
(7,'2006',2),
(8,'2005',2),
(9,'2015',3),
(10,'2014',3),
(11,'2013',3),
(12,'2012',3),
(13,'2011',3),
(14,'2010',3),
(15,'2009',3),
(16,'2015',4),
(17,'2014',4),
(18,'2013',4),
(19,'2012',4),
(20,'2015',5),
(21,'2014',5),
(22,'2013',5),
(23,'2012',5); |
Partager