diff options
author | root <clyhtsuriva@gmail.com> | 2020-03-01 21:18:29 +0100 |
---|---|---|
committer | root <clyhtsuriva@gmail.com> | 2020-03-01 21:18:29 +0100 |
commit | 30e5e0279463f67d94b1c0f55f2fda97bcf9b1df (patch) | |
tree | d347edbdc3a2a57b4be76c93c65841b8cd746723 /web/website/init-bd.sql | |
parent | 32dfd7da66bce3d39812cecf5aba5ef6f8c97c0b (diff) |
password protection
Diffstat (limited to 'web/website/init-bd.sql')
-rw-r--r-- | web/website/init-bd.sql | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/web/website/init-bd.sql b/web/website/init-bd.sql new file mode 100644 index 0000000..6cd080f --- /dev/null +++ b/web/website/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 +--); |