Mercurial > gemma

annotate schema/demo-data/README @ 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 5e38667f740c
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
137
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
1 ------------------------------------------------------------------------
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
2 !!!!!! WARNING !!!!!!
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
3
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
4 Data within this directory is provided for the sole purpose of testing
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
5 and demonstration of the Gemma software. It is neither intended nor
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
6 suitable for any kind of production use.
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
7
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
8 THIS DATA CONTAINS UNSAFE AND PUBLICLY KNOWN PASSWORDS. DO NOT
176
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents: 137
diff changeset
9 INSTALL ON REMOTE ACCESSIBLE SYSTEMS!
137
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
10 ------------------------------------------------------------------------
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
11
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
12 Defined Users:
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
13
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
14 | Username | Password | Role | Country |
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
15 |----------+----------+------------------------+---------|
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
16 | sophie | so2Phie4 | System Administrator | AT |
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
17 | lucian | lu2Cian4 | Waterway Administrator | RO |
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
18 | oana | oa2Na2 | Waterway User | RO |
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
19 | penka | pe2Nka3 | Waterway Administrator | BG |
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
20 | vanja | va2Nja3 | Waterway User | BG |
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
21
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 Installation:
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
24
176
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents: 137
diff changeset
25 We assume, you already have a database "gemma" with the Gemma schema
137
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
26 in place.
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
27
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
28 As postgres super user ("postgres" on most default installations):
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
29
176
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents: 137
diff changeset
30 psql -f roles.sql -d gemma
137
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
31 psql -f users.sql -d gemma