blob: 6cd080f5a4e1e330e12195be21cf7e4d68d4ba5f (
plain)
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
|
--Example used in a previous project
/*
drop table if exists util cascade;
drop table if exists contact cascade;
create table util(
id_util serial primary key,
login varchar(20) not null,
mdp varchar(20)
);
create table contact(
id_contact serial primary key,
nom varchar(100),
email varchar(100),
tel varchar(10),
adresse varchar(100),
latitude real,
longitude real,
id_util smallint not null references util
);
insert into util(login,mdp) values ('root','root');
insert into util(login,mdp) values ('pico','pico');
*/
--drop table if exists aaa cascade;
--create table aaa(
-- bbb ccc ddd
--);
|
