BEGIN;

-- 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
COPY gemma.user_profiles (username, country, email_adress) FROM stdin;
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
\.

COMMIT;