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 34 35 36 37
| CREATE TABLE USERS(
NOM VARCHAR(30) NOT NULL,
PRENOM VARCHAR(30),
TEL VARCHAR(50),
COURRIEL VARCHAR(100) NOT NULL,
PHOTO VARCHAR(100),
ROLE VARCHAR(50) DEFAULT 'user' NOT NULL,
ID_CATEGO SMALLINT UNSIGNED,
PRIMARY KEY (COURRIEL),
CONSTRAINT FK_ID_CATEGO
FOREIGN KEY (ID_CATEGO)
REFERENCES CATEGORIE(ID_CATEGO)
)ENGINE = INNODB;
CREATE TABLE ADRESSE(
PAYSVARCHAR(30),
PROVINCE VARCHAR(30),
VILLEVARCHAR(50),
MUNICI VARCHAR(50),
RUE VARCHAR(50),
COURRIEL VARCHAR(50)
CODE_POS VARCHAR(10) NOT NULL,
NUMERO VARCHAR(20),
ID_ADR SMALLINT NOT NULL AUTO_INCREMENT,
PRIMARY KEY (ID_ADR),
CONSTRAINT FK_ID_COURRIEL
FOREIGN KEY (COURRIEL)
REFERENCES USERS(COURRIEL),
)
ENGINE = INNODB;
CREATE TABLE CATEGORIE(
ID_CATEGO SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
NOM_CATEGO VARCHAR(50) NOT NULL,
MOT_CLE VARCHAR(50) NOT NULL,
PRIMARY KEY (ID_CATEGO)
)ENGINE = INNODB; |
Partager