Mercurial > gemma

annotate schema/demo-data/users.sql @ 5560:f2204f91d286

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Join the log lines of imports to the log exports to recover data from them. Used in SR export to extract information that where in the meta json but now are only found in the log.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 09 Feb 2022 18:34:40 +0100
parents 1c8de1c695cd
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
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
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
22
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
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;