Mercurial > gemma
annotate schema/demo-data/users.sql @ 3841:8e47d6f12998 sld-colors
Merged default into sld-colors branch.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Mon, 08 Jul 2019 14:34:42 +0200 |
parents | 1c8de1c695cd |
children |
rev | line source |
---|---|
1318
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
420
diff
changeset
|
1 -- This is Free Software under GNU Affero General Public License v >= 3.0 |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
420
diff
changeset
|
2 -- without warranty, see README.md and license for details. |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
420
diff
changeset
|
3 |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
420
diff
changeset
|
4 -- SPDX-License-Identifier: AGPL-3.0-or-later |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
420
diff
changeset
|
5 -- License-Filename: LICENSES/AGPL-3.0.txt |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
420
diff
changeset
|
6 |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
420
diff
changeset
|
7 -- Copyright (C) 2018 by via donau |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
420
diff
changeset
|
8 -- – Österreichische Wasserstraßen-Gesellschaft mbH |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
420
diff
changeset
|
9 -- Software engineering by Intevation GmbH |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
420
diff
changeset
|
10 |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
420
diff
changeset
|
11 -- Author(s): |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
420
diff
changeset
|
12 -- * Sascha Wilde <sascha.wilde@intevation.de> |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
420
diff
changeset
|
13 -- * Christine Tschuprine <christine.tschuprine@intevation.de> |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
420
diff
changeset
|
14 -- * Thomas Junk <thomas.junk@intevation.de> |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
420
diff
changeset
|
15 -- * Tom Gottfried <tom@intevation.de> |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
420
diff
changeset
|
16 |
138
c79709af2c76
Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents:
137
diff
changeset
|
17 BEGIN; |
c79709af2c76
Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents:
137
diff
changeset
|
18 |
176
0c0826063561
Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents:
138
diff
changeset
|
19 -- PREREQUISITES: |
211
e7826710d9c4
Make responsibility area mandatory
Tom Gottfried <tom@intevation.de>
parents:
208
diff
changeset
|
20 -- Cluster has roles as created by roles.sql, |
e7826710d9c4
Make responsibility area mandatory
Tom Gottfried <tom@intevation.de>
parents:
208
diff
changeset
|
21 -- responsibility areas from responsibility_areas.sql are imported |
137 | 22 |
23 -- Fill in Profiles | |
268
72062ca52746
Make user_profiles table invisible for users
Tom Gottfried <tom@intevation.de>
parents:
233
diff
changeset
|
24 COPY internal.user_profiles (username, country, email_address, map_extent) FROM stdin; |
3662
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
25 sophie AT sophie@example.com BOX(13.4292771034607 48.0932697732137,17.0665467715356 48.6000136289158) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
26 David Wagner AT wagner@example.com BOX(13.4292771034607 48.0932697732137,17.0665467715356 48.6000136289158) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
27 Dipl.-Inform. Stefan-Albert Zimmermann AT zimmermann@example.com BOX(13.4292771034607 48.0932697732137,17.0665467715356 48.6000136289158) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
28 JohannaPichler AT pichler@example.com BOX(13.4292771034607 48.0932697732137,17.0665467715356 48.6000136289158) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
29 Katharina Gruber AT gruber@example.com BOX(13.4292771034607 48.0932697732137,17.0665467715356 48.6000136289158) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
30 Maximilian Wimmer AT wimmer@example.com BOX(13.4292771034607 48.0932697732137,17.0665467715356 48.6000136289158) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
31 oana HR oana@example.com BOX(18.7894254872172 45.2151833810119,19.4148859308035 45.9187395678413) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
32 Christina Kovačević HR kovacevic@example.com BOX(18.7894254872172 45.2151833810119,19.4148859308035 45.9187395678413) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
33 Ivo Marković HR markovic@example.com BOX(18.7894254872172 45.2151833810119,19.4148859308035 45.9187395678413) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
34 Leonard Vuković HR vukovic@example.com BOX(18.7894254872172 45.2151833810119,19.4148859308035 45.9187395678413) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
35 Neven Novak HR novak@example.com BOX(18.7894254872172 45.2151833810119,19.4148859308035 45.9187395678413) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
36 lucian RO lucian@example.com BOX(22.6449178570838 43.6582065599625,24.7374359404622 44.2424516801414) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
37 Elena Popescu RO popescu@example.com BOX(22.6449178570838 43.6582065599625,24.7374359404622 44.2424516801414) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
38 Eugen Munteanu RO munteanu@example.com BOX(22.6449178570838 43.6582065599625,24.7374359404622 44.2424516801414) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
39 Gabriela Gheorghe RO gheorghe@example.com BOX(22.6449178570838 43.6582065599625,24.7374359404622 44.2424516801414) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
40 Marina Stoica RO stoica@example.com BOX(22.6449178570838 43.6582065599625,24.7374359404622 44.2424516801414) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
41 penka BG penka@example.com BOX(24.7333785334023 43.5838590157115,29.8261453141563 45.4968764910666) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
42 БорисДаманиов BG daimanov@example.com BOX(24.7333785334023 43.5838590157115,29.8261453141563 45.4968764910666) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
43 Фидан Дубарова BG dubarova@example.com BOX(24.7333785334023 43.5838590157115,29.8261453141563 45.4968764910666) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
44 Дипл. Инж. Константин Ясенов BG ясенов@example.com BOX(24.7333785334023 43.5838590157115,29.8261453141563 45.4968764910666) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
45 Люба Ходкивич BG hodkiewicz@example.com BOX(24.7333785334023 43.5838590157115,29.8261453141563 45.4968764910666) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
46 Andrej Kovačič SK kovacic@example.com BOX(17.0513974744621 47.7210081090549,18.3573141684446 48.1564918736655) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
47 Milana Božič SK bozic@example.com BOX(17.0513974744621 47.7210081090549,18.3573141684446 48.1564918736655) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
48 Vladislav Zupančič SK zupancic@example.com BOX(17.0513974744621 47.7210081090549,18.3573141684446 48.1564918736655) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
49 Zuzanna Korošec SK korosec@example.com BOX(17.0513974744621 47.7210081090549,18.3573141684446 48.1564918736655) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
50 Željko Popović RS popovic@example.com BOX(18.7894254872172 44.1967324599651,22.8013676181007 46.1777657959295) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
51 Boglárka Halász HU halasz@example.com BOX(18.3430934844849 45.8985837545336,19.1439011951023 47.828792632158) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
52 wwadm-at AT wwadm-at@example.com BOX(13.4292771034607 48.0932697732137,17.0665467715356 48.6000136289158) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
53 wwadm-sk SK wwadm-sk@example.com BOX(17.0513974744621 47.7210081090549,18.3573141684446 48.1564918736655) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
54 wwadm-hu HU wwadm-hu@example.com BOX(18.3430934844849 45.8985837545336,19.1439011951023 47.828792632158) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
55 wwadm-hr HR wwadm-hr@example.com BOX(18.7894254872172 45.2151833810119,19.4148859308035 45.9187395678413) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
56 wwadm-rs RS wwadm-rs@example.com BOX(18.7894254872172 44.1967324599651,22.8013676181007 46.1777657959295) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
57 wwadm-ro RO wwadm-ro@example.com BOX(22.6449178570838 43.6582065599625,24.7374359404622 44.2424516801414) |
1c8de1c695cd
Added easy to remember and use waterway admin users for all countries.
Sascha Wilde <wilde@intevation.de>
parents:
3619
diff
changeset
|
58 wwadm-bg BG wwadm-bg@example.com BOX(24.7333785334023 43.5838590157115,29.8261453141563 45.4968764910666) |
138
c79709af2c76
Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents:
137
diff
changeset
|
59 \. |
c79709af2c76
Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents:
137
diff
changeset
|
60 |
c79709af2c76
Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents:
137
diff
changeset
|
61 COMMIT; |