# HG changeset patch # User Christine Tschuprine # Date 1534328416 -7200 # Node ID 46a80016293c06078fd2ac00231b0fe8b7757952 # Parent 20d2edbc863d37f64b4f65c14222be25932ae521 Feat: Added more demousers In order to check variances in naming, spelling etc, more demo users added. diff -r 20d2edbc863d -r 46a80016293c schema/demo-data/roles.sql --- a/schema/demo-data/roles.sql Tue Aug 14 19:37:36 2018 +0200 +++ b/schema/demo-data/roles.sql Wed Aug 15 12:20:16 2018 +0200 @@ -1,10 +1,31 @@ -- System Administrator -CREATE ROLE sophie IN ROLE sys_admin LOGIN PASSWORD 'so2Phie4'; +CREATE ROLE sophie IN ROLE sys_admin LOGIN PASSWORD 'so2Phie3'; +CREATE ROLE "Dipl.-Inform. Stefan-Albert Zimmermann" IN ROLE sys_admin LOGIN PASSWORD 'zi2Mmer3'; -- Water Way Administrators -CREATE ROLE lucian IN ROLE waterway_admin LOGIN PASSWORD 'lu2Cian4'; +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 vanja IN ROLE waterway_user LOGIN PASSWORD 'va2Nja3'; +CREATE ROLE "Johanna Pichler" 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 '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'; + diff -r 20d2edbc863d -r 46a80016293c schema/demo-data/users.sql --- a/schema/demo-data/users.sql Tue Aug 14 19:37:36 2018 +0200 +++ b/schema/demo-data/users.sql Wed Aug 15 12:20:16 2018 +0200 @@ -7,10 +7,30 @@ -- Fill in Profiles COPY internal.user_profiles (username, country, email_address, map_extent) FROM stdin; sophie AT sophie@example.com BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001) +David Wagner AT wagner@example.com BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001) +Dipl.-Inform. Stefan-Albert Zimmermann AT zimmermann@example.com BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001) +Johanna Pichler AT pichler@example.com BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001) +Katharina Gruber AT gruber@example.com BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001) +Maximilian Wimmer AT wimmer@example.com BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001) +oana HR oana@example.com BOX(13.5014754570001 42.4163272160001,19.4078381750001 46.5469790650001) +Christina Kovačević HR kovačević@example.com BOX(13.5014754570001 42.4163272160001,19.4078381750001 46.5469790650001) +Ivo Marković HR marković@example.com BOX(13.5014754570001 42.4163272160001,19.4078381750001 46.5469790650001) +Leonard Vuković HR vuković@example.com BOX(13.5014754570001 42.4163272160001,19.4078381750001 46.5469790650001) +Neven Novak HR novak@example.com BOX(13.5014754570001 42.4163272160001,19.4078381750001 46.5469790650001) lucian RO lucian@example.com BOX(20.2428259690001 43.6500499480001,29.6995548840001 48.2748322560001) -oana RO oana@example.com BOX(20.2428259690001 43.6500499480001,29.6995548840001 48.2748322560001) +Elena Popescu RO popescu@example.com BOX(20.2428259690001 43.6500499480001,29.6995548840001 48.2748322560001) +Eugen Munteanu RO munteanu@example.com BOX(20.2428259690001 43.6500499480001,29.6995548840001 48.2748322560001) +Gabriela Gheorghe RO gheorghe@example.com BOX(20.2428259690001 43.6500499480001,29.6995548840001 48.2748322560001) +Marina Stoica RO stoica@example.com BOX(20.2428259690001 43.6500499480001,29.6995548840001 48.2748322560001) penka BG penka@example.com BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539) -vanja BG vanja@example.com BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539) +Борис Даманиов BG даманиов@example.com BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539) +Фидан Дубарова BG дубарова@example.com BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539) +Дипл. Инж. Константин Ясенов BG ясенов@example.com BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539) +Люба Ходкивич BG ходкивич@example.com BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539) +Andrej Kovačič SK kovačič@example.com BOX(16.8444804280001 47.7500064090001,22.5396366780001 49.601779684) +Milana Božič SK božič@example.com BOX(16.8444804280001 47.7500064090001,22.5396366780001 49.601779684) +Vladislav Zupančič SK zupančič@example.com BOX(16.8444804280001 47.7500064090001,22.5396366780001 49.601779684) +Zuzanna Korošec SK korošec@example.com BOX(16.8444804280001 47.7500064090001,22.5396366780001 49.601779684) \. COMMIT;