Mercurial > gemma

annotate schema/demo-data/users.sql @ 2455:54c9fe587fe6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Subdivide SQL function to prepare for improved error handling The context of an error (e.g. the function in which it occured) can be inferred by the database client. Not doing all in one statement will render the context more meaningful.
author Tom Gottfried <tom@intevation.de>
date Fri, 01 Mar 2019 18:38:02 +0100
parents 918091d1df72
children ca7821e1f720
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;
212
229f385448fa Make map extent mandatory
Tom Gottfried <tom@intevation.de>
parents: 211
diff changeset
25 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
26 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
27 Dipl.-Inform. Stefan-Albert Zimmermann AT zimmermann@example.com BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001)
2338
918091d1df72 demo-data: fix two user accounts
Bernhard Reiter <bernhard@intevation.de>
parents: 2334
diff changeset
28 JohannaPichler AT pichler@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
29 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
30 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
31 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
32 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
33 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
34 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
35 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
36 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
37 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
38 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
39 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
40 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
41 penka BG penka@example.com BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539)
2338
918091d1df72 demo-data: fix two user accounts
Bernhard Reiter <bernhard@intevation.de>
parents: 2334
diff changeset
42 БорисДаманиов BG daimanov@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
43 Фидан Дубарова BG dubarova@example.com BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539)
2334
26c806f1684d demo-data: fix one demo user
Bernhard Reiter <bernhard@intevation.de>
parents: 1318
diff changeset
44 Дипл. Инж. Константин Ясенов BG ясенов@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
45 Люба Ходкивич 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
46 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
47 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
48 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
49 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
50 \.
c79709af2c76 Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents: 137
diff changeset
51
c79709af2c76 Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents: 137
diff changeset
52 COMMIT;