diff options
| -rw-r--r-- | web/website/init-bd.sql | 30 |
1 files changed, 3 insertions, 27 deletions
diff --git a/web/website/init-bd.sql b/web/website/init-bd.sql index 00120c9..f1a4f2b 100644 --- a/web/website/init-bd.sql +++ b/web/website/init-bd.sql @@ -1,30 +1,4 @@ ---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'); -*/ - +--Creation of the main table drop table if exists trame cascade; create table trame( @@ -34,3 +8,5 @@ create table trame( source varchar(100), destination varchar(100) ); + + |