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
| CREATE TABLE categories
(
id serial NOT NULL,
nom varchar(255) NOT NULL,
description text,
CONSTRAINT idx_categories PRIMARY KEY (id),
CONSTRAINT unik_categories UNIQUE (id)
)
CREATE TABLE comptes
(
id serial NOT NULL,
nom varchar(255) NOT NULL,
pass varchar(255),
mail varchar(255),
auth int8 DEFAULT 1,
date_creation date,
CONSTRAINT idx_comptes PRIMARY KEY (id),
CONSTRAINT unik_comptes UNIQUE (id)
)
CREATE TABLE posts
(
id serial NOT NULL,
titre varchar(255),
texte text,
categorie_id int8 NOT NULL,
compte_id int8 NOT NULL,
date_creation date,
CONSTRAINT idx_posts PRIMARY KEY (id),
CONSTRAINT fk_posts_categories FOREIGN KEY (categorie_id)
REFERENCES categories (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk_posts_comptes FOREIGN KEY (compte_id)
REFERENCES comptes (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT unik_posts UNIQUE (id)
) |
Partager