Mercurial > lada > lada-server
comparison db_schema/stammdaten_data.sql @ 953:df78f385aadd
Sample data: Fix setting of query_id_seq.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Tue, 24 May 2016 17:19:48 +0200 |
| parents | 84dd8d597e61 |
| children | ac7985874392 |
comparison
equal
deleted
inserted
replaced
| 952:f4ee8cec24f2 | 953:df78f385aadd |
|---|---|
| 21999 13 nach Status messung SELECT messung.id, probe.hauptproben_nr AS hpNr, messung.nebenproben_nr AS npNr, to_char(status_protokoll.datum, 'dd.mm.YYYY hh24:MI') AS statusD, status_stufe.stufe AS statusSt, status_wert.wert AS statusW, datenbasis.datenbasis AS dBasis, probe.netzbetreiber_id AS netzId, probe.mst_id AS mstId, probe.umw_id AS umwId, probenart.probenart AS pArt, to_char(probe.probeentnahme_beginn, 'dd.mm.YYYY hh24:MI') AS peBegin, to_char(probe.probeentnahme_ende, 'dd.mm.YYYY hh24:MI') AS peEnd, ort.ort_id AS ortId, ort.gem_id AS eGemId, verwaltungseinheit.bezeichnung AS eGem FROM land.probe INNER JOIN land.messung ON probe.id = messung.probe_id INNER JOIN land.status_protokoll ON messung.STATUS = status_protokoll.id LEFT JOIN stammdaten.status_stufe ON status_protokoll.status_stufe = status_stufe.id LEFT JOIN stammdaten.status_wert ON status_protokoll.status_wert = status_wert.id LEFT JOIN stammdaten.datenbasis ON (probe.datenbasis_id = datenbasis.id) LEFT JOIN stammdaten.probenart ON (probe.probenart_id = probenart.id) LEFT JOIN land.ortszuordnung ON ( probe.id = ortszuordnung.probe_id AND ortszuordnung.ortszuordnung_typ = 'E' ) LEFT JOIN stammdaten.ort ON (ortszuordnung.ort_id = ort.id) LEFT JOIN stammdaten.verwaltungseinheit ON (ort.gem_id = verwaltungseinheit.id) WHERE (status_protokoll.status_wert IN (:statusFilter) OR '' = :statusFilter)' Messungen nach Staus | 21999 13 nach Status messung SELECT messung.id, probe.hauptproben_nr AS hpNr, messung.nebenproben_nr AS npNr, to_char(status_protokoll.datum, 'dd.mm.YYYY hh24:MI') AS statusD, status_stufe.stufe AS statusSt, status_wert.wert AS statusW, datenbasis.datenbasis AS dBasis, probe.netzbetreiber_id AS netzId, probe.mst_id AS mstId, probe.umw_id AS umwId, probenart.probenart AS pArt, to_char(probe.probeentnahme_beginn, 'dd.mm.YYYY hh24:MI') AS peBegin, to_char(probe.probeentnahme_ende, 'dd.mm.YYYY hh24:MI') AS peEnd, ort.ort_id AS ortId, ort.gem_id AS eGemId, verwaltungseinheit.bezeichnung AS eGem FROM land.probe INNER JOIN land.messung ON probe.id = messung.probe_id INNER JOIN land.status_protokoll ON messung.STATUS = status_protokoll.id LEFT JOIN stammdaten.status_stufe ON status_protokoll.status_stufe = status_stufe.id LEFT JOIN stammdaten.status_wert ON status_protokoll.status_wert = status_wert.id LEFT JOIN stammdaten.datenbasis ON (probe.datenbasis_id = datenbasis.id) LEFT JOIN stammdaten.probenart ON (probe.probenart_id = probenart.id) LEFT JOIN land.ortszuordnung ON ( probe.id = ortszuordnung.probe_id AND ortszuordnung.ortszuordnung_typ = 'E' ) LEFT JOIN stammdaten.ort ON (ortszuordnung.ort_id = ort.id) LEFT JOIN stammdaten.verwaltungseinheit ON (ort.gem_id = verwaltungseinheit.id) WHERE (status_protokoll.status_wert IN (:statusFilter) OR '' = :statusFilter)' Messungen nach Staus |
| 22000 \. | 22000 \. |
| 22001 | 22001 |
| 22002 | 22002 |
| 22003 -- | 22003 -- |
| 22004 -- TOC entry 4745 (class 0 OID 0) | |
| 22005 -- Dependencies: 282 | |
| 22006 -- Name: query_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: lada | |
| 22007 -- | |
| 22008 | |
| 22009 SELECT pg_catalog.setval('query_id_seq', 15, true); | |
| 22010 | |
| 22011 | |
| 22012 -- | |
| 22004 -- TOC entry 4681 (class 0 OID 535715) | 22013 -- TOC entry 4681 (class 0 OID 535715) |
| 22005 -- Dependencies: 246 | 22014 -- Dependencies: 246 |
| 22006 -- Data for Name: favorite; Type: TABLE DATA; Schema: stammdaten; Owner: lada | 22015 -- Data for Name: favorite; Type: TABLE DATA; Schema: stammdaten; Owner: lada |
| 22007 -- | 22016 -- |
| 22008 | 22017 |
| 36833 | 36842 |
| 36834 SELECT pg_catalog.setval('probenehmer_id_seq', 1859, true); | 36843 SELECT pg_catalog.setval('probenehmer_id_seq', 1859, true); |
| 36835 | 36844 |
| 36836 | 36845 |
| 36837 -- | 36846 -- |
| 36838 -- TOC entry 4745 (class 0 OID 0) | |
| 36839 -- Dependencies: 282 | |
| 36840 -- Name: query_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: lada | |
| 36841 -- | |
| 36842 | |
| 36843 SELECT pg_catalog.setval('query_id_seq', 14, true); | |
| 36844 | |
| 36845 | |
| 36846 -- | |
| 36847 -- TOC entry 4717 (class 0 OID 535831) | 36847 -- TOC entry 4717 (class 0 OID 535831) |
| 36848 -- Dependencies: 283 | 36848 -- Dependencies: 283 |
| 36849 -- Data for Name: result; Type: TABLE DATA; Schema: stammdaten; Owner: lada | 36849 -- Data for Name: result; Type: TABLE DATA; Schema: stammdaten; Owner: lada |
| 36850 -- | 36850 -- |
| 36851 | 36851 |