From 32dfd7da66bce3d39812cecf5aba5ef6f8c97c0b Mon Sep 17 00:00:00 2001 From: root Date: Sun, 1 Mar 2020 20:02:45 +0100 Subject: sql init example --- web/init-bd.sql | 32 ++++++++++++++++++++++++++++++++ 1 file changed, 32 insertions(+) create mode 100644 web/init-bd.sql (limited to 'web') diff --git a/web/init-bd.sql b/web/init-bd.sql new file mode 100644 index 0000000..6cd080f --- /dev/null +++ b/web/init-bd.sql @@ -0,0 +1,32 @@ +--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'); +*/ + +--drop table if exists aaa cascade; + +--create table aaa( +-- bbb ccc ddd +--); -- cgit v1.2.3