--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/schema/demo-data/users.sql	Fri Jun 29 17:15:17 2018 +0200
@@ -0,0 +1,33 @@
+-- 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');