# HG changeset patch # User Sascha L. Teichmann # Date 1548350405 -3600 # Node ID ec92398b3af71413147cd479efc68959569b43ea # Parent 070ac9dd61a1654b2dbb95c119645a512e48541e# Parent 35acb7f9ae0cdf9b45881dc949da5898d64abd1f Merged default into branch. diff -r 070ac9dd61a1 -r ec92398b3af7 schema/std_login_roles.sql --- 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