diff options
Diffstat (limited to 'init-bd.sql')
-rw-r--r-- | init-bd.sql | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/init-bd.sql b/init-bd.sql new file mode 100644 index 0000000..1ed1f3b --- /dev/null +++ b/init-bd.sql @@ -0,0 +1,22 @@ +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'); |