Mercurial > gemma
changeset 2026:ec92398b3af7 unify_imports
Merged default into branch.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Thu, 24 Jan 2019 18:20:05 +0100 |
parents | 070ac9dd61a1 (current diff) 35acb7f9ae0c (diff) |
children | 6b9f0fe741dc |
files | |
diffstat | 1 files changed, 9 insertions(+), 9 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/std_login_roles.sql Thu Jan 24 18:19:43 2019 +0100 +++ b/schema/std_login_roles.sql Thu Jan 24 18:20:05 2019 +0100 @@ -24,21 +24,21 @@ -- -- Admin User -- --- This initial Admin account is used to bootstrap the personalized --- accounts. -CREATE ROLE sysadmin IN ROLE sys_admin ROLE metamorph LOGIN PASSWORD :'adminpw'; - -- We need an empty dummy country for the default admin, as the user is -- not supposed to work on data, it should be only used to create -- personalized accounts. INSERT INTO countries (country_code) VALUES ('--'); INSERT INTO users.responsibility_areas (country, area) VALUES ('--', ST_GeomFromText('MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)))', 4326)); --- Add user profile data for sysadmin -INSERT INTO internal.user_profiles - (username, country, email_address, map_extent) - VALUES ('sysadmin','--','', - 'BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001)'); + +-- This initial Admin account is used to bootstrap the personalized accounts. +INSERT INTO users.list_users VALUES ( + 'sys_admin', + 'sysadmin', + :'adminpw', + '--', + 'BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001)', + ''); -- -- Functional Users