Mercurial > gemma
view schema/demo-data/users.sql @ 176:0c0826063561
Separate cluster and database specific commands
This allows to setup more than one database with demo data
on the same cluster by using only the script with database
specific commands.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Tue, 17 Jul 2018 12:01:14 +0200 |
| parents | c79709af2c76 |
| children | 87f21b9a1292 |
line wrap: on
line source
BEGIN; -- PREREQUISITES: -- Cluster has roles as created by roles.sql -- Setup Country Codes COPY gemma.countries (country_code) FROM stdin; RO HU SK AT HR BG \. -- Fill in Profiles COPY gemma.user_profiles (username, country, email_adress) FROM stdin; sophie AT sophie@example.com lucian RO lucian@example.com oana RO oana@example.com penka BG penka@example.com vanja BG vanja@example.com \. COMMIT;