aboutsummaryrefslogtreecommitdiff
path: root/web
diff options
context:
space:
mode:
authorroot <clyhtsuriva@gmail.com>2020-03-01 20:02:45 +0100
committerroot <clyhtsuriva@gmail.com>2020-03-01 20:02:45 +0100
commit32dfd7da66bce3d39812cecf5aba5ef6f8c97c0b (patch)
tree2296e0aa63c67dc2199445e9d2d44e658e8fb76d /web
parent0c0557a2cb4be29783c2fcbd588b74b2d5bfba1d (diff)
sql init example
Diffstat (limited to 'web')
-rw-r--r--web/init-bd.sql32
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
+--);