From 32dfd7da66bce3d39812cecf5aba5ef6f8c97c0b Mon Sep 17 00:00:00 2001
From: root <clyhtsuriva@gmail.com>
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

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