Mercurial > lada > lada-server
annotate 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 |
| rev | line source |
|---|---|
| 1191 | 1 \set ON_ERROR_STOP on |
| 2 | |
| 3 -- | |
| 4 -- PostgreSQL database dump | |
| 5 -- | |
| 6 | |
| 7 -- Dumped from database version 9.5.1 | |
| 8 -- Dumped by pg_dump version 9.5.0 | |
| 9 | |
| 10 -- Started on 2016-03-31 11:38:13 | |
| 11 | |
| 12 SET statement_timeout = 0; | |
| 13 SET lock_timeout = 0; | |
| 14 SET client_encoding = 'UTF8'; | |
| 15 SET standard_conforming_strings = on; | |
| 16 SET check_function_bodies = false; | |
| 17 SET client_min_messages = warning; | |
| 18 | |
| 19 SET search_path = stammdaten, pg_catalog; | |
| 20 | |
| 21 | |
| 22 -- | |
| 23 -- TOC entry 4706 (class 0 OID 535799) | |
| 24 -- Dependencies: 272 | |
| 25 -- Data for Name: ort_typ; Type: TABLE DATA; Schema: stammdaten; Owner: lada | |
| 26 -- | |
| 27 | |
|
1258
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
28 COPY ort_typ (id, ort_typ, code) FROM stdin; |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
29 1 dynamischer Messpunkt (nicht vordefiniert) DYN |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
30 2 vordefinierter Messpunkt GP |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
31 3 REI-Messpunkit REI |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
32 4 Verwaltungseinheit VE |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
33 5 Staat ST |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
34 6 Fluss FL |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
35 7 See SEE |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
36 8 Wasserwerk WW |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
37 9 Kläranlage KA |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
38 10 Deponie DEP |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
39 11 Müllverbrennungsanlage MVA |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
40 12 Messstation MST |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
41 13 KTA KTA |
|
1317
3ac30d816c9a
prepare import of production data
Michael Stanko <mstanko@bfs.de>
parents:
1259
diff
changeset
|
42 14 Fanggebiet FG |
|
3ac30d816c9a
prepare import of production data
Michael Stanko <mstanko@bfs.de>
parents:
1259
diff
changeset
|
43 15 Sonstiger Ortszusatz So |
| 1191 | 44 \. |
|
1317
3ac30d816c9a
prepare import of production data
Michael Stanko <mstanko@bfs.de>
parents:
1259
diff
changeset
|
45 -- |
|
3ac30d816c9a
prepare import of production data
Michael Stanko <mstanko@bfs.de>
parents:
1259
diff
changeset
|
46 -- PostgreSQL database dump complete |
|
3ac30d816c9a
prepare import of production data
Michael Stanko <mstanko@bfs.de>
parents:
1259
diff
changeset
|
47 -- |