# HG changeset patch # User Tom Gottfried # Date 1454931926 -3600 # Node ID fc8349057de1f61eaddd1b62fe4e3a424a9628d0 # Parent 6cefa14688328575dc8333a907140d76a1235767 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. diff -r 6cefa1468832 -r fc8349057de1 db_schema/stammdaten_schema.sql --- 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