Mercurial > gemma

annotate schema/demo-data/users.sql @ 138:c79709af2c76

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Demo Data: make user.sql atomic and use copy everywhere.
author Sascha Wilde <wilde@intevation.de>
date Fri, 29 Jun 2018 17:24:14 +0200
parents 433a992befdb
children 0c0826063561
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
138
c79709af2c76 Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents: 137
diff changeset
1 BEGIN;
c79709af2c76 Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents: 137
diff changeset
2
137
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
3 -- PREREQUISITES
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
4
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
5 -- Setup Country Codes
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
6 COPY gemma.countries (country_code) FROM stdin;
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
7 RO
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
8 HU
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
9 SK
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
10 AT
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
11 HR
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
12 BG
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
13 \.
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
14
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
15 -- USERS
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
16
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
17 -- System Administrator
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
18 CREATE ROLE sophie IN ROLE sys_admin LOGIN PASSWORD 'so2Phie4';
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
19
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
20 -- Water Way Administrators
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
21 CREATE ROLE lucian IN ROLE waterway_admin LOGIN PASSWORD 'lu2Cian4';
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
22 CREATE ROLE penka IN ROLE waterway_admin LOGIN PASSWORD 'pe2Nka3';
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
23
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
24 -- Water Way Users
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
25 CREATE ROLE oana IN ROLE waterway_user LOGIN PASSWORD 'oa2Na2';
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
26 CREATE ROLE vanja IN ROLE waterway_user LOGIN PASSWORD 'va2Nja3';
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
27
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
28 -- Fill in Profiles
138
c79709af2c76 Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents: 137
diff changeset
29 COPY gemma.user_profiles (username, country, email_adress) FROM stdin;
c79709af2c76 Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents: 137
diff changeset
30 sophie AT sophie@example.com
c79709af2c76 Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents: 137
diff changeset
31 lucian RO lucian@example.com
c79709af2c76 Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents: 137
diff changeset
32 oana RO oana@example.com
c79709af2c76 Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents: 137
diff changeset
33 penka BG penka@example.com
c79709af2c76 Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents: 137
diff changeset
34 vanja BG vanja@example.com
c79709af2c76 Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents: 137
diff changeset
35 \.
c79709af2c76 Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents: 137
diff changeset
36
c79709af2c76 Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents: 137
diff changeset
37 COMMIT;