Mercurial > lada > lada-server
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 868:6cefa1468832 | 869:fc8349057de1 |
|---|---|
| 98 | 98 |
| 99 CREATE TABLE auth_funktion ( | 99 CREATE TABLE auth_funktion ( |
| 100 id smallint PRIMARY KEY, | 100 id smallint PRIMARY KEY, |
| 101 funktion character varying(40) | 101 funktion character varying(40) |
| 102 ); | 102 ); |
| 103 | 103 INSERT INTO auth_funktion VALUES (0, 'Erfasser'); |
| 104 INSERT INTO auth_funktion VALUES (1, 'Status-Erfasser'); | |
| 105 INSERT INTO auth_funktion VALUES (2, 'Status-Land'); | |
| 106 INSERT INTO auth_funktion VALUES (3, 'Status-Leitstelle'); | |
| 107 INSERT INTO auth_funktion VALUES (4, 'Stammdatenpflege-Land'); | |
| 104 | 108 |
| 105 CREATE SEQUENCE auth_lst_umw_id_seq | 109 CREATE SEQUENCE auth_lst_umw_id_seq |
| 106 START WITH 1 | 110 START WITH 1 |
| 107 INCREMENT BY 1 | 111 INCREMENT BY 1 |
| 108 NO MINVALUE | 112 NO MINVALUE |