137
|
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');
|