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
| CREATE TABLE `tb_achat` (
`id_achat` smallint(7) unsigned zerofill NOT NULL auto_increment,
`prix_unit` float(3,2) NOT NULL default '0.00',
`quantite_achat` smallint(4) NOT NULL default '0',
`id_shirt` smallint(7) unsigned zerofill NOT NULL default '0000000',
`id_cmd` smallint(7) unsigned zerofill NOT NULL default '0000000',
PRIMARY KEY (`id_achat`)
)
CREATE TABLE `tb_commande` (
`id_cmd` smallint(7) unsigned zerofill NOT NULL auto_increment,
`date_cmd` date NOT NULL default '0000-00-00',
`etat_cmd` enum('e','v','p','l') NOT NULL default 'e',
`id_clt` smallint(7) NOT NULL default '0',
PRIMARY KEY (`id_cmd`)
)
CREATE TABLE `tb_shirt` (
`id_shirt` smallint(7) unsigned zerofill NOT NULL auto_increment,
.....
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