Mercurial > gemma

annotate schema/demo-data/users.sql @ 211:e7826710d9c4

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Make responsibility area mandatory Each waterway administrator has to have a responsibility area assigned, which is now ensured by referencing the respective table instead of countries directly.
author Tom Gottfried <tom@intevation.de>
date Mon, 23 Jul 2018 16:45:27 +0200
parents 87f21b9a1292
children 229f385448fa
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
138
c79709af2c76 Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents: 137
diff changeset
1 BEGIN;
c79709af2c76 Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents: 137
diff changeset
2
176
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents: 138
diff changeset
3 -- PREREQUISITES:
211
e7826710d9c4 Make responsibility area mandatory
Tom Gottfried <tom@intevation.de>
parents: 208
diff changeset
4 -- Cluster has roles as created by roles.sql,
e7826710d9c4 Make responsibility area mandatory
Tom Gottfried <tom@intevation.de>
parents: 208
diff changeset
5 -- responsibility areas from responsibility_areas.sql are imported
137
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
6
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
7 -- Fill in Profiles
208
87f21b9a1292 Adapt demo-data to schema changes
Tom Gottfried <tom@intevation.de>
parents: 176
diff changeset
8 COPY users.user_profiles (username, country, email_adress) FROM stdin;
138
c79709af2c76 Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents: 137
diff changeset
9 sophie AT sophie@example.com
c79709af2c76 Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents: 137
diff changeset
10 lucian RO lucian@example.com
c79709af2c76 Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents: 137
diff changeset
11 oana RO oana@example.com
c79709af2c76 Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents: 137
diff changeset
12 penka BG penka@example.com
c79709af2c76 Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents: 137
diff changeset
13 vanja BG vanja@example.com
c79709af2c76 Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents: 137
diff changeset
14 \.
c79709af2c76 Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents: 137
diff changeset
15
c79709af2c76 Demo Data: make user.sql atomic and use copy everywhere.
Sascha Wilde <wilde@intevation.de>
parents: 137
diff changeset
16 COMMIT;