Mercurial > gemma
comparison schema/demo-data/README @ 137:433a992befdb
Added basic demo data.
Started to create a set of test/demo data. For now it only contains a
few user accounts for the different user roles and a bunch of
responsibility_areas based on Natural Earth data.
| author | Sascha Wilde <wilde@intevation.de> |
|---|---|
| date | Fri, 29 Jun 2018 17:15:17 +0200 |
| parents | |
| children | 0c0826063561 |
comparison
equal
deleted
inserted
replaced
| 136:25dba84d5703 | 137:433a992befdb |
|---|---|
| 1 ------------------------------------------------------------------------ | |
| 2 !!!!!! WARNING !!!!!! | |
| 3 | |
| 4 Data within this directory is provided for the sole purpose of testing | |
| 5 and demonstration of the Gemma software. It is neither intended nor | |
| 6 suitable for any kind of production use. | |
| 7 | |
| 8 THIS DATA CONTAINS UNSAFE AND PUBLICLY KNOWN PASSWORDS. DO NOT | |
| 9 INSTALL ON REMOTE ACCESSIBLE SYSTEMS! | |
| 10 ------------------------------------------------------------------------ | |
| 11 | |
| 12 Defined Users: | |
| 13 | |
| 14 | Username | Password | Role | Country | | |
| 15 |----------+----------+------------------------+---------| | |
| 16 | sophie | so2Phie4 | System Administrator | AT | | |
| 17 | lucian | lu2Cian4 | Waterway Administrator | RO | | |
| 18 | oana | oa2Na2 | Waterway User | RO | | |
| 19 | penka | pe2Nka3 | Waterway Administrator | BG | | |
| 20 | vanja | va2Nja3 | Waterway User | BG | | |
| 21 | |
| 22 | |
| 23 Installation: | |
| 24 | |
| 25 We assume, you already have a database "gemma" with the Genna schema | |
| 26 in place. | |
| 27 | |
| 28 As postgres super user ("postgres" on most default installations): | |
| 29 | |
| 30 psql -f users.sql -d gemma | |
| 31 psql -f responsibility_areas.sql -d gemma | |
| 32 | |
| 33 | |
| 34 Acknowledgements: | |
| 35 | |
| 36 The file `responsibility_areas.sql' contains information made with | |
| 37 Natural Earth. Free vector and raster map data @ naturalearthdata.com. |