Mercurial > gemma
changeset 403:46a80016293c
Feat: Added more demousers
In order to check variances in naming, spelling etc, more demo users added.
| author | Christine Tschuprine <christine@intevation.de> |
|---|---|
| date | Wed, 15 Aug 2018 12:20:16 +0200 |
| parents | 20d2edbc863d |
| children | 41b37a531843 40e7ab3df32c |
| files | schema/demo-data/roles.sql schema/demo-data/users.sql |
| diffstat | 2 files changed, 46 insertions(+), 5 deletions(-) [+] |
line wrap: on
line diff
--- 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'; +
--- 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;