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
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)