-- PREREQUISITES

-- Setup Country Codes
COPY gemma.countries (country_code) FROM stdin;
RO
HU
SK
AT
HR
BG
\.

-- USERS

-- System Administrator
CREATE ROLE sophie IN ROLE sys_admin LOGIN PASSWORD 'so2Phie4';

-- Water Way Administrators
CREATE ROLE lucian IN ROLE waterway_admin LOGIN PASSWORD 'lu2Cian4';
CREATE ROLE penka IN ROLE waterway_admin LOGIN PASSWORD 'pe2Nka3';

-- Water Way Users
CREATE ROLE oana IN ROLE waterway_user LOGIN PASSWORD 'oa2Na2';
CREATE ROLE vanja IN ROLE waterway_user LOGIN PASSWORD 'va2Nja3';

-- Fill in Profiles
INSERT INTO gemma.user_profiles (username, country, email_adress)
       VALUES
       ('sophie', 'AT', 'sophie@example.com'),
       ('lucian', 'RO', 'lucian@example.com'),
       ('oana', 'RO', 'oana@example.com'),
       ('penka', 'BG', 'penka@example.com'),
       ('vanja', 'BG', 'vanja@example.com');