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 38 39 40 41 42 43 44 45 46
| CREATE TABLE INVITE
(
pseudo VARCHAR (32) NOT NULL,
mail VARCHAR (32),
website VARCHAR (32),
PRIMARY KEY (pseudo)
)
CREATE TABLE MEMBRE
(
login VARCHAR (32) NOT NULL,
pseudo VARCHAR (32) NOT NULL,
passwd VARCHAR (32),
inscdate DATE,
lvl INTEGER,
PRIMARY KEY (login),
FOREIGN KEY (pseudo) REFERENCES INVITE (pseudo)
)
CREATE TABLE PHOTO
(
idPhoto NUMBER (6) NOT NULL,
login VARCHAR (32) NOT NULL,
pathImg VARCHAR (32),
nameImg VARCHAR (32),
hauteur INTEGER,
largeur INTEGER,
poids INTEGER,
nbrVus INTEGER,
PRIMARY KEY (idPhoto),
FOREIGN KEY (login) REFERENCES MEMBRE (LOGIN)
)
CREATE TABLE COMMENTAIRE
(
idCommentaire NUMBER (6) NOT NULL,
idPhoto NUMBER (6) NOT NULL,
pseudo VARCHAR (32) NOT NULL,
datePost DATE,
ipPosteur VARCHAR (32),
titecommentaire VARCHAR (32),
message BLOB,
PRIMARY KEY (idCommentaire),
FOREIGN KEY (idPhoto) REFERENCES photo (idPhoto),
FOREIGN (pseudo) REFERENCES INVITE (pseudo)
) |
Partager