Mercurial > gemma
changeset 2338:918091d1df72
demo-data: fix two user accounts
* Make sure that all users also have roles, by deleting the
role variants with space for `Johanna Pichler` and `Борис Даманиов`
and adapt the user_profile entries accordingly. The defect
was introduced with rev 414:c08593afdd02 only updating one of
the tables. As we have enough variants, deleting some is fine.
| author | Bernhard Reiter <bernhard@intevation.de> |
|---|---|
| date | Tue, 19 Feb 2019 17:17:23 +0100 |
| parents | 0f3b0937e7c1 |
| children | 7dd7371702b9 |
| files | schema/demo-data/roles.sql schema/demo-data/users.sql |
| diffstat | 2 files changed, 2 insertions(+), 6 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/demo-data/roles.sql Tue Feb 19 17:06:55 2019 +0100 +++ b/schema/demo-data/roles.sql Tue Feb 19 17:17:23 2019 +0100 @@ -33,8 +33,6 @@ -- Water Way Users 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" @@ -55,8 +53,6 @@ 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 "Фидан Дубарова"
--- a/schema/demo-data/users.sql Tue Feb 19 17:06:55 2019 +0100 +++ b/schema/demo-data/users.sql Tue Feb 19 17:17:23 2019 +0100 @@ -25,7 +25,7 @@ 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) +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) @@ -39,7 +39,7 @@ 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 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)