hisSrixZ

1DROP TABLE IF EXISTS category CASCADE;
2DROP TABLE IF EXISTS activity CASCADE;
3DROP TABLE IF EXISTS post CASCADE;
4
5CREATE TABLE category(
6	id INTEGER  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(15) NULL,
16	email varchar(250) NULL,
17    gpxLong  FLOAT ,
18    gbxLat FLOAT ,
19    url_image TEXT 
20);
21CREATE TABLE post(
22	title varchar(250) NOT NULL,
23	description TEXT NOT NULL,
24	name varchar(250) NOT NULL,
25	phone varchar(15),
26	email varchar(250),
27    constraint key primary key(name, title),
28    gpsLong  FLOAT ,
29    gbsLat FLOAT 
30);
31
32
33INSERT INTO category(id,name) values(1,'outdoor');
34INSERT INTO category(id,name) values(2,'cinema');
35INSERT INTO category(id,name) values(3,'shop');
36INSERT INTO category(id,name) values(4,'all');
37
38INSERT INTO activity(title,idcat,description,name,phone,email,url_image) values('Visite Chateau caen',3,'une visite guidée','mairie caen','0665124212','siirhb2o@gmail.com','http://www.caen-tourisme.fr/sites/default/files/cae_4034_-_copie.jpg');
39INSERT INTO activity(title,idcat,description,name,url_image) values ('SOLDES 50 %',4,'Votre magasin Propose des soldes allant a 50%','Magasin TOTO','http://www.promociel.fr/media/catalog/product/cache/2/image/650x/040ec09b1e35df139433887a97daa66f/b/a/baroque-50_60x30cm_2.gif');
40
41
42
43INSERT INTO post(title,description,name) values('Chat Perdu','je chercher mon chat qui a ete perdu avant hier sur la rue ec' ,'Julie');
44INSERT INTO post(title,description,name) values('colocation','bonjour , jeune etudiant je cherche une colocation a partir de mai' ,'Sami');