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

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

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