lada/lada-server: db_schema/stammdaten_data_ortszuordnung

annotate db_schema/stammdaten_data_ortszuordnung_typ.sql @ 1290:14876c62f692

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	736445a05169
children

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 -- TOC entry 4707 (class 0 OID 535802)
3923b41f8783 reorganize db setup Michael Stanko <mstanko@bfs.de> parents: diff changeset	23 -- Dependencies: 273
3923b41f8783 reorganize db setup Michael Stanko <mstanko@bfs.de> parents: diff changeset	24 -- Data for Name: ortszuordnung_typ; Type: TABLE DATA; Schema: stammdaten; Owner: lada
3923b41f8783 reorganize db setup Michael Stanko <mstanko@bfs.de> parents: diff changeset	25 --
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 COPY ortszuordnung_typ (id, ortstyp) FROM stdin;
3923b41f8783 reorganize db setup Michael Stanko <mstanko@bfs.de> parents: diff changeset	28 U Ursprungsort
3923b41f8783 reorganize db setup Michael Stanko <mstanko@bfs.de> parents: diff changeset	29 A Kerntechnische Anlage
3923b41f8783 reorganize db setup Michael Stanko <mstanko@bfs.de> parents: diff changeset	30 Z Ortszusatz
1284 736445a05169 Typo. Tom Gottfried <tom@intevation.de> parents: 1191 diff changeset	31 E Entnahmeort
1191 3923b41f8783 reorganize db setup Michael Stanko <mstanko@bfs.de> parents: diff changeset	32 \.

Mercurial > lada > lada-server

annotate db_schema/stammdaten_data_ortszuordnung_typ.sql @ 1290:14876c62f692