Mercurial > gemma

comparison schema/demo-data/users.sql @ 137:433a992befdb

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added basic demo data. Started to create a set of test/demo data. For now it only contains a few user accounts for the different user roles and a bunch of responsibility_areas based on Natural Earth data.
author Sascha Wilde <wilde@intevation.de>
date Fri, 29 Jun 2018 17:15:17 +0200
parents
children c79709af2c76
comparison
equal deleted inserted replaced
136:25dba84d5703 137:433a992befdb
1 -- PREREQUISITES
2
3 -- Setup Country Codes
4 COPY gemma.countries (country_code) FROM stdin;
5 RO
6 HU
7 SK
8 AT
9 HR
10 BG
11 \.
12
13 -- USERS
14
15 -- System Administrator
16 CREATE ROLE sophie IN ROLE sys_admin LOGIN PASSWORD 'so2Phie4';
17
18 -- Water Way Administrators
19 CREATE ROLE lucian IN ROLE waterway_admin LOGIN PASSWORD 'lu2Cian4';
20 CREATE ROLE penka IN ROLE waterway_admin LOGIN PASSWORD 'pe2Nka3';
21
22 -- Water Way Users
23 CREATE ROLE oana IN ROLE waterway_user LOGIN PASSWORD 'oa2Na2';
24 CREATE ROLE vanja IN ROLE waterway_user LOGIN PASSWORD 'va2Nja3';
25
26 -- Fill in Profiles
27 INSERT INTO gemma.user_profiles (username, country, email_adress)
28 VALUES
29 ('sophie', 'AT', 'sophie@example.com'),
30 ('lucian', 'RO', 'lucian@example.com'),
31 ('oana', 'RO', 'oana@example.com'),
32 ('penka', 'BG', 'penka@example.com'),
33 ('vanja', 'BG', 'vanja@example.com');