Mercurial > lada > lada-server
comparison db_schema/stammdaten_data.sql @ 938:9f0ea64d0643
Fix IDs vs. sequence values.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 09 May 2016 15:19:22 +0200 |
| parents | 56d2dd058906 |
| children | cefa1060b619 |
comparison
equal
deleted
inserted
replaced
| 937:f1142c2ed520 | 938:9f0ea64d0643 |
|---|---|
| 315 -- TOC entry 4727 (class 0 OID 0) | 315 -- TOC entry 4727 (class 0 OID 0) |
| 316 -- Dependencies: 234 | 316 -- Dependencies: 234 |
| 317 -- Name: auth_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: lada | 317 -- Name: auth_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: lada |
| 318 -- | 318 -- |
| 319 | 319 |
| 320 SELECT pg_catalog.setval('auth_id_seq', 1, false); | 320 SELECT pg_catalog.setval('auth_id_seq', 24); |
| 321 | 321 |
| 322 | 322 |
| 323 -- | 323 -- |
| 324 -- TOC entry 4691 (class 0 OID 535743) | 324 -- TOC entry 4691 (class 0 OID 535743) |
| 325 -- Dependencies: 256 | 325 -- Dependencies: 256 |
| 923 -- Dependencies: 239 | 923 -- Dependencies: 239 |
| 924 -- Data for Name: datensatz_erzeuger; Type: TABLE DATA; Schema: stammdaten; Owner: lada | 924 -- Data for Name: datensatz_erzeuger; Type: TABLE DATA; Schema: stammdaten; Owner: lada |
| 925 -- | 925 -- |
| 926 | 926 |
| 927 COPY datensatz_erzeuger (id, netzbetreiber_id, da_erzeuger_id, mst_id, bezeichnung, letzte_aenderung) FROM stdin; | 927 COPY datensatz_erzeuger (id, netzbetreiber_id, da_erzeuger_id, mst_id, bezeichnung, letzte_aenderung) FROM stdin; |
| 928 453 06 KS 06010 Messstelle HLUG Kassel 2000-01-01 00:00:00 | 928 1 06 KS 06010 Messstelle HLUG Kassel 2000-01-01 00:00:00 |
| 929 553 06 DA 06060 Messstelle HLUG Darmstadt 2000-01-01 00:00:00 | 929 2 06 DA 06060 Messstelle HLUG Darmstadt 2000-01-01 00:00:00 |
| 930 \. | 930 \. |
| 931 | 931 |
| 932 | 932 |
| 933 -- | 933 -- |
| 934 -- TOC entry 4730 (class 0 OID 0) | 934 -- TOC entry 4730 (class 0 OID 0) |
| 935 -- Dependencies: 240 | 935 -- Dependencies: 240 |
| 936 -- Name: datensatz_erzeuger_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: lada | 936 -- Name: datensatz_erzeuger_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: lada |
| 937 -- | 937 -- |
| 938 | 938 |
| 939 SELECT pg_catalog.setval('datensatz_erzeuger_id_seq', 5, true); | 939 SELECT pg_catalog.setval('datensatz_erzeuger_id_seq', 2); |
| 940 | 940 |
| 941 | 941 |
| 942 -- | 942 -- |
| 943 -- TOC entry 4678 (class 0 OID 535707) | 943 -- TOC entry 4678 (class 0 OID 535707) |
| 944 -- Dependencies: 243 | 944 -- Dependencies: 243 |
| 22008 -- Dependencies: 246 | 22008 -- Dependencies: 246 |
| 22009 -- Data for Name: favorite; Type: TABLE DATA; Schema: stammdaten; Owner: lada | 22009 -- Data for Name: favorite; Type: TABLE DATA; Schema: stammdaten; Owner: lada |
| 22010 -- | 22010 -- |
| 22011 | 22011 |
| 22012 COPY favorite (id, user_id, query_id) FROM stdin; | 22012 COPY favorite (id, user_id, query_id) FROM stdin; |
| 22013 11 1 2 | 22013 1 1 2 |
| 22014 \. | 22014 \. |
| 22015 | 22015 |
| 22016 | 22016 |
| 22017 -- | 22017 -- |
| 22018 -- TOC entry 4732 (class 0 OID 0) | 22018 -- TOC entry 4732 (class 0 OID 0) |
| 22019 -- Dependencies: 247 | 22019 -- Dependencies: 247 |
| 22020 -- Name: favorite_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: lada | 22020 -- Name: favorite_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: lada |
| 22021 -- | 22021 -- |
| 22022 | 22022 |
| 22023 SELECT pg_catalog.setval('favorite_id_seq', 13, true); | 22023 SELECT pg_catalog.setval('favorite_id_seq', 1); |
| 22024 | 22024 |
| 22025 | 22025 |
| 22026 -- | 22026 -- |
| 22027 -- TOC entry 4683 (class 0 OID 535720) | 22027 -- TOC entry 4683 (class 0 OID 535720) |
| 22028 -- Dependencies: 248 | 22028 -- Dependencies: 248 |
| 22064 -- TOC entry 4734 (class 0 OID 0) | 22064 -- TOC entry 4734 (class 0 OID 0) |
| 22065 -- Dependencies: 251 | 22065 -- Dependencies: 251 |
| 22066 -- Name: filter_value_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: lada | 22066 -- Name: filter_value_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: lada |
| 22067 -- | 22067 -- |
| 22068 | 22068 |
| 22069 SELECT pg_catalog.setval('filter_value_id_seq', 15, true); | 22069 SELECT pg_catalog.setval('filter_value_id_seq', 1, false); |
| 22070 | 22070 |
| 22071 | 22071 |
| 22072 -- | 22072 -- |
| 22073 -- TOC entry 4687 (class 0 OID 535733) | 22073 -- TOC entry 4687 (class 0 OID 535733) |
| 22074 -- Dependencies: 252 | 22074 -- Dependencies: 252 |
| 23187 -- TOC entry 4740 (class 0 OID 0) | 23187 -- TOC entry 4740 (class 0 OID 0) |
| 23188 -- Dependencies: 265 | 23188 -- Dependencies: 265 |
| 23189 -- Name: messprogramm_kategorie_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: lada | 23189 -- Name: messprogramm_kategorie_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: lada |
| 23190 -- | 23190 -- |
| 23191 | 23191 |
| 23192 SELECT pg_catalog.setval('messprogramm_kategorie_id_seq', 5, true); | 23192 SELECT pg_catalog.setval('messprogramm_kategorie_id_seq', 968, true); |
| 23193 | 23193 |
| 23194 | 23194 |
| 23195 -- | 23195 -- |
| 23196 -- TOC entry 4701 (class 0 OID 535771) | 23196 -- TOC entry 4701 (class 0 OID 535771) |
| 23197 -- Dependencies: 266 | 23197 -- Dependencies: 266 |
| 36832 -- TOC entry 4744 (class 0 OID 0) | 36832 -- TOC entry 4744 (class 0 OID 0) |
| 36833 -- Dependencies: 280 | 36833 -- Dependencies: 280 |
| 36834 -- Name: probenehmer_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: lada | 36834 -- Name: probenehmer_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: lada |
| 36835 -- | 36835 -- |
| 36836 | 36836 |
| 36837 SELECT pg_catalog.setval('probenehmer_id_seq', 5, true); | 36837 SELECT pg_catalog.setval('probenehmer_id_seq', 1859, true); |
| 36838 | 36838 |
| 36839 | 36839 |
| 36840 -- | 36840 -- |
| 36841 -- TOC entry 4745 (class 0 OID 0) | 36841 -- TOC entry 4745 (class 0 OID 0) |
| 36842 -- Dependencies: 282 | 36842 -- Dependencies: 282 |