aboutsummaryrefslogtreecommitdiff
path: root/web/website/init-bd.sql
diff options
context:
space:
mode:
Diffstat (limited to 'web/website/init-bd.sql')
-rw-r--r--web/website/init-bd.sql30
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)
);
+
+