1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| CREATE TABLE `annee` (
`id` int(4) NOT NULL auto_increment,
`annee` varchar(50) NOT NULL,
`idModele` tinyint(4) default NULL,
`url` varchar(80) NOT NULL,
PRIMARY KEY (`id`)
) ;
insert into `annee` values
(1,'2007',1,"spring/honda/125cr2007.html"),
(2,'2006',1,"spring/honda/125cr2006.html"),
(3,'2005',1,"spring/honda/125cr2005.html"),
(4,'2004',1,"spring/honda/125cr2004.html"),
(5,'2003',1,"spring/honda/125cr2003.html"),
(6,'2002',1,"spring/honda/125cr2002.html"),
(7,'2001',1,"spring/honda/125cr2001.html"),
(8,'2000',1,"spring/honda/125cr2000.html"),
(9,'1999',1,"spring/honda/125cr1999.html"),
(10,'2008',2,"spring/honda/250cr2008.html"),
(11,'2007',2,"spring/honda/250cr2007.html"),
(12,'2006',2,"spring/honda/250cr2006.html"),
(13,'2005',2,"spring/honda/250cr2005.html"),
(14,'2004',2,"spring/honda/250cr2004.html"); |
Partager