Mercurial > lada > lada-server

annotate db_schema/stammdaten_data_ort_typ.sql @ 1290:14876c62f692

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Push down refreshing of persisted objects deeper into the stack. There are more places besides creation of Probe objects where it is useful to return within the response what has been really written to the database (including modifications by the database itself) instead of merely the request data, e.g. creation of Ort objects, which includes database generated ort_ids.
author Tom Gottfried <tom@intevation.de>
date Wed, 08 Feb 2017 18:02:05 +0100
parents a4c7057cbaed
children 3ac30d816c9a
rev   line source
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
1 \set ON_ERROR_STOP on
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
2
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
3 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
4 -- PostgreSQL database dump
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
5 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
6
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
7 -- Dumped from database version 9.5.1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
8 -- Dumped by pg_dump version 9.5.0
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
9
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
10 -- Started on 2016-03-31 11:38:13
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
11
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
12 SET statement_timeout = 0;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
13 SET lock_timeout = 0;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
14 SET client_encoding = 'UTF8';
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
15 SET standard_conforming_strings = on;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
16 SET check_function_bodies = false;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
17 SET client_min_messages = warning;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
18
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
19 SET search_path = stammdaten, pg_catalog;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
20
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
21
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
22 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
23 -- TOC entry 4706 (class 0 OID 535799)
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
24 -- Dependencies: 272
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
25 -- Data for Name: ort_typ; Type: TABLE DATA; Schema: stammdaten; Owner: lada
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
26 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
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
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
42 \.
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
43
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)