BEGIN;

--
-- Standard users for the GEMMA database
--

-- NOTE: Passwords for these roles must be set during initial setup of
--       the database.

--
-- 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, 0 0, 0 0, 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)');

--
-- Functional Users
--

-- Used by GeoServer and backend
CREATE ROLE meta_login IN ROLE metamorph LOGIN PASSWORD :'metapw';

-- Emit messages to the client if everything went ok
SELECT 'Default admin user ''sysadmin'' created with password ' || :'adminpw';
SELECT 'Backend user ''meta_login'' created with password ' || :'metapw';

COMMIT;