1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| CREATE TABLE `categorie_pieces` (
`cat_id` int(10) NOT NULL auto_increment,
`cat_nom` varchar(255) NOT NULL default '',
`cat_comment` varchar(255) NOT NULL default '',
`cat_syscomp` enum('O','N') NOT NULL default 'O',
PRIMARY KEY (`cat_id`)
) TYPE=MyISAM AUTO_INCREMENT=20 ;
CREATE TABLE `pieces` (
`pieces_id` int(10) NOT NULL auto_increment,
`cat_id` int(10) NOT NULL default '0',
`manu_id` int(10) NOT NULL default '0',
`pieces_nom` varchar(255) NOT NULL default '',
`pieces_prix` float(6,2) NOT NULL default '0.00',
`pieces_coutant` float(6,2) NOT NULL default '0.00',
`pieces_desc` varchar(255) NOT NULL default '',
`pieces_image` varchar(255) NOT NULL default 'piece_defaut.jpg',
`pieces_vedette` enum('O','N') NOT NULL default 'N',
PRIMARY KEY (`pieces_id`,`pieces_id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=81 ; |
Partager