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
| #
# Structure de la table `type_matiere_premiere`
#
CREATE TABLE type_matiere_premiere (
code_typ_mat_pre int(20) NOT NULL auto_increment,
code_mat_pre varchar(20) NOT NULL default '',
couleur varchar(20) NOT NULL default '',
des_typ_mat_pre varchar(20) NOT NULL default '',
code_four varchar(20) NOT NULL default '',
PRIMARY KEY (code_typ_mat_pre)
) TYPE=MyISAM;
#
# Structure de la table `consommer`
#
CREATE TABLE consommer (
qte_mat_pre varchar(20) NOT NULL default '',
code_typ_mat_pre varchar(20) NOT NULL default '',
n_art varchar(20) NOT NULL default '',
PRIMARY KEY (code_typ_mat_pre,n_art)
) TYPE=MyISAM;
#
# Structure de la table `entree_stock`
#
CREATE TABLE entree_stock (
code_stock int(20) NOT NULL auto_increment,
code_typ_mat_pre int(20) NOT NULL default '0',
pr_ttc float NOT NULL default '0',
qte_stock float NOT NULL default '0',
PRIMARY KEY (code_stock,code_typ_mat_pre)
) TYPE=MyISAM;
#
# Structure de la table `article`
#
CREATE TABLE article (
n_art int(20) NOT NULL auto_increment,
lib_art varchar(20) NOT NULL default '',
prof_art varchar(20) NOT NULL default '',
long_art varchar(20) NOT NULL default '',
larg_art varchar(20) NOT NULL default '',
haut_art varchar(20) NOT NULL default '',
tum_art varchar(20) NOT NULL default '',
tmc_art varchar(20) NOT NULL default '',
n_clt varchar(20) NOT NULL default '',
n_bon_liv varchar(20) NOT NULL default '',
remise_art varchar(20) NOT NULL default '',
n_cat varchar(20) NOT NULL default '',
qte_art varchar(20) NOT NULL default '',
PRIMARY KEY (n_art,n_clt,n_bon_liv,n_cat)
) TYPE=MyISAM; |
Partager