Mercurial > lada > lada-server
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: --