-- System Administrator
CREATE ROLE sophie
    IN ROLE sys_admin ROLE metamorph LOGIN PASSWORD 'so2Phie4';
CREATE ROLE "Dipl.-Inform. Stefan-Albert Zimmermann"
    IN ROLE sys_admin ROLE metamorph LOGIN PASSWORD 'zi2Mmer3';

-- Water Way Administrators
CREATE ROLE lucian
    IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'lu2Cian3';
CREATE ROLE penka
    IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'pe2Nka3';
CREATE ROLE "David Wagner"
    IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'da2Div3';
CREATE ROLE "Christina Kovačević"
    IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'ch2Ris3';
CREATE ROLE "Andrej Kovačič"
    IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'an2Dre3';

-- Water Way Users
CREATE ROLE oana
    IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'oa2Na2';
CREATE ROLE "Johanna Pichler"
    IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'jo2Han3';
CREATE ROLE "JohannaPichler"
    IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'jo2Han3';
CREATE ROLE "Katharina Gruber"
    IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ka2Tha3';
CREATE ROLE "Maximilian Wimmer"
    IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ma2Xim3';
CREATE ROLE "Ivo Marković"
    IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'iv2Oma3';
CREATE ROLE "Leonard Vuković"
    IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'le2Ona3';
CREATE ROLE "Neven Novak"
    IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ne2Ven3';
CREATE ROLE "Elena Popescu"
    IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'el2Ena3';
CREATE ROLE "Eugen Munteanu"
    IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'au2Gen3';
CREATE ROLE "Gabriela Gheorghe"
    IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ga2Bri3';
CREATE ROLE "Marina Stoica"
    IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ma2Rin3';
CREATE ROLE "Борис Даманиов"
    IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'bo2Ris3';
CREATE ROLE "БорисДаманиов"
    IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'bo2Ris3';
CREATE ROLE "Фидан Дубарова"
    IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'fi2Dan3';
CREATE ROLE "Дипл. Инж. Константин Ясенов"
    IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'ko2Nst3';
CREATE ROLE "Люба Ходкивич"
    IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'Lj2Uba3';
CREATE ROLE "Milana Božič"
    IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'mi2Lan3';
CREATE ROLE "Vladislav Zupančič"
    IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'vl2Adi3';
CREATE ROLE "Zuzanna Korošec"
    IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'zu2Zan3';