BEGIN;

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

-- User for password reset
CREATE ROLE paul IN ROLE pw_reset LOGIN PASSWORD 'pw2Reset4';

COMMIT;