aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorroot <clyhtsuriva@gmail.com>2020-03-05 13:02:26 +0100
committerroot <clyhtsuriva@gmail.com>2020-03-05 13:02:26 +0100
commit85534f576e13cbb05d48f2c8210c917a38085c3a (patch)
tree5f11ecb5a8f91bd1b81dbf1cbfdfd68d11a540b0
parenteceed66fb03cc9fb916afb223d3652d70d3fd881 (diff)
sql comment
-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)
);
+
+