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
| CREATE TABLE Pays
(IdPays VARCHAR(3) NOT NULL,
Numero VARCHAR(3) NOT NULL,
Libelle VARCHAR(20) NOT NULL,
PRIMARY KEY (IdPays)) TYPE=INNODB;
CREATE TABLE Busi
(IdBusi INT NOT NULL AUTO_INCREMENT,
Nom VARCHAR(20) NOT NULL,
Prenom VARCHAR(30) NOT NULL,
Ville VARCHAR(20) NOT NULL,
CodePost VARCHAR(20),
Tel VARCHAR(15),
Email VARCHAR(50) NOT NULL,
MDP VARCHAR(100) NOT NULL,
Avatar BLOB,
PRIMARY KEY (IdBusi),
INDEX (IdPays),
FOREIGN KEY (IdPays) REFERENCES Pays (IdPays) ON UPDATE CASCADE ON DELETE CASCADE) TYPE=INNODB;
CREATE TABLE Message
(IdMessage INT NOT NULL AUTO_INCREMENT,
Libelle VARCHAR(1000) NOT NULL,
DateMsg VARCHAR(30) NOT NULL,
Delai INT NOT NULL,
Photo BLOB,
PRIMARY KEY (IdMessage),
INDEX (IdBusi),
FOREIGN KEY (IdBusi) REFERENCES Busi (IdBusi) ON UPDATE CASCADE ON DELETE CASCADE) TYPE=INNODB; |
