Mercurial > gemma
annotate schema/demo-data/users.sql @ 657:40d3b697ea15
Add PostgreSQL extension for 3D processing
We already use it for cross section calculation (see cross.go).
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 14 Sep 2018 17:45:42 +0200 |
parents | be38eec5cc25 |
children | 50dd4ff7907e |
rev | line source |
---|---|
138
c79709af2c76
Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents:
137
diff
changeset
|
1 BEGIN; |
c79709af2c76
Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents:
137
diff
changeset
|
2 |
176
0c0826063561
Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
138
diff
changeset
|
3 -- PREREQUISITES: |
211
e7826710d9c4
Make responsibility area mandatory
Tom Gottfried <tom@intevation.de>
parents:
208
diff
changeset
|
4 -- Cluster has roles as created by roles.sql, |
e7826710d9c4
Make responsibility area mandatory
Tom Gottfried <tom@intevation.de>
parents:
208
diff
changeset
|
5 -- responsibility areas from responsibility_areas.sql are imported |
137 | 6 |
7 -- Fill in Profiles | |
268
72062ca52746
Make user_profiles table invisible for users
Tom Gottfried <tom@intevation.de>
parents:
233
diff
changeset
|
8 COPY internal.user_profiles (username, country, email_address, map_extent) FROM stdin; |
212
229f385448fa
Make map extent mandatory
Tom Gottfried <tom@intevation.de>
parents:
211
diff
changeset
|
9 sophie AT sophie@example.com BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001) |
403
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
268
diff
changeset
|
10 David Wagner AT wagner@example.com BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001) |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
268
diff
changeset
|
11 Dipl.-Inform. Stefan-Albert Zimmermann AT zimmermann@example.com BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001) |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
268
diff
changeset
|
12 Johanna Pichler AT pichler@example.com BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001) |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
268
diff
changeset
|
13 Katharina Gruber AT gruber@example.com BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001) |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
268
diff
changeset
|
14 Maximilian Wimmer AT wimmer@example.com BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001) |
420
be38eec5cc25
fix: Fix email adresses
Thomas Junk <thomas.junk@intevation.de>
parents:
403
diff
changeset
|
15 oana HR oana@example.com BOX(13.5014754570001 42.4163272160001,19.4078381750001 46.5469790650001) |
be38eec5cc25
fix: Fix email adresses
Thomas Junk <thomas.junk@intevation.de>
parents:
403
diff
changeset
|
16 Christina Kovačević HR kovacevic@example.com BOX(13.5014754570001 42.4163272160001,19.4078381750001 46.5469790650001) |
be38eec5cc25
fix: Fix email adresses
Thomas Junk <thomas.junk@intevation.de>
parents:
403
diff
changeset
|
17 Ivo Marković HR markovic@example.com BOX(13.5014754570001 42.4163272160001,19.4078381750001 46.5469790650001) |
be38eec5cc25
fix: Fix email adresses
Thomas Junk <thomas.junk@intevation.de>
parents:
403
diff
changeset
|
18 Leonard Vuković HR vukovic@example.com BOX(13.5014754570001 42.4163272160001,19.4078381750001 46.5469790650001) |
be38eec5cc25
fix: Fix email adresses
Thomas Junk <thomas.junk@intevation.de>
parents:
403
diff
changeset
|
19 Neven Novak HR novak@example.com BOX(13.5014754570001 42.4163272160001,19.4078381750001 46.5469790650001) |
212
229f385448fa
Make map extent mandatory
Tom Gottfried <tom@intevation.de>
parents:
211
diff
changeset
|
20 lucian RO lucian@example.com BOX(20.2428259690001 43.6500499480001,29.6995548840001 48.2748322560001) |
403
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
268
diff
changeset
|
21 Elena Popescu RO popescu@example.com BOX(20.2428259690001 43.6500499480001,29.6995548840001 48.2748322560001) |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
268
diff
changeset
|
22 Eugen Munteanu RO munteanu@example.com BOX(20.2428259690001 43.6500499480001,29.6995548840001 48.2748322560001) |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
268
diff
changeset
|
23 Gabriela Gheorghe RO gheorghe@example.com BOX(20.2428259690001 43.6500499480001,29.6995548840001 48.2748322560001) |
46a80016293c
Feat: Added more demousers
Christine Tschuprine <christine@intevation.de>
parents:
268
diff
changeset
|
24 Marina Stoica RO stoica@example.com BOX(20.2428259690001 43.6500499480001,29.6995548840001 48.2748322560001) |
212
229f385448fa
Make map extent mandatory
Tom Gottfried <tom@intevation.de>
parents:
211
diff
changeset
|
25 penka BG penka@example.com BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539) |
420
be38eec5cc25
fix: Fix email adresses
Thomas Junk <thomas.junk@intevation.de>
parents:
403
diff
changeset
|
26 Борис Даманиов BG daimanov@example.com BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539) |
be38eec5cc25
fix: Fix email adresses
Thomas Junk <thomas.junk@intevation.de>
parents:
403
diff
changeset
|
27 Фидан Дубарова BG dubarova@example.com BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539) |
be38eec5cc25
fix: Fix email adresses
Thomas Junk <thomas.junk@intevation.de>
parents:
403
diff
changeset
|
28 Дипл. Инж. Константин yasenov BG ясенов@example.com BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539) |
be38eec5cc25
fix: Fix email adresses
Thomas Junk <thomas.junk@intevation.de>
parents:
403
diff
changeset
|
29 Люба Ходкивич BG hodkiewicz@example.com BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539) |
be38eec5cc25
fix: Fix email adresses
Thomas Junk <thomas.junk@intevation.de>
parents:
403
diff
changeset
|
30 Andrej Kovačič SK kovacic@example.com BOX(16.8444804280001 47.7500064090001,22.5396366780001 49.601779684) |
be38eec5cc25
fix: Fix email adresses
Thomas Junk <thomas.junk@intevation.de>
parents:
403
diff
changeset
|
31 Milana Božič SK bozic@example.com BOX(16.8444804280001 47.7500064090001,22.5396366780001 49.601779684) |
be38eec5cc25
fix: Fix email adresses
Thomas Junk <thomas.junk@intevation.de>
parents:
403
diff
changeset
|
32 Vladislav Zupančič SK zupancic@example.com BOX(16.8444804280001 47.7500064090001,22.5396366780001 49.601779684) |
be38eec5cc25
fix: Fix email adresses
Thomas Junk <thomas.junk@intevation.de>
parents:
403
diff
changeset
|
33 Zuzanna Korošec SK korosec@example.com BOX(16.8444804280001 47.7500064090001,22.5396366780001 49.601779684) |
138
c79709af2c76
Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents:
137
diff
changeset
|
34 \. |
c79709af2c76
Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents:
137
diff
changeset
|
35 |
c79709af2c76
Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents:
137
diff
changeset
|
36 COMMIT; |