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 30 31 32 33
|
CREATE TABLE Pays (
pay_id INT(4) NOT NULL AUTO_INCREMENT,
pay_nom VARCHAR(45) NOT NULL,
PRIMARY KEY(pay_id)
)
TYPE=InnoDB;
CREATE TABLE Personne (
per_id INT(11) NOT NULL AUTO_INCREMENT,
per_nom VARCHAR(25) NOT NULL,
per_prenom VARCHAR(25) NOT NULL,
per_sexe CHAR NOT NULL,
per_dateNaiss DATE NOT NULL,
per_email VARCHAR(45) NOT NULL,
per_login VARCHAR(20) NOT NULL,
per_password VARCHAR(12) NOT NULL,
per_npa VARCHAR(10) NOT NULL,
per_localite VARCHAR(45) NOT NULL,
per_adresse TEXT NULL,
pay_id INT(4) NOT NULL,
per_statut CHAR NULL,
PRIMARY KEY(per_id),
UNIQUE INDEX Index_login(per_login),
INDEX Personne_FKIndex1(pay_id),
FOREIGN KEY(pay_id)
REFERENCES Pays(pay_id)
ON DELETE RESTRICT
ON UPDATE RESTRICT
)
TYPE=InnoDB; |
Partager