Mercurial > gemma
comparison schema/std_login_roles.sql @ 4389:5e38667f740c stretches-for-responsibility
Use stretches as areas of responsibility.
This is heavily based on a patch by Tom Gottfried
(read: >90% of the work was done by Tom).
| author | Sascha Wilde <wilde@intevation.de> |
|---|---|
| date | Thu, 12 Sep 2019 18:13:47 +0200 |
| parents | 35acb7f9ae0c |
| children | 7657640f0c8d |
comparison
equal
deleted
inserted
replaced
| 4371:4a5ed371011f | 4389:5e38667f740c |
|---|---|
| 26 -- | 26 -- |
| 27 -- We need an empty dummy country for the default admin, as the user is | 27 -- We need an empty dummy country for the default admin, as the user is |
| 28 -- not supposed to work on data, it should be only used to create | 28 -- not supposed to work on data, it should be only used to create |
| 29 -- personalized accounts. | 29 -- personalized accounts. |
| 30 INSERT INTO countries (country_code) VALUES ('--'); | 30 INSERT INTO countries (country_code) VALUES ('--'); |
| 31 INSERT INTO users.responsibility_areas (country, area) | |
| 32 VALUES ('--', ST_GeomFromText('MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)))', 4326)); | |
| 33 | 31 |
| 34 -- This initial Admin account is used to bootstrap the personalized accounts. | 32 -- This initial Admin account is used to bootstrap the personalized accounts. |
| 35 INSERT INTO users.list_users VALUES ( | 33 INSERT INTO users.list_users VALUES ( |
| 36 'sys_admin', | 34 'sys_admin', |
| 37 'sysadmin', | 35 'sysadmin', |