Mercurial > lada > lada-server
comparison db_schema/stammdaten_data.sql @ 1092:b225875c68fe
Fix IDs vs. sequence.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 13 Oct 2016 22:25:46 +0200 |
| parents | 35878d9b4321 |
| children | 186d602e031a |
comparison
equal
deleted
inserted
replaced
| 1091:8f2b1a8f2a73 | 1092:b225875c68fe |
|---|---|
| 22033 -- Dependencies: 248 | 22033 -- Dependencies: 248 |
| 22034 -- Data for Name: filter; Type: TABLE DATA; Schema: stammdaten; Owner: lada | 22034 -- Data for Name: filter; Type: TABLE DATA; Schema: stammdaten; Owner: lada |
| 22035 -- | 22035 -- |
| 22036 | 22036 |
| 22037 COPY filter (id, query_id, data_index, type, label, multiselect) FROM stdin; | 22037 COPY filter (id, query_id, data_index, type, label, multiselect) FROM stdin; |
| 22038 2 2 hpNrFilter text Probe_id-Filter f | 22038 1 2 hpNrFilter text Probe_id-Filter f |
| 22039 3 3 probeIdFilter text Probe_id-Filter f | 22039 2 3 probeIdFilter text Probe_id-Filter f |
| 22040 5 4 mstIdFilter listmst Messstelle f | 22040 3 4 mstIdFilter listmst Messstelle f |
| 22041 6 4 umwIdFilter listumw Umweltbereich f | 22041 4 4 umwIdFilter listumw Umweltbereich f |
| 22042 7 5 netzIdFilter listnetz Land f | 22042 5 5 netzIdFilter listnetz Land f |
| 22043 9 7 netzIdFilter listnetz Land f | 22043 6 7 netzIdFilter listnetz Land f |
| 22044 10 7 umwIdFilter listumw Umweltbereich t | 22044 7 7 umwIdFilter listumw Umweltbereich t |
| 22045 14 14 netzbetreiberId listnetz Land t | 22045 8 14 netzbetreiberId listnetz Land t |
| 22046 15 13 statusFilter liststatus Status t | 22046 9 13 statusFilter liststatus Status t |
| 22047 \. | 22047 \. |
| 22048 | 22048 |
| 22049 | 22049 |
| 22050 -- | 22050 -- |
| 22051 -- TOC entry 4733 (class 0 OID 0) | 22051 -- TOC entry 4733 (class 0 OID 0) |
| 22052 -- Dependencies: 249 | 22052 -- Dependencies: 249 |
| 22053 -- Name: filter_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: lada | 22053 -- Name: filter_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: lada |
| 22054 -- | 22054 -- |
| 22055 | 22055 |
| 22056 SELECT pg_catalog.setval('filter_id_seq', 14, true); | 22056 SELECT pg_catalog.setval('filter_id_seq', 9, true); |
| 22057 | 22057 |
| 22058 | 22058 |
| 22059 -- | 22059 -- |
| 22060 -- TOC entry 4685 (class 0 OID 535725) | 22060 -- TOC entry 4685 (class 0 OID 535725) |
| 22061 -- Dependencies: 250 | 22061 -- Dependencies: 250 |