gWWjkhjF

1DROP TABLE IF EXISTS category CASCADE;
2DROP TABLE IF EXISTS activity CASCADE;
3DROP TABLE IF EXISTS post CASCADE;
4
5CREATE TABLE category(
6	id SERIAL PRIMARY KEY NOT NULL,
7	name varchar(250) NOT NULL
8);
9CREATE TABLE activity(
10	id SERIAL PRIMARY KEY NOT NULL,
11    idcat INTEGER REFERENCES category(id),
12	title varchar(250) NOT NULL,
13	description TEXT NOT NULL,
14	name varchar(250) NOT NULL,
15	phone varchar(10) NULL,
16	email varchar(250)
17);
18CREATE TABLE post(
19	title varchar(250) NOT NULL,
20	description TEXT NOT NULL,
21	name varchar(250) NOT NULL,
22	phone varchar(10),
23	email varchar(250),
24    constraint key primary key(name, title)
25);
26
27
28INSERT INTO category(name) values('bar');
29INSERT INTO category(name) values('concert');
30INSERT INTO category(name)  values('monument');
31
32
33
34
35INSERT INTO activity(title,idcat,description,name) values('soiree etudiants ',(SELECT id from category WHERE name='bar'),'Orient organise une soiree etudiants','orient express');
36INSERT INTO activity(title,idcat,description,name) values('concert ACDC',(SELECT id from category WHERE name='concert'),'derniere concert acdc a ne pas rater','Caen Events');
37INSERT INTO activity(title,idcat,description,name) values('Visite Chateau caen',(SELECT id from category WHERE name='monument'),'une visite guidée','mairie caen');
38
39INSERT INTO post(title,description,name) values('Chat Perdu','je chercher mon chat qui a ete perdu avant hier sur la rue ec' ,'Julie');
40INSERT INTO post(title,description,name) values('colocation','bonjour , jeune etudiant je cherche une colocation a partir de mai' ,'Sami');