Mercurial > gemma

annotate schema/demo-data/users.sql @ 2701:e622689d73bd

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
client: waterlevel diagram: use endpoint
author Markus Kottlaender <markus@intevation.de>
date Mon, 18 Mar 2019 15:43:03 +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;