From 703c1c623892d69d8e24af68b31d84495301ca02 Mon Sep 17 00:00:00 2001
From: Clyhtsuriva Synck <clyhtsuriva>
Date: Sun, 1 Mar 2020 15:14:15 +0100
Subject: initial files

---
 init-bd.sql | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)
 create mode 100644 init-bd.sql

(limited to 'init-bd.sql')

diff --git a/init-bd.sql b/init-bd.sql
new file mode 100644
index 0000000..1ed1f3b
--- /dev/null
+++ b/init-bd.sql
@@ -0,0 +1,22 @@
+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');
-- 
cgit v1.2.3