# HG changeset patch # User Raimund Renkert # Date 1447948532 -3600 # Node ID 183396bac3face6c3385079a86ec0f5dc6d92b07 # Parent b04e55896104c60983b5be14cac4158d6f96981d# Parent 2059ac26fd49bee6cbbe4f1467b5386fff8717e0 merged. diff -r b04e55896104 -r 183396bac3fa db_schema/lada_schema.sql --- a/db_schema/lada_schema.sql Thu Nov 19 16:54:09 2015 +0100 +++ b/db_schema/lada_schema.sql Thu Nov 19 16:55:32 2015 +0100 @@ -1,4 +1,8 @@ --- +\set ON_ERROR_STOP on + +BEGIN; + +-- -- PostgreSQL database dump -- @@ -200,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; @@ -256,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 ( @@ -268,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 ( @@ -278,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 ( @@ -288,7 +292,7 @@ -- --- Name: list; Type: TABLE; Schema: bund; Owner: -; Tablespace: +-- Name: list; Type: TABLE; Schema: bund; Owner: -; Tablespace: -- CREATE TABLE list ( @@ -321,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 ( @@ -343,7 +347,7 @@ -- --- Name: messung; Type: TABLE; Schema: bund; Owner: -; Tablespace: +-- Name: messung; Type: TABLE; Schema: bund; Owner: -; Tablespace: -- CREATE TABLE messung ( @@ -396,7 +400,7 @@ -- --- Name: messwert; Type: TABLE; Schema: bund; Owner: -; Tablespace: +-- Name: messwert; Type: TABLE; Schema: bund; Owner: -; Tablespace: -- CREATE TABLE messwert ( @@ -426,7 +430,7 @@ -- --- Name: ort; Type: TABLE; Schema: bund; Owner: -; Tablespace: +-- Name: ort; Type: TABLE; Schema: bund; Owner: -; Tablespace: -- CREATE TABLE ort ( @@ -459,7 +463,7 @@ -- --- Name: probe; Type: TABLE; Schema: bund; Owner: -; Tablespace: +-- Name: probe; Type: TABLE; Schema: bund; Owner: -; Tablespace: -- CREATE TABLE probe ( @@ -565,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 ( @@ -589,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 ( @@ -606,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 ( @@ -615,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 ( @@ -624,7 +628,7 @@ -- --- Name: messprogramm; Type: TABLE; Schema: land; Owner: -; Tablespace: +-- Name: messprogramm; Type: TABLE; Schema: land; Owner: -; Tablespace: -- CREATE TABLE messprogramm ( @@ -679,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 ( @@ -711,7 +715,7 @@ -- --- Name: messung; Type: TABLE; Schema: land; Owner: -; Tablespace: +-- Name: messung; Type: TABLE; Schema: land; Owner: -; Tablespace: -- CREATE TABLE messung ( @@ -722,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 ( @@ -752,7 +756,7 @@ -- --- Name: messwert; Type: TABLE; Schema: land; Owner: -; Tablespace: +-- Name: messwert; Type: TABLE; Schema: land; Owner: -; Tablespace: -- CREATE TABLE messwert ( @@ -762,7 +766,7 @@ -- --- Name: ort; Type: TABLE; Schema: land; Owner: -; Tablespace: +-- Name: ort; Type: TABLE; Schema: land; Owner: -; Tablespace: -- CREATE TABLE ort ( @@ -772,7 +776,7 @@ -- --- Name: probe; Type: TABLE; Schema: land; Owner: -; Tablespace: +-- Name: probe; Type: TABLE; Schema: land; Owner: -; Tablespace: -- CREATE TABLE probe ( @@ -789,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 ( @@ -819,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 ( @@ -828,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 ( @@ -840,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 ( @@ -854,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 ( @@ -902,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 ( @@ -932,7 +936,7 @@ -- --- Name: datenbasis; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: +-- Name: datenbasis; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: -- CREATE TABLE datenbasis ( @@ -962,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 ( @@ -1006,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 ( @@ -1029,7 +1033,7 @@ -- --- Name: deskriptoren; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: +-- Name: deskriptoren; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: -- CREATE TABLE deskriptoren ( @@ -1063,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 ( @@ -1093,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 ( @@ -1125,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 ( @@ -1136,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 ( @@ -1150,7 +1154,7 @@ -- --- Name: messgroesse; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: +-- Name: messgroesse; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: -- CREATE TABLE messgroesse ( @@ -1185,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 ( @@ -1215,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 ( @@ -1225,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 ( @@ -1247,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 ( @@ -1262,7 +1266,7 @@ -- --- Name: ort; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: +-- Name: ort; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: -- CREATE TABLE ort ( @@ -1318,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 ( @@ -1350,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 ( @@ -1363,7 +1367,7 @@ -- --- Name: probenart; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: +-- Name: probenart; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: -- CREATE TABLE probenart ( @@ -1708,7 +1712,7 @@ -- --- Name: staat; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: +-- Name: staat; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: -- CREATE TABLE staat ( @@ -1744,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 ( @@ -1755,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 ( @@ -1766,23 +1770,7 @@ -- --- Name: status_erreichbar; Type: VIEW; Schema: stammdaten; Owner: - --- - -CREATE VIEW status_erreichbar AS - SELECT DISTINCT k.wert_id, - j.wert_id AS cur_wert, - j.stufe_id AS cur_stufe - FROM (status_kombi k - JOIN ( SELECT r.zu_id, - kom.wert_id, - kom.stufe_id - FROM (status_reihenfolge r - JOIN status_kombi kom ON ((kom.id = r.von_id)))) j ON ((j.zu_id = k.id))); - - --- --- Name: status_stufe; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: +-- Name: status_stufe; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: -- CREATE TABLE status_stufe ( @@ -1792,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 ( @@ -1802,7 +1790,7 @@ -- --- Name: umwelt; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: +-- Name: umwelt; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: -- CREATE TABLE umwelt ( @@ -1814,7 +1802,7 @@ -- --- Name: verwaltungseinheit; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: +-- Name: verwaltungseinheit; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: -- CREATE TABLE verwaltungseinheit ( @@ -2165,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 @@ -2173,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 @@ -2181,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 @@ -2189,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 @@ -2197,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 @@ -2205,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 @@ -2213,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 @@ -2221,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 @@ -2229,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 @@ -2237,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 @@ -2247,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 @@ -2255,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 @@ -2263,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 @@ -2271,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 @@ -2279,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 @@ -2287,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 @@ -2295,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 @@ -2303,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 @@ -2311,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 @@ -2319,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 @@ -2327,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 @@ -2335,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 @@ -2343,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 @@ -2351,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 @@ -2359,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 @@ -2367,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 @@ -2377,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 @@ -2385,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 @@ -2393,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 @@ -2401,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 @@ -2409,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 @@ -2417,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 @@ -2425,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 @@ -2433,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 @@ -2441,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 @@ -2449,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 @@ -2457,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 @@ -2465,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 @@ -2473,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 @@ -2481,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 @@ -2489,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 @@ -2497,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 @@ -2505,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 @@ -2513,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 @@ -2521,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 @@ -2529,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 @@ -2537,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 @@ -2545,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 @@ -2553,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 @@ -2561,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 @@ -2569,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 @@ -2577,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 @@ -2585,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 @@ -2593,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 @@ -2601,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 @@ -2611,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); @@ -2627,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); @@ -2664,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); @@ -3303,3 +3291,4 @@ -- PostgreSQL database dump complete -- +COMMIT;