bd-loca.sql

CREATE TABLE t_utils (login VARCHAR(50) NOT NULL PRIMARY KEY, mdp CHAR(255) NOT NULL, email VARCHAR(50) NOT NULL, type CHAR(1) NOT NULL, idAvatar INT, idLangue CHAR(2)) ENGINE = InnoDB COLLATE utf8_general_ci;

CREATE TABLE t_avatars (idAvatar INT NOT NULL PRIMARY KEY AUTO_INCREMENT, nom VARCHAR(12) UNIQUE NOT NULL) ENGINE = InnoDB COLLATE utf8_general_ci;

CREATE TABLE t_langues (idLangue CHAR(2) NOT NULL PRIMARY KEY, nom VARCHAR(20) UNIQUE NOT NULL) ENGINE = InnoDB COLLATE utf8_general_ci;

ALTER TABLE t_utils ADD CONSTRAINT PK_idAvatar FOREIGN KEY (idAvatar) REFERENCES t_avatars(idAvatar) ON DELETE RESTRICT ON UPDATE RESTRICT;
ALTER TABLE t_utils ADD CONSTRAINT PK_idLangue FOREIGN KEY (idLangue) REFERENCES t_langues(idLangue) ON DELETE RESTRICT ON UPDATE RESTRICT;