Mercurial > gemma
view schema/demo-data/users.sql @ 465:ab07eb290fa3
Drop metamorph role too when tearing down database.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Wed, 22 Aug 2018 17:21:25 +0200 |
parents | be38eec5cc25 |
children | 50dd4ff7907e |
line wrap: on
line source
BEGIN; -- PREREQUISITES: -- Cluster has roles as created by roles.sql, -- responsibility areas from responsibility_areas.sql are imported -- 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 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) Дипл. Инж. Константин yasenov 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) \. COMMIT;