Mercurial > lada > lada-server
diff db_schema/stammdaten_schema.sql @ 869:fc8349057de1
Functions are needed and assumed to be given by the server.
These are not data to be changed by any user, thus part of the schema.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 08 Feb 2016 12:45:26 +0100 |
| parents | 6cefa1468832 |
| children | 82a51cafa0fe |
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql Fri Feb 05 18:32:03 2016 +0100 +++ b/db_schema/stammdaten_schema.sql Mon Feb 08 12:45:26 2016 +0100 @@ -100,7 +100,11 @@ id smallint PRIMARY KEY, funktion character varying(40) ); - +INSERT INTO auth_funktion VALUES (0, 'Erfasser'); +INSERT INTO auth_funktion VALUES (1, 'Status-Erfasser'); +INSERT INTO auth_funktion VALUES (2, 'Status-Land'); +INSERT INTO auth_funktion VALUES (3, 'Status-Leitstelle'); +INSERT INTO auth_funktion VALUES (4, 'Stammdatenpflege-Land'); CREATE SEQUENCE auth_lst_umw_id_seq START WITH 1