Mercurial > lada > lada-server

annotate db_schema/stammdaten_data_probenehmer.sql @ 1343:f9feea63d6e9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added tag 2.6.2 for changeset 523c4a436896
author Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de>
date Fri, 07 Apr 2017 11:10:26 +0200
parents 5f7f2157a7b8
children
rev   line source
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
1 \set ON_ERROR_STOP on
1341
5f7f2157a7b8 backout tag 2.6.1 commit
Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de>
parents: 1334
diff changeset
2
1191
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
1341
5f7f2157a7b8 backout tag 2.6.1 commit
Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de>
parents: 1334
diff changeset
7 -- Dumped from database version 9.5.1
5f7f2157a7b8 backout tag 2.6.1 commit
Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de>
parents: 1334
diff changeset
8 -- Dumped by pg_dump version 9.5.0
5f7f2157a7b8 backout tag 2.6.1 commit
Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de>
parents: 1334
diff changeset
9
5f7f2157a7b8 backout tag 2.6.1 commit
Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de>
parents: 1334
diff changeset
10 -- Started on 2016-03-31 11:38:13
1191
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
1341
5f7f2157a7b8 backout tag 2.6.1 commit
Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de>
parents: 1334
diff changeset
21
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
22 --
1341
5f7f2157a7b8 backout tag 2.6.1 commit
Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de>
parents: 1334
diff changeset
23 -- TOC entry 4713 (class 0 OID 535818)
5f7f2157a7b8 backout tag 2.6.1 commit
Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de>
parents: 1334
diff changeset
24 -- Dependencies: 279
5f7f2157a7b8 backout tag 2.6.1 commit
Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de>
parents: 1334
diff changeset
25 -- Data for Name: probenehmer; Type: TABLE DATA; Schema: stammdaten; Owner: lada
1191
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
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
28 COPY probenehmer (id, netzbetreiber_id, prn_id, bearbeiter, bemerkung, betrieb, bezeichnung, kurz_bezeichnung, ort, plz, strasse, telefon, tp, typ, letzte_aenderung) FROM stdin;
1341
5f7f2157a7b8 backout tag 2.6.1 commit
Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de>
parents: 1334
diff changeset
29 724 06 AV18 \N \N \N Stadt Kassel - Veterinärdienst und Lebensmittelüberwachung AVV Kassel Kassel 34117 Kurt Schumacher Straße 31 \N \N \N 2000-01-01 00:00:00
5f7f2157a7b8 backout tag 2.6.1 commit
Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de>
parents: 1334
diff changeset
30 726 06 AV24 \N \N \N Stadt Wiesbaden - Amt f. Veterinärwesen u. Verbraucherschutz AVV Wiesb Wiesbaden 65187 Teutonenstraße 1 \N \N \N 2000-01-01 00:00:00
5f7f2157a7b8 backout tag 2.6.1 commit
Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de>
parents: 1334
diff changeset
31 727 06 AV0 \N \N \N Rheingau-Taunus Kreis - RD III.8 Verbraucherschutz u. Veterinärwesen AVV RhgTns Bad Schwalbach 65307 Heimbacher Straße 7 \N \N \N 2000-01-01 00:00:00
5f7f2157a7b8 backout tag 2.6.1 commit
Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de>
parents: 1334
diff changeset
32 729 06 AV17 \N \N \N Landkreis Fulda - Sachgebiet Veterinärwesen u. Verbraucherschutz AVV Fulda Fulda 36037 Wörthstraße 15 \N \N \N 2000-01-01 00:00:00
5f7f2157a7b8 backout tag 2.6.1 commit
Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de>
parents: 1334
diff changeset
33 734 06 AV16 \N \N \N Schwalm-Eder Kreis - Fachbereich 39, Veterinärwesen und Verbraucherschutz AVV Homber Homberg (Efze) 34576 Waßmuthshäuser Str. 52, Geb. 5 \N \N \N 2000-01-01 00:00:00
5f7f2157a7b8 backout tag 2.6.1 commit
Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de>
parents: 1334
diff changeset
34 60 06 001 \N \N \N HLUG Wiesbaden - Dezernat W2, Probenahme HLUG-W2 WI Wiesbaden 65203 Rheingaustraße 186 \N \N \N 2000-01-01 00:00:00
5f7f2157a7b8 backout tag 2.6.1 commit
Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de>
parents: 1334
diff changeset
35 78 06 LL2 \N \N \N LLH Gartenbauberatungsschwerpunkt Friedberg LLH Fb Friedberg (Hessen) 61169 Homburger Straße 17 \N \N \N 2000-01-01 00:00:00
5f7f2157a7b8 backout tag 2.6.1 commit
Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de>
parents: 1334
diff changeset
36 92 06 LL5 \N \N \N LLH Gartenbauberatungsschwerpunkt Kassel LLH Ks Kassel 34117 Kölnische Straße 48-50 \N \N \N 2000-01-01 00:00:00
5f7f2157a7b8 backout tag 2.6.1 commit
Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de>
parents: 1334
diff changeset
37 714 06 AV1 \N \N \N LK Darmstadt-Dieburg - Amt f. Veterinärwesen u. Verbraucherschutz AVV DaDieb Darmstadt 64295 Haardtring 369 \N \N \N 2000-01-01 00:00:00
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
38 784 12 V05 \N \N \N VLÜA FF Frankfurt (Oder) VLÜA FF \N \N \N \N \N \N 2000-01-01 00:00:00
1341
5f7f2157a7b8 backout tag 2.6.1 commit
Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de>
parents: 1334
diff changeset
39 813 06 001b \N \N \N HLUG Kassel - Dezernat W2, Probenahme HLUG-W2 KS Kassel 34121 Ludwig-Mond-Straße 33 \N \N \N 2000-01-01 00:00:00
5f7f2157a7b8 backout tag 2.6.1 commit
Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de>
parents: 1334
diff changeset
40 977 06 LH1 \N \N \N Landesbetrieb Hessisches Landeslabor LHL \N \N \N \N \N \N 2000-01-01 00:00:00
5f7f2157a7b8 backout tag 2.6.1 commit
Marco Lechner, Bundesamt fuer Strahlenschutz, SW 2.1 <mlechner@bfs.de>
parents: 1334
diff changeset
41 1859 12 PR3 Jan Schmidt \N LVLF Zentraler Technischer Prüfdienst - Luckau ZTPD3 \N \N \N \N \N \N 2000-01-01 00:00:00
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
42 1199 12 V15 \N \N \N VLÜA PR Perleberg VLÜA PR \N \N \N \N \N \N 2000-01-01 00:00:00
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)