PEHpP8GW

1DROP TABLE IF EXISTS Admininistrateur ;
2CREATE TABLE Admininistrateur (idAdmin INT(8)  AUTO_INCREMENT NOT NULL,
3login VARCHAR(32),
4password VARCHAR(128),
5PRIMARY KEY (idAdmin) ) ENGINE=InnoDB;
6
7DROP TABLE IF EXISTS Api ;
8CREATE TABLE Api (idApi INT(8)  AUTO_INCREMENT NOT NULL,
9group INT(8),
10type INT(8),
11libelle VARCHAR(64),
12params VARCHAR(128),
13description VARCHAR(128),
14example TEXT,
15PRIMARY KEY (idApi) ) ENGINE=InnoDB;
16
17DROP TABLE IF EXISTS Ajouter ;
18CREATE TABLE Ajouter (idApi INT(8)  AUTO_INCREMENT NOT NULL,
19idAdmin INT(8) NOT NULL,
20PRIMARY KEY (idApi,
21 idAdmin) ) ENGINE=InnoDB;
22
23ALTER TABLE Ajouter ADD CONSTRAINT FK_Ajouter_idApi FOREIGN KEY (idApi) REFERENCES Api (idApi);
24
25ALTER TABLE Ajouter ADD CONSTRAINT FK_Ajouter_idAdmin FOREIGN KEY (idAdmin) REFERENCES Admininistrateur (idAdmin);