Mercurial > lada > lada-server

changeset 799:2059ac26fd49

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Whitespace-cleanup in schema definitions.
author Tom Gottfried <tom@intevation.de>
date Thu, 19 Nov 2015 12:13:10 +0100
parents 84cc23ab49f7
children 183396bac3fa
files db_schema/lada_schema.sql
diffstat 1 files changed, 120 insertions(+), 6 deletions(-) [+]
line wrap: on
line diff
--- a/db_schema/lada_schema.sql	Thu Nov 19 12:11:23 2015 +0100
+++ b/db_schema/lada_schema.sql	Thu Nov 19 12:13:10 2015 +0100
@@ -204,29 +204,29 @@
         if d02 = '00' or d00 <> '01' then
           select s01.beschreibung into result FROM stammdaten.deskriptoren s01
           where s01.ebene = 1 and s01.sn = d01::smallint
-            and s01.vorgaenger = 
+            and s01.vorgaenger =
               (select s00.id FROM stammdaten.deskriptoren s00
                where s00.ebene = 0 and s00.sn = d00::smallint);
         else
           if d03 = '00' then
             select s02.beschreibung into result FROM stammdaten.deskriptoren s02
             where s02.ebene = 2 and s02.sn = d02::smallint
-              and s02.vorgaenger = 
+              and s02.vorgaenger =
                 (select s01.id FROM stammdaten.deskriptoren s01
                  where s01.ebene = 1 and s01.sn = d01::smallint
-                   and s01.vorgaenger = 
+                   and s01.vorgaenger =
                      (select s00.id FROM stammdaten.deskriptoren s00
                       where s00.ebene = 0 and s00.sn = d00::smallint));
           else
             select s03.beschreibung into result FROM stammdaten.deskriptoren s03
             where s03.ebene = 3 and s03.sn = d03::smallint
-              and s03.vorgaenger = 
+              and s03.vorgaenger =
               (select s02.id FROM stammdaten.deskriptoren s02
               where s02.ebene = 2 and s02.sn = d02::smallint
-                and s02.vorgaenger = 
+                and s02.vorgaenger =
                   (select s01.id FROM stammdaten.deskriptoren s01
                   where s01.ebene = 1 and s01.sn = d01::smallint
-                    and s01.vorgaenger = 
+                    and s01.vorgaenger =
                       (select s00.id FROM stammdaten.deskriptoren s00
                       where s00.ebene = 0 and s00.sn = d00::smallint)));
           end if;
@@ -260,7 +260,7 @@
 SET default_with_oids = false;
 
 --
--- Name: kommentar; Type: TABLE; Schema: bund; Owner: -; Tablespace: 
+-- Name: kommentar; Type: TABLE; Schema: bund; Owner: -; Tablespace:
 --
 
 CREATE TABLE kommentar (
@@ -272,7 +272,7 @@
 
 
 --
--- Name: kommentar_m; Type: TABLE; Schema: bund; Owner: -; Tablespace: 
+-- Name: kommentar_m; Type: TABLE; Schema: bund; Owner: -; Tablespace:
 --
 
 CREATE TABLE kommentar_m (
@@ -282,7 +282,7 @@
 
 
 --
--- Name: kommentar_p; Type: TABLE; Schema: bund; Owner: -; Tablespace: 
+-- Name: kommentar_p; Type: TABLE; Schema: bund; Owner: -; Tablespace:
 --
 
 CREATE TABLE kommentar_p (
@@ -292,7 +292,7 @@
 
 
 --
--- Name: list; Type: TABLE; Schema: bund; Owner: -; Tablespace: 
+-- Name: list; Type: TABLE; Schema: bund; Owner: -; Tablespace:
 --
 
 CREATE TABLE list (
@@ -325,7 +325,7 @@
 
 
 --
--- Name: list_zuordnung; Type: TABLE; Schema: bund; Owner: -; Tablespace: 
+-- Name: list_zuordnung; Type: TABLE; Schema: bund; Owner: -; Tablespace:
 --
 
 CREATE TABLE list_zuordnung (
@@ -347,7 +347,7 @@
 
 
 --
--- Name: messung; Type: TABLE; Schema: bund; Owner: -; Tablespace: 
+-- Name: messung; Type: TABLE; Schema: bund; Owner: -; Tablespace:
 --
 
 CREATE TABLE messung (
@@ -400,7 +400,7 @@
 
 
 --
--- Name: messwert; Type: TABLE; Schema: bund; Owner: -; Tablespace: 
+-- Name: messwert; Type: TABLE; Schema: bund; Owner: -; Tablespace:
 --
 
 CREATE TABLE messwert (
@@ -430,7 +430,7 @@
 
 
 --
--- Name: ort; Type: TABLE; Schema: bund; Owner: -; Tablespace: 
+-- Name: ort; Type: TABLE; Schema: bund; Owner: -; Tablespace:
 --
 
 CREATE TABLE ort (
@@ -463,7 +463,7 @@
 
 
 --
--- Name: probe; Type: TABLE; Schema: bund; Owner: -; Tablespace: 
+-- Name: probe; Type: TABLE; Schema: bund; Owner: -; Tablespace:
 --
 
 CREATE TABLE probe (
@@ -569,7 +569,7 @@
 
 
 --
--- Name: status_protokoll; Type: TABLE; Schema: bund; Owner: -; Tablespace: 
+-- Name: status_protokoll; Type: TABLE; Schema: bund; Owner: -; Tablespace:
 --
 
 CREATE TABLE status_protokoll (
@@ -593,7 +593,7 @@
 
 
 --
--- Name: zusatz_wert; Type: TABLE; Schema: bund; Owner: -; Tablespace: 
+-- Name: zusatz_wert; Type: TABLE; Schema: bund; Owner: -; Tablespace:
 --
 
 CREATE TABLE zusatz_wert (
@@ -610,7 +610,7 @@
 SET search_path = land, pg_catalog;
 
 --
--- Name: kommentar_m; Type: TABLE; Schema: land; Owner: -; Tablespace: 
+-- Name: kommentar_m; Type: TABLE; Schema: land; Owner: -; Tablespace:
 --
 
 CREATE TABLE kommentar_m (
@@ -619,7 +619,7 @@
 
 
 --
--- Name: kommentar_p; Type: TABLE; Schema: land; Owner: -; Tablespace: 
+-- Name: kommentar_p; Type: TABLE; Schema: land; Owner: -; Tablespace:
 --
 
 CREATE TABLE kommentar_p (
@@ -628,7 +628,7 @@
 
 
 --
--- Name: messprogramm; Type: TABLE; Schema: land; Owner: -; Tablespace: 
+-- Name: messprogramm; Type: TABLE; Schema: land; Owner: -; Tablespace:
 --
 
 CREATE TABLE messprogramm (
@@ -683,7 +683,7 @@
 
 
 --
--- Name: messprogramm_mmt; Type: TABLE; Schema: land; Owner: -; Tablespace: 
+-- Name: messprogramm_mmt; Type: TABLE; Schema: land; Owner: -; Tablespace:
 --
 
 CREATE TABLE messprogramm_mmt (
@@ -715,7 +715,7 @@
 
 
 --
--- Name: messung; Type: TABLE; Schema: land; Owner: -; Tablespace: 
+-- Name: messung; Type: TABLE; Schema: land; Owner: -; Tablespace:
 --
 
 CREATE TABLE messung (
@@ -726,7 +726,7 @@
 
 
 --
--- Name: messung_translation; Type: TABLE; Schema: land; Owner: -; Tablespace: 
+-- Name: messung_translation; Type: TABLE; Schema: land; Owner: -; Tablespace:
 --
 
 CREATE TABLE messung_translation (
@@ -756,7 +756,7 @@
 
 
 --
--- Name: messwert; Type: TABLE; Schema: land; Owner: -; Tablespace: 
+-- Name: messwert; Type: TABLE; Schema: land; Owner: -; Tablespace:
 --
 
 CREATE TABLE messwert (
@@ -766,7 +766,7 @@
 
 
 --
--- Name: ort; Type: TABLE; Schema: land; Owner: -; Tablespace: 
+-- Name: ort; Type: TABLE; Schema: land; Owner: -; Tablespace:
 --
 
 CREATE TABLE ort (
@@ -776,7 +776,7 @@
 
 
 --
--- Name: probe; Type: TABLE; Schema: land; Owner: -; Tablespace: 
+-- Name: probe; Type: TABLE; Schema: land; Owner: -; Tablespace:
 --
 
 CREATE TABLE probe (
@@ -793,7 +793,7 @@
 
 
 --
--- Name: probe_translation; Type: TABLE; Schema: land; Owner: -; Tablespace: 
+-- Name: probe_translation; Type: TABLE; Schema: land; Owner: -; Tablespace:
 --
 
 CREATE TABLE probe_translation (
@@ -823,7 +823,7 @@
 
 
 --
--- Name: status_protokoll; Type: TABLE; Schema: land; Owner: -; Tablespace: 
+-- Name: status_protokoll; Type: TABLE; Schema: land; Owner: -; Tablespace:
 --
 
 CREATE TABLE status_protokoll (
@@ -832,7 +832,7 @@
 
 
 --
--- Name: zusatz_wert; Type: TABLE; Schema: land; Owner: -; Tablespace: 
+-- Name: zusatz_wert; Type: TABLE; Schema: land; Owner: -; Tablespace:
 --
 
 CREATE TABLE zusatz_wert (
@@ -844,7 +844,7 @@
 SET search_path = stammdaten, pg_catalog;
 
 --
--- Name: auth; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: auth; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE auth (
@@ -858,7 +858,7 @@
 
 
 --
--- Name: auth_funktion; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: auth_funktion; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE auth_funktion (
@@ -906,7 +906,7 @@
 
 
 --
--- Name: auth_lst_umw; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: auth_lst_umw; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE auth_lst_umw (
@@ -936,7 +936,7 @@
 
 
 --
--- Name: datenbasis; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: datenbasis; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE datenbasis (
@@ -966,7 +966,7 @@
 
 
 --
--- Name: de_vg; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: de_vg; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE de_vg (
@@ -1010,7 +1010,7 @@
 
 
 --
--- Name: deskriptor_umwelt; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: deskriptor_umwelt; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE deskriptor_umwelt (
@@ -1033,7 +1033,7 @@
 
 
 --
--- Name: deskriptoren; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: deskriptoren; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE deskriptoren (
@@ -1067,7 +1067,7 @@
 
 
 --
--- Name: koordinaten_art; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: koordinaten_art; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE koordinaten_art (
@@ -1097,7 +1097,7 @@
 
 
 --
--- Name: mess_einheit; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: mess_einheit; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE mess_einheit (
@@ -1129,7 +1129,7 @@
 
 
 --
--- Name: mess_methode; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: mess_methode; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE mess_methode (
@@ -1140,7 +1140,7 @@
 
 
 --
--- Name: mess_stelle; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: mess_stelle; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE mess_stelle (
@@ -1154,7 +1154,7 @@
 
 
 --
--- Name: messgroesse; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: messgroesse; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE messgroesse (
@@ -1189,7 +1189,7 @@
 
 
 --
--- Name: messgroessen_gruppe; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: messgroessen_gruppe; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE messgroessen_gruppe (
@@ -1219,7 +1219,7 @@
 
 
 --
--- Name: mg_grp; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: mg_grp; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE mg_grp (
@@ -1229,7 +1229,7 @@
 
 
 --
--- Name: mmt_messgroesse_grp; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: mmt_messgroesse_grp; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE mmt_messgroesse_grp (
@@ -1251,7 +1251,7 @@
 
 
 --
--- Name: netz_betreiber; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: netz_betreiber; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE netz_betreiber (
@@ -1266,7 +1266,7 @@
 
 
 --
--- Name: ort; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: ort; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE ort (
@@ -1322,7 +1322,7 @@
 
 
 --
--- Name: pflicht_messgroesse; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: pflicht_messgroesse; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE pflicht_messgroesse (
@@ -1354,7 +1354,7 @@
 
 
 --
--- Name: proben_zusatz; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: proben_zusatz; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE proben_zusatz (
@@ -1367,7 +1367,7 @@
 
 
 --
--- Name: probenart; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: probenart; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE probenart (
@@ -1712,7 +1712,7 @@
 
 
 --
--- Name: staat; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: staat; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE staat (
@@ -1748,7 +1748,7 @@
 
 
 --
--- Name: status_kombi; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: status_kombi; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE status_kombi (
@@ -1759,7 +1759,7 @@
 
 
 --
--- Name: status_reihenfolge; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: status_reihenfolge; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE status_reihenfolge (
@@ -1770,7 +1770,7 @@
 
 
 --
--- Name: status_stufe; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: status_stufe; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE status_stufe (
@@ -1780,7 +1780,7 @@
 
 
 --
--- Name: status_wert; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: status_wert; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE status_wert (
@@ -1790,7 +1790,7 @@
 
 
 --
--- Name: umwelt; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: umwelt; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE umwelt (
@@ -1802,7 +1802,7 @@
 
 
 --
--- Name: verwaltungseinheit; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: verwaltungseinheit; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE TABLE verwaltungseinheit (
@@ -2153,7 +2153,7 @@
 SET search_path = bund, pg_catalog;
 
 --
--- Name: kommentar_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace: 
+-- Name: kommentar_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY kommentar
@@ -2161,7 +2161,7 @@
 
 
 --
--- Name: list_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace: 
+-- Name: list_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY list
@@ -2169,7 +2169,7 @@
 
 
 --
--- Name: messung_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace: 
+-- Name: messung_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY messung
@@ -2177,7 +2177,7 @@
 
 
 --
--- Name: messwert_messungs_id_messgroesse_id_key; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace: 
+-- Name: messwert_messungs_id_messgroesse_id_key; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY messwert
@@ -2185,7 +2185,7 @@
 
 
 --
--- Name: messwert_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace: 
+-- Name: messwert_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY messwert
@@ -2193,7 +2193,7 @@
 
 
 --
--- Name: ort_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace: 
+-- Name: ort_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY ort
@@ -2201,7 +2201,7 @@
 
 
 --
--- Name: probe_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace: 
+-- Name: probe_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY probe
@@ -2209,7 +2209,7 @@
 
 
 --
--- Name: status_protokoll_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace: 
+-- Name: status_protokoll_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY status_protokoll
@@ -2217,7 +2217,7 @@
 
 
 --
--- Name: zusatz_wert_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace: 
+-- Name: zusatz_wert_pkey; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY zusatz_wert
@@ -2225,7 +2225,7 @@
 
 
 --
--- Name: zusatz_wert_probe_id_pzs_id_key; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace: 
+-- Name: zusatz_wert_probe_id_pzs_id_key; Type: CONSTRAINT; Schema: bund; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY zusatz_wert
@@ -2235,7 +2235,7 @@
 SET search_path = land, pg_catalog;
 
 --
--- Name: kommentar_m_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 
+-- Name: kommentar_m_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY kommentar_m
@@ -2243,7 +2243,7 @@
 
 
 --
--- Name: kommentar_p_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 
+-- Name: kommentar_p_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY kommentar_p
@@ -2251,7 +2251,7 @@
 
 
 --
--- Name: messprogramm_mmt_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 
+-- Name: messprogramm_mmt_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY messprogramm_mmt
@@ -2259,7 +2259,7 @@
 
 
 --
--- Name: messprogramm_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 
+-- Name: messprogramm_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY messprogramm
@@ -2267,7 +2267,7 @@
 
 
 --
--- Name: messung_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 
+-- Name: messung_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY messung
@@ -2275,7 +2275,7 @@
 
 
 --
--- Name: messung_translation_messungs_id_key; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 
+-- Name: messung_translation_messungs_id_key; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY messung_translation
@@ -2283,7 +2283,7 @@
 
 
 --
--- Name: messung_translation_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 
+-- Name: messung_translation_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY messung_translation
@@ -2291,7 +2291,7 @@
 
 
 --
--- Name: messwert_messungs_id_messgroesse_id_key; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 
+-- Name: messwert_messungs_id_messgroesse_id_key; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY messwert
@@ -2299,7 +2299,7 @@
 
 
 --
--- Name: messwert_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 
+-- Name: messwert_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY messwert
@@ -2307,7 +2307,7 @@
 
 
 --
--- Name: ort_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 
+-- Name: ort_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY ort
@@ -2315,7 +2315,7 @@
 
 
 --
--- Name: probe_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 
+-- Name: probe_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY probe
@@ -2323,7 +2323,7 @@
 
 
 --
--- Name: probe_translation_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 
+-- Name: probe_translation_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY probe_translation
@@ -2331,7 +2331,7 @@
 
 
 --
--- Name: probe_translation_probe_id_key; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 
+-- Name: probe_translation_probe_id_key; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY probe_translation
@@ -2339,7 +2339,7 @@
 
 
 --
--- Name: status_protokoll_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 
+-- Name: status_protokoll_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY status_protokoll
@@ -2347,7 +2347,7 @@
 
 
 --
--- Name: zusatz_wert_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 
+-- Name: zusatz_wert_pkey; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY zusatz_wert
@@ -2355,7 +2355,7 @@
 
 
 --
--- Name: zusatz_wert_probe_id_pzs_id_key; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace: 
+-- Name: zusatz_wert_probe_id_pzs_id_key; Type: CONSTRAINT; Schema: land; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY zusatz_wert
@@ -2365,7 +2365,7 @@
 SET search_path = stammdaten, pg_catalog;
 
 --
--- Name: auth_lst_umw_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: auth_lst_umw_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY auth_lst_umw
@@ -2373,7 +2373,7 @@
 
 
 --
--- Name: auth_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: auth_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY auth
@@ -2381,7 +2381,7 @@
 
 
 --
--- Name: auth_role_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: auth_role_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY auth_funktion
@@ -2389,7 +2389,7 @@
 
 
 --
--- Name: datenbasis_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: datenbasis_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY datenbasis
@@ -2397,7 +2397,7 @@
 
 
 --
--- Name: de_vg_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: de_vg_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY de_vg
@@ -2405,7 +2405,7 @@
 
 
 --
--- Name: deskriptor_umwelt_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: deskriptor_umwelt_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY deskriptor_umwelt
@@ -2413,7 +2413,7 @@
 
 
 --
--- Name: koordinaten_art_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: koordinaten_art_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY koordinaten_art
@@ -2421,7 +2421,7 @@
 
 
 --
--- Name: mess_einheit_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: mess_einheit_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY mess_einheit
@@ -2429,7 +2429,7 @@
 
 
 --
--- Name: mess_methode_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: mess_methode_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY mess_methode
@@ -2437,7 +2437,7 @@
 
 
 --
--- Name: mess_stelle_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: mess_stelle_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY mess_stelle
@@ -2445,7 +2445,7 @@
 
 
 --
--- Name: messgroesse_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: messgroesse_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY messgroesse
@@ -2453,7 +2453,7 @@
 
 
 --
--- Name: messgroessen_gruppe_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: messgroessen_gruppe_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY messgroessen_gruppe
@@ -2461,7 +2461,7 @@
 
 
 --
--- Name: mg_grp_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: mg_grp_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY mg_grp
@@ -2469,7 +2469,7 @@
 
 
 --
--- Name: mmt_messgroesse_grp_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: mmt_messgroesse_grp_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY mmt_messgroesse_grp
@@ -2477,7 +2477,7 @@
 
 
 --
--- Name: netz_betreiber_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: netz_betreiber_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY netz_betreiber
@@ -2485,7 +2485,7 @@
 
 
 --
--- Name: ort_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: ort_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY ort
@@ -2493,7 +2493,7 @@
 
 
 --
--- Name: pflicht_messgroesse_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: pflicht_messgroesse_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY pflicht_messgroesse
@@ -2501,7 +2501,7 @@
 
 
 --
--- Name: pk_deskriptoren; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: pk_deskriptoren; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY deskriptoren
@@ -2509,7 +2509,7 @@
 
 
 --
--- Name: proben_zusatz_eudf_keyword_key; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: proben_zusatz_eudf_keyword_key; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY proben_zusatz
@@ -2517,7 +2517,7 @@
 
 
 --
--- Name: proben_zusatz_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: proben_zusatz_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY proben_zusatz
@@ -2525,7 +2525,7 @@
 
 
 --
--- Name: probenart_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: probenart_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY probenart
@@ -2533,7 +2533,7 @@
 
 
 --
--- Name: staat_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: staat_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY staat
@@ -2541,7 +2541,7 @@
 
 
 --
--- Name: status_kombi_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: status_kombi_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY status_kombi
@@ -2549,7 +2549,7 @@
 
 
 --
--- Name: status_reihenfolge_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: status_reihenfolge_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY status_reihenfolge
@@ -2557,7 +2557,7 @@
 
 
 --
--- Name: status_stufe_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: status_stufe_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY status_stufe
@@ -2565,7 +2565,7 @@
 
 
 --
--- Name: status_wert_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: status_wert_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY status_wert
@@ -2573,7 +2573,7 @@
 
 
 --
--- Name: umwelt_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: umwelt_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY umwelt
@@ -2581,7 +2581,7 @@
 
 
 --
--- Name: umwelt_umwelt_bereich_key; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: umwelt_umwelt_bereich_key; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY umwelt
@@ -2589,7 +2589,7 @@
 
 
 --
--- Name: verwaltungseinheit_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: verwaltungseinheit_pkey; Type: CONSTRAINT; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 ALTER TABLE ONLY verwaltungseinheit
@@ -2599,14 +2599,14 @@
 SET search_path = bund, pg_catalog;
 
 --
--- Name: p_list_zuord1; Type: INDEX; Schema: bund; Owner: -; Tablespace: 
+-- Name: p_list_zuord1; Type: INDEX; Schema: bund; Owner: -; Tablespace:
 --
 
 CREATE INDEX p_list_zuord1 ON list_zuordnung USING btree (list_id);
 
 
 --
--- Name: p_list_zuord2; Type: INDEX; Schema: bund; Owner: -; Tablespace: 
+-- Name: p_list_zuord2; Type: INDEX; Schema: bund; Owner: -; Tablespace:
 --
 
 CREATE INDEX p_list_zuord2 ON list_zuordnung USING hash (list_id);
@@ -2615,35 +2615,35 @@
 SET search_path = land, pg_catalog;
 
 --
--- Name: messung_probe_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: 
+-- Name: messung_probe_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace:
 --
 
 CREATE INDEX messung_probe_id_idx ON messung USING btree (probe_id);
 
 
 --
--- Name: messung_translation_messungs_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: 
+-- Name: messung_translation_messungs_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace:
 --
 
 CREATE INDEX messung_translation_messungs_id_idx ON messung_translation USING btree (messungs_id);
 
 
 --
--- Name: messwert_messungs_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: 
+-- Name: messwert_messungs_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace:
 --
 
 CREATE INDEX messwert_messungs_id_idx ON messwert USING btree (messungs_id);
 
 
 --
--- Name: probe_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: 
+-- Name: probe_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace:
 --
 
 CREATE INDEX probe_id_idx ON probe USING btree (id);
 
 
 --
--- Name: probe_translation_probe_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: 
+-- Name: probe_translation_probe_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace:
 --
 
 CREATE INDEX probe_translation_probe_id_idx ON probe_translation USING btree (probe_id);
@@ -2652,14 +2652,14 @@
 SET search_path = stammdaten, pg_catalog;
 
 --
--- Name: de_vg_geom_gist; Type: INDEX; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: de_vg_geom_gist; Type: INDEX; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE INDEX de_vg_geom_gist ON de_vg USING gist (geom);
 
 
 --
--- Name: fts_stauts_kooin10001; Type: INDEX; Schema: stammdaten; Owner: -; Tablespace: 
+-- Name: fts_stauts_kooin10001; Type: INDEX; Schema: stammdaten; Owner: -; Tablespace:
 --
 
 CREATE INDEX fts_stauts_kooin10001 ON staat USING btree (kda_id);
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)