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
|
CREATE TABLE `tb_shirt` (
`id_shirt` smallint(7) unsigned zerofill NOT NULL auto_increment,
`titre_shirt` varchar(50) NOT NULL default '',
`description_shirt` longtext NOT NULL,
`photo_shirt` varchar(100) NOT NULL default '',
`dessin_shirt` varchar(150) NOT NULL default '',
`prix_u_shirt` float(5,2) NOT NULL default '0.00',
`nbvisite_shirt` smallint(7) NOT NULL default '0',
`date_ajout_shirt` date NOT NULL default '0000-00-00',
PRIMARY KEY (`id_shirt`)
)
CREATE TABLE `tb_stock` (
`id_stock` smallint(7) unsigned zerofill NOT NULL auto_increment,
`quantite_stock` smallint(7) NOT NULL default '0',
`id_shirt` smallint(7) unsigned zerofill NOT NULL default '0000000',
`id_taille` smallint(2) unsigned zerofill NOT NULL default '00',
PRIMARY KEY (`id_stock`)
)
CREATE TABLE `tb_taille` (
`id_taille` smallint(2) unsigned zerofill NOT NULL auto_increment,
`libelle_taille` varchar(50) NOT NULL default '',
`sexe_taille` varchar(30) NOT NULL default '',
PRIMARY KEY (`id_taille`)
) |
Partager