Mercurial > lada > lada-server
view db_schema/stammdaten_data_ort_typ.sql @ 1332:65ed13ff9945 2.6.1
Changed authorization for Messprogramm.
* Added 'readonly' flag
* Only user with function '4' and the corresponding 'netzbetreiber' are allowed
to edit.
* User authorized to create a 'probe' are allowed to generate proben.
author | Raimund Renkert <raimund.renkert@intevation.de> |
---|---|
date | Wed, 29 Mar 2017 14:25:56 +0200 |
parents | 3ac30d816c9a |
children |
line wrap: on
line source
\set ON_ERROR_STOP on -- -- PostgreSQL database dump -- -- Dumped from database version 9.5.1 -- Dumped by pg_dump version 9.5.0 -- Started on 2016-03-31 11:38:13 SET statement_timeout = 0; SET lock_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SET check_function_bodies = false; SET client_min_messages = warning; SET search_path = stammdaten, pg_catalog; -- -- TOC entry 4706 (class 0 OID 535799) -- Dependencies: 272 -- Data for Name: ort_typ; Type: TABLE DATA; Schema: stammdaten; Owner: lada -- COPY ort_typ (id, ort_typ, code) FROM stdin; 1 dynamischer Messpunkt (nicht vordefiniert) DYN 2 vordefinierter Messpunkt GP 3 REI-Messpunkit REI 4 Verwaltungseinheit VE 5 Staat ST 6 Fluss FL 7 See SEE 8 Wasserwerk WW 9 Kläranlage KA 10 Deponie DEP 11 Müllverbrennungsanlage MVA 12 Messstation MST 13 KTA KTA 14 Fanggebiet FG 15 Sonstiger Ortszusatz So \. -- -- PostgreSQL database dump complete --