5vvuGW35

1DROP TABLE IF EXISTS `comenzi_392`.`antet_com`;
2
3
4
5DROP TABLE IF EXISTS `comenzi_392`.`furnizori`;
6CREATE TABLE  `comenzi_392`.`furnizori` (
7  `ID_F` int(10) unsigned NOT NULL auto_increment 
8  COMMENT 'Id funizor',
9  `NUME` varchar(30) NOT NULL COMMENT 'Nume 
10  furnizor',
11  `CUI` varchar(45) NOT NULL COMMENT 'Cod de 
12  inregistrare',
13  `Adresa` varchar(50) NOT NULL COMMENT 'Adresa 
14  furnizor',
15  `Telefon` varchar(20) NOT NULL COMMENT 'Telefon',
16  PRIMARY KEY  (`ID_F`)
17) ENGINE=InnoDB DEFAULT CHARSET=utf8;
18
19DROP TABLE IF EXISTS `comenzi_392`.`produse`;
20CREATE TABLE  `comenzi_392`.`produse` (
21  `ID_P` int(10) unsigned NOT NULL auto_increment 
22  COMMENT 'ID produs',
23  `Desc` varchar(30) NOT NULL COMMENT 'Descroere 
24  produs',
25  `ID_FP` int(10) unsigned NOT NULL default '0',
26  `U_mas` varchar(10) NOT NULL COMMENT 'unitate de 
27  masura',
28  `Pret_u` decimal(9,2) default NULL COMMENT 'pret 
29  unitar',
30  `Data_ora_p` datetime NOT NULL COMMENT 'Inceput 
31  Valabilitate',
32  PRIMARY KEY  USING BTREE (`ID_P`,`ID_FP`),
33  KEY `FK_produse_furnizori` (`ID_FP`),
34  CONSTRAINT `FK_produse_furnizori` FOREIGN KEY 
35  (`ID_FP`) REFERENCES `furnizori` (`ID_F`) ON 
36  UPDATE CASCADE
37) ENGINE=InnoDB DEFAULT CHARSET=utf8;
38
39CREATE TABLE  `comenzi_392`.`antet_com` (
40  `ID_C` int(10) unsigned NOT NULL auto_increment 
41  COMMENT 'ID Comanda',
42  `ID_FC` int(10) unsigned NOT NULL COMMENT 'Catre 
43  Furnizor',
44  `Nr_linii` decimal(3,0) NOT NULL COMMENT 'Numar 
45  linii',
46  `Data_ora_c` datetime NOT NULL COMMENT 'Timp 
47  emitere',
48  `Pret_c` decimal(15,2) unsigned NOT NULL COMMENT 
49  'Pret total',
50  PRIMARY KEY  USING BTREE (`ID_C`,`ID_FC`),
51  KEY `FK_antet_com_furnizori` (`ID_FC`),
52  CONSTRAINT `FK_antet_com_furnizori` FOREIGN KEY 
53  (`ID_FC`) REFERENCES `furnizori` (`ID_F`) ON 
54  UPDATE CASCADE
55) ENGINE=InnoDB DEFAULT CHARSET=utf8;
56
57DROP TABLE IF EXISTS `comenzi_392`.`linii_c`;
58CREATE TABLE  `comenzi_392`.`linii_c` (
59  `ID_CL` int(10) unsigned NOT NULL default '0' 
60  COMMENT 'Comanda',
61  `Nr_linie` decimal(7,0) NOT NULL COMMENT 'Linia 
62  numarul',
63  `ID_PL` int(10) unsigned NOT NULL COMMENT 
64  'Produs',
65  `Cant` decimal(6,2) NOT NULL COMMENT 'cantitate',
66  `Pret_l` decimal(15,2) NOT NULL COMMENT 'Pret 
67  linie',
68  PRIMARY KEY  (`ID_CL`,`ID_PL`),
69  KEY `FK_linii_c_produse` (`ID_PL`),
70  CONSTRAINT `FK_linii_c_antet_com` FOREIGN KEY 
71  (`ID_CL`) REFERENCES `antet_com` (`ID_C`) ON 
72  UPDATE CASCADE,
73  CONSTRAINT `FK_linii_c_produse` FOREIGN KEY 
74  (`ID_PL`) REFERENCES `produse` (`ID_P`) ON UPDATE 
75  CASCADE
76) ENGINE=InnoDB DEFAULT CHARSET=utf8;