vRLkhVXt

1-- -----------------------------------------------------
2-- Schema 1718he201265
3-- -----------------------------------------------------
4CREATE SCHEMA IF NOT EXISTS `1718he201265` DEFAULT CHARACTER SET utf8 ;
5SHOW WARNINGS;
6USE `1718he201265` ;
7
8-- -----------------------------------------------------
9-- Table `tbUser`
10-- -----------------------------------------------------
11DROP TABLE IF EXISTS `tbUser` ;
12
13SHOW WARNINGS;
14CREATE TABLE IF NOT EXISTS `tbUser` (
15  `uId` INT UNSIGNED NOT NULL AUTO_INCREMENT,
16  `uPseudo` CHAR(20) NOT NULL,
17  `uEmail` CHAR(50) NOT NULL,
18  `uSemence` CHAR(32) NOT NULL,
19  `uMdp` CHAR(32) NOT NULL,
20  `uQuestion` VARCHAR(100) NULL DEFAULT 'null',
21  `uReponse` VARCHAR(50) NULL DEFAULT 'null',
22  `uAvatar` BLOB NULL,
23  `uDateCreation` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
24  PRIMARY KEY (`uId`,`uPseudo`),
25  UNIQUE KEY `uPseudo_UNIQUE` (`uPseudo`),
26  UNIQUE KEY `uId_UNIQUE` (`uId`),
27  UNIQUE KEY `uEmail_UNIQUE` (`uEmail`)
28
29-- -----------------------------------------------------
30-- Table `tbProfil`
31-- -----------------------------------------------------
32DROP TABLE IF EXISTS `tbProfil` ;
33
34SHOW WARNINGS;
35CREATE TABLE IF NOT EXISTS `tbProfil` (
36  `pId` INT UNSIGNED NOT NULL AUTO_INCREMENT,
37  `pNom` CHAR(20) NOT NULL,
38  `pAbrev` CHAR(10) NOT NULL,
39  `pIcon` BLOB NULL,
40  `pEstStatus` TINYINT(4)) NULL DEFAULT 1,
41  PRIMARY KEY (`pId`),
42  UNIQUE KEY `pNom_UNIQUE` (`pNom`),
43  UNIQUE KEY `pAbrev_UNIQUE` (`pAbrev`)
44
45-- -----------------------------------------------------
46-- Table `tbUserProfil`
47-- -----------------------------------------------------
48DROP TABLE IF EXISTS `tbUserProfil` ;
49
50SHOW WARNINGS;
51CREATE TABLE IF NOT EXISTS `tbUserProfil` (
52  `pId` INT UNSIGNED NOT NULL,
53  `uId` INT UNSIGNED NOT NULL,
54  `upDataDebut` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
55PRIMARY KEY (`uId`,`pId`),
56  KEY `fk_tbUserProfil_tbProfil1_idx` (`pId`),
57  CONSTRAINT `fk_tbUserProfil_tbProfil1`
58    FOREIGN KEY (`pId`)
59    REFERENCES `tbProfil` (`pId`)
60    ON DELETE RESTRICT
61    ON UPDATE CASCADE,
62  CONSTRAINT `fk_tbUserProfil_tbUser`
63    FOREIGN KEY (`uId`)
64    REFERENCES `tbUser` (`uId`)
65    ON DELETE RESTRICT
66    ON UPDATE CASCADE)
67
68-