· 9 years ago · Oct 31, 2016, 08:08 PM
1DROP TABLE IF EXISTS Reponses;
2CREATE TABLE Reponses
3(
4 id INT AUTO_INCREMENT,
5 cle_questionnaire VARCHAR(12),
6 utilisateurs VARCHAR(20) DEFAULT "Inconnu",
7 rang INT NOT NULL,
8 date_creation DATETIME DEFAULT CURRENT_TIMESTAMP,
9 reponse VARCHAR(100) NOT NULL,
10 CONSTRAINT PK_id PRIMARY KEY(id),
11 CONSTRAINT FK_cle FOREIGN KEY(cle_questionnaire) REFERENCES Questionnaire(cle) ON DELETE CASCADE ON UPDATE CASCADE
12)ENGINE=INNODB;