Mercurial > lada > lada-server
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 797:e15c981fe310 | 798:84cc23ab49f7 |
|---|---|
| 1768 zu_id integer | 1768 zu_id integer |
| 1769 ); | 1769 ); |
| 1770 | 1770 |
| 1771 | 1771 |
| 1772 -- | 1772 -- |
| 1773 -- Name: status_erreichbar; Type: VIEW; Schema: stammdaten; Owner: - | |
| 1774 -- | |
| 1775 | |
| 1776 CREATE VIEW status_erreichbar AS | |
| 1777 SELECT DISTINCT k.wert_id, | |
| 1778 j.wert_id AS cur_wert, | |
| 1779 j.stufe_id AS cur_stufe | |
| 1780 FROM (status_kombi k | |
| 1781 JOIN ( SELECT r.zu_id, | |
| 1782 kom.wert_id, | |
| 1783 kom.stufe_id | |
| 1784 FROM (status_reihenfolge r | |
| 1785 JOIN status_kombi kom ON ((kom.id = r.von_id)))) j ON ((j.zu_id = k.id))); | |
| 1786 | |
| 1787 | |
| 1788 -- | |
| 1789 -- Name: status_stufe; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: | 1773 -- Name: status_stufe; Type: TABLE; Schema: stammdaten; Owner: -; Tablespace: |
| 1790 -- | 1774 -- |
| 1791 | 1775 |
| 1792 CREATE TABLE status_stufe ( | 1776 CREATE TABLE status_stufe ( |
| 1793 id integer NOT NULL, | 1777 id integer NOT NULL, |