Sélectionner une révision Git
-
Pierre PRAT a rédigéPierre PRAT a rédigé
base.sql 1,05 Kio
CREATE TABLE public.users
(
id SERIAL,
pseudo character varying(255) NOT NULL,
mdp text NOT NULL,
adr_mail character varying(255) NOT NULL,
su boolean DEFAULT false,
CONSTRAINT users_pkey PRIMARY KEY (id)
);
CREATE TABLE public.toppics
(
id SERIAL,
titre character varying(255) NOT NULL,
content text,
date_creat date,
users_id SERIAL,
CONSTRAINT toppics_pkey PRIMARY KEY (id),
CONSTRAINT toppics_fkey FOREIGN KEY(users_id) REFERENCES users
);
CREATE TABLE public.comments
(
id SERIAL,
content text NOT NULL,
date date,
toppics_id SERIAL,
users_id SERIAL,
CONSTRAINT comments_pkey PRIMARY KEY (id),
CONSTRAINT comments_fkey FOREIGN KEY(toppics_id) REFERENCES toppics,
CONSTRAINT comments_fkey2 FOREIGN KEY(users_id) REFERENCES users
);
CREATE TABLE public.keys
(
id SERIAL,
name character varying(255) NOT NULL
);
CREATE TABLE public.keyToppics
(
keys_id SERIAL,
toppics_id SERIAL,
CONSTRAINT keyToppics_fk FOREIGN KEY(toppics_id) REFERENCES toppics,
CONSTRAINT keyToppics_fk2 FOREIGN KEY(keys_id) REFERENCES users
);