Mercurial > gemma
annotate schema/demo-data/users.sql @ 4325:124a5a7fe8d6
enchange wms styling
* Enable opacity in SLD templates by splitting the corresponding
`_fill` value. The place of the change is in the handlers which are
specfic to geoserver templates. Adding it there keeps the way how opacity
is styled consistent with WFS styles towards the default values
in the database and the client.
author | Bernhard Reiter <bernhard@intevation.de> |
---|---|
date | Wed, 04 Sep 2019 15:30:08 +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; |