· 10 years ago · Sep 12, 2016, 08:28 AM
1DROP TABLE IF EXISTS `CLIENT`;
2DROP TABLE IF EXISTS `COMMANDE`;
3
4create table CLIENT
5(id_client integer primary key,
6nom varchar(25) not null,
7prenom varchar(25) not null,
8adresse varchar(75),
9cp char(5),
10ville varchar(45),
11tel char(10)
12)ENGINE=INNODB;
13
14create table COMMANDE
15(id_commande integer primary key,
16date_creation date not null,
17etat char(1) not null,
18id_client int(8),
19FOREIGN KEY (id_client) REFERENCES CLIENT (id_client)
20)ENGINE=INNODB;