From 85534f576e13cbb05d48f2c8210c917a38085c3a Mon Sep 17 00:00:00 2001 From: root Date: Thu, 5 Mar 2020 13:02:26 +0100 Subject: sql comment --- web/website/init-bd.sql | 30 +++--------------------------- 1 file changed, 3 insertions(+), 27 deletions(-) (limited to 'web') 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) ); + + -- cgit v1.2.3