--- a/schema/demo-data/roles.sql	Wed Aug 22 16:20:09 2018 +0200
+++ b/schema/demo-data/roles.sql	Wed Aug 22 16:48:56 2018 +0200
@@ -1,34 +1,62 @@
 -- 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';
+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';
+CREATE ROLE "Dipl.-Inform.Stefan-AlbertZimmermann"
+    IN ROLE sys_admin ROLE metamorph 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';
+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 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';
+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';