sql init example

1 files changed, 32 insertions, 0 deletions

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
+--);