3Sm9PZCP

1DROP DATABASE IF EXISTS MLR2;
2
3CREATE DATABASE IF NOT EXISTS MLR2;
4USE MLR2;
5# -----------------------------------------------------------------------------
6#       TABLE : COMMANDE
7# -----------------------------------------------------------------------------
8
9CREATE TABLE IF NOT EXISTS COMMANDE
10 (
11   ID DB_INTEGER(2) NOT NULL  ,
12   ID_COMMANDER DB_TEXT, 255 NOT NULL  ,
13   DATECOMMANDE DB_DATE(8) NULL  
14   , PRIMARY KEY (ID) 
15 ) 
16 comment = "";
17
18# -----------------------------------------------------------------------------
19#       TABLE : CLIENT
20# -----------------------------------------------------------------------------
21
22CREATE TABLE IF NOT EXISTS CLIENT
23 (
24   ID DB_TEXT, 255 NOT NULL  ,
25   RAISONSOCIALE DB_TEXT, 255 NULL  
26   , PRIMARY KEY (ID) 
27 ) 
28 comment = "";
29
30# -----------------------------------------------------------------------------
31#       TABLE : PRODUIT
32# -----------------------------------------------------------------------------
33
34CREATE TABLE IF NOT EXISTS PRODUIT
35 (
36   ID DB_TEXT, 255 NOT NULL  ,
37   DESIGNPROD DB_TEXT, 255 NULL  ,
38   PUHTPROD DB_DOUBLE(10,2) NULL  ,
39   STOCKPROD DB_INTEGER(2) NULL  
40   , PRIMARY KEY (ID) 
41 ) 
42 comment = "";
43
44# -----------------------------------------------------------------------------
45#       TABLE : CONTENU_COMMANDE
46# -----------------------------------------------------------------------------
47
48CREATE TABLE IF NOT EXISTS CONTENU_COMMANDE
49 (
50   ID DB_INTEGER(2) NOT NULL  ,
51   ID_1 DB_TEXT, 255 NOT NULL  ,
52   IDPRODUIT DB_TEXT, 255 NULL  ,
53   QUANTITECOMMANDEE DB_INTEGER(2) NULL  
54   , PRIMARY KEY (ID,ID_1) 
55 ) 
56 comment = "";
57
58
59# -----------------------------------------------------------------------------
60#       CREATION DES REFERENCES DE TABLE
61# -----------------------------------------------------------------------------
62
63
64ALTER TABLE COMMANDE 
65  ADD FOREIGN KEY FK_COMMANDE_CLIENT (ID_COMMANDER)
66      REFERENCES CLIENT (ID) ;
67
68
69ALTER TABLE CONTENU_COMMANDE 
70  ADD FOREIGN KEY FK_CONTENU_COMMANDE_COMMANDE (ID)
71      REFERENCES COMMANDE (ID) ;
72
73
74ALTER TABLE CONTENU_COMMANDE 
75  ADD FOREIGN KEY FK_CONTENU_COMMANDE_PRODUIT (ID_1)
76      REFERENCES PRODUIT (ID) ;