QkjhZ401

1DROP TABLE IF EXISTS Facture;
2CREATE TABLE Facture
3(
4	code_facture INT(3),
5	date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
6	total FLOAT DEFAULT 0,
7	code_client INT(3) NOT NULL,
8	CONSTRAINT pk_cde_facture PRIMARY KEY(code_facture),
9	CONSTRAINT fk_code_client FOREIGN KEY(code_client) REFERENCES Client(code_client)
10) ENGINE=INNODB;
11
12
13
14DROP TABLE IF EXISTS Detail;
15CREATE TABLE Detail
16(
17	code_facture INT(3) DEFAULT 0,
18	code_article INT(3),
19	qte INT(20) NOT NULL,
20	Libelle VARCHAR(50) DEFAULT 'Inconnu',
21	total FLOAT DEFAULT 0,
22	taux FLOAT NOT NULL,
23	
24	CONSTRAINT pk_codefacture PRIMARY KEY(code_facture, code_article),
25	
26	CONSTRAINT fk_code_facture FOREIGN KEY(code_facture) REFERENCES Facture(code_facture),
27	CONSTRAINT fk_code_article FOREIGN KEY(code_article) REFERENCES Article(code_article)
28) ENGINE=INNODB;