Mercurial > gemma
changeset 3662:1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
| author | Sascha Wilde <wilde@intevation.de> |
|---|---|
| date | Fri, 14 Jun 2019 13:30:33 +0200 |
| parents | 1fe3b378544a |
| children | f8e684108425 |
| files | schema/demo-data/roles.sql schema/demo-data/users.sql |
| diffstat | 2 files changed, 48 insertions(+), 28 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/demo-data/roles.sql Fri Jun 14 13:29:40 2019 +0200 +++ b/schema/demo-data/roles.sql Fri Jun 14 13:30:33 2019 +0200 @@ -33,6 +33,20 @@ IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'ze2Ljko4'; CREATE ROLE "Boglárka Halász" IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'bo2Glarka6'; +CREATE ROLE "wwadm-at" + IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'ww/ADM4AT'; +CREATE ROLE "wwadm-sk" + IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'ww/ADM4SK'; +CREATE ROLE "wwadm-hu" + IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'ww/ADM4HU'; +CREATE ROLE "wwadm-hr" + IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'ww/ADM4HR'; +CREATE ROLE "wwadm-rs" + IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'ww/ADM4RS'; +CREATE ROLE "wwadm-ro" + IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'ww/ADM4RO'; +CREATE ROLE "wwadm-bg" + IN ROLE waterway_admin ROLE metamorph LOGIN PASSWORD 'ww/ADM4BG'; -- Water Way Users @@ -72,4 +86,3 @@ IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'vl2Adi3'; CREATE ROLE "Zuzanna Korošec" IN ROLE waterway_user ROLE metamorph LOGIN PASSWORD 'zu2Zan3'; -
--- a/schema/demo-data/users.sql Fri Jun 14 13:29:40 2019 +0200 +++ b/schema/demo-data/users.sql Fri Jun 14 13:30:33 2019 +0200 @@ -22,33 +22,40 @@ -- 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) -JohannaPichler 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 kovacevic@example.com BOX(13.5014754570001 42.4163272160001,19.4078381750001 46.5469790650001) -Ivo Marković HR markovic@example.com BOX(13.5014754570001 42.4163272160001,19.4078381750001 46.5469790650001) -Leonard Vuković HR vukovic@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) -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) -БорисДаманиов BG daimanov@example.com BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539) -Фидан Дубарова BG dubarova@example.com BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539) -Дипл. Инж. Константин Ясенов BG ясенов@example.com BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539) -Люба Ходкивич BG hodkiewicz@example.com BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539) -Andrej Kovačič SK kovacic@example.com BOX(16.8444804280001 47.7500064090001,22.5396366780001 49.601779684) -Milana Božič SK bozic@example.com BOX(16.8444804280001 47.7500064090001,22.5396366780001 49.601779684) -Vladislav Zupančič SK zupancic@example.com BOX(16.8444804280001 47.7500064090001,22.5396366780001 49.601779684) -Zuzanna Korošec SK korosec@example.com BOX(16.8444804280001 47.7500064090001,22.5396366780001 49.601779684) -Željko Popović RS popovic@example.com BOX(18.706318577915 42.9673653726122,21.6567548728357 46.2191909133314) -Boglárka Halász HU halasz@example.com BOX(16.0284203178465 45.6965827047519,22.9442370225955 48.6142125029487) +sophie AT sophie@example.com BOX(13.4292771034607 48.0932697732137,17.0665467715356 48.6000136289158) +David Wagner AT wagner@example.com BOX(13.4292771034607 48.0932697732137,17.0665467715356 48.6000136289158) +Dipl.-Inform. Stefan-Albert Zimmermann AT zimmermann@example.com BOX(13.4292771034607 48.0932697732137,17.0665467715356 48.6000136289158) +JohannaPichler AT pichler@example.com BOX(13.4292771034607 48.0932697732137,17.0665467715356 48.6000136289158) +Katharina Gruber AT gruber@example.com BOX(13.4292771034607 48.0932697732137,17.0665467715356 48.6000136289158) +Maximilian Wimmer AT wimmer@example.com BOX(13.4292771034607 48.0932697732137,17.0665467715356 48.6000136289158) +oana HR oana@example.com BOX(18.7894254872172 45.2151833810119,19.4148859308035 45.9187395678413) +Christina Kovačević HR kovacevic@example.com BOX(18.7894254872172 45.2151833810119,19.4148859308035 45.9187395678413) +Ivo Marković HR markovic@example.com BOX(18.7894254872172 45.2151833810119,19.4148859308035 45.9187395678413) +Leonard Vuković HR vukovic@example.com BOX(18.7894254872172 45.2151833810119,19.4148859308035 45.9187395678413) +Neven Novak HR novak@example.com BOX(18.7894254872172 45.2151833810119,19.4148859308035 45.9187395678413) +lucian RO lucian@example.com BOX(22.6449178570838 43.6582065599625,24.7374359404622 44.2424516801414) +Elena Popescu RO popescu@example.com BOX(22.6449178570838 43.6582065599625,24.7374359404622 44.2424516801414) +Eugen Munteanu RO munteanu@example.com BOX(22.6449178570838 43.6582065599625,24.7374359404622 44.2424516801414) +Gabriela Gheorghe RO gheorghe@example.com BOX(22.6449178570838 43.6582065599625,24.7374359404622 44.2424516801414) +Marina Stoica RO stoica@example.com BOX(22.6449178570838 43.6582065599625,24.7374359404622 44.2424516801414) +penka BG penka@example.com BOX(24.7333785334023 43.5838590157115,29.8261453141563 45.4968764910666) +БорисДаманиов BG daimanov@example.com BOX(24.7333785334023 43.5838590157115,29.8261453141563 45.4968764910666) +Фидан Дубарова BG dubarova@example.com BOX(24.7333785334023 43.5838590157115,29.8261453141563 45.4968764910666) +Дипл. Инж. Константин Ясенов BG ясенов@example.com BOX(24.7333785334023 43.5838590157115,29.8261453141563 45.4968764910666) +Люба Ходкивич BG hodkiewicz@example.com BOX(24.7333785334023 43.5838590157115,29.8261453141563 45.4968764910666) +Andrej Kovačič SK kovacic@example.com BOX(17.0513974744621 47.7210081090549,18.3573141684446 48.1564918736655) +Milana Božič SK bozic@example.com BOX(17.0513974744621 47.7210081090549,18.3573141684446 48.1564918736655) +Vladislav Zupančič SK zupancic@example.com BOX(17.0513974744621 47.7210081090549,18.3573141684446 48.1564918736655) +Zuzanna Korošec SK korosec@example.com BOX(17.0513974744621 47.7210081090549,18.3573141684446 48.1564918736655) +Željko Popović RS popovic@example.com BOX(18.7894254872172 44.1967324599651,22.8013676181007 46.1777657959295) +Boglárka Halász HU halasz@example.com BOX(18.3430934844849 45.8985837545336,19.1439011951023 47.828792632158) +wwadm-at AT wwadm-at@example.com BOX(13.4292771034607 48.0932697732137,17.0665467715356 48.6000136289158) +wwadm-sk SK wwadm-sk@example.com BOX(17.0513974744621 47.7210081090549,18.3573141684446 48.1564918736655) +wwadm-hu HU wwadm-hu@example.com BOX(18.3430934844849 45.8985837545336,19.1439011951023 47.828792632158) +wwadm-hr HR wwadm-hr@example.com BOX(18.7894254872172 45.2151833810119,19.4148859308035 45.9187395678413) +wwadm-rs RS wwadm-rs@example.com BOX(18.7894254872172 44.1967324599651,22.8013676181007 46.1777657959295) +wwadm-ro RO wwadm-ro@example.com BOX(22.6449178570838 43.6582065599625,24.7374359404622 44.2424516801414) +wwadm-bg BG wwadm-bg@example.com BOX(24.7333785334023 43.5838590157115,29.8261453141563 45.4968764910666) \. COMMIT;