diff db_schema/lada_schema.sql @ 798:84cc23ab49f7

Remove outdated duplicate VIEW definition.
author Tom Gottfried <tom@intevation.de>
date Thu, 19 Nov 2015 12:11:23 +0100
parents e15c981fe310
children 2059ac26fd49
line wrap: on
line diff
--- a/db_schema/lada_schema.sql	Thu Nov 19 11:45:00 2015 +0100
+++ b/db_schema/lada_schema.sql	Thu Nov 19 12:11:23 2015 +0100
@@ -1770,22 +1770,6 @@
 
 
 --
--- 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: 
 --
 
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)