Mercurial > lada > lada-server
diff 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 |
line wrap: on
line diff
--- a/db_schema/stammdaten_data.sql Mon May 09 13:00:56 2016 +0200 +++ b/db_schema/stammdaten_data.sql Mon May 09 15:19:22 2016 +0200 @@ -317,7 +317,7 @@ -- Name: auth_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: lada -- -SELECT pg_catalog.setval('auth_id_seq', 1, false); +SELECT pg_catalog.setval('auth_id_seq', 24); -- @@ -925,8 +925,8 @@ -- COPY datensatz_erzeuger (id, netzbetreiber_id, da_erzeuger_id, mst_id, bezeichnung, letzte_aenderung) FROM stdin; -453 06 KS 06010 Messstelle HLUG Kassel 2000-01-01 00:00:00 -553 06 DA 06060 Messstelle HLUG Darmstadt 2000-01-01 00:00:00 +1 06 KS 06010 Messstelle HLUG Kassel 2000-01-01 00:00:00 +2 06 DA 06060 Messstelle HLUG Darmstadt 2000-01-01 00:00:00 \. @@ -936,7 +936,7 @@ -- Name: datensatz_erzeuger_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: lada -- -SELECT pg_catalog.setval('datensatz_erzeuger_id_seq', 5, true); +SELECT pg_catalog.setval('datensatz_erzeuger_id_seq', 2); -- @@ -22010,7 +22010,7 @@ -- COPY favorite (id, user_id, query_id) FROM stdin; -11 1 2 +1 1 2 \. @@ -22020,7 +22020,7 @@ -- Name: favorite_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: lada -- -SELECT pg_catalog.setval('favorite_id_seq', 13, true); +SELECT pg_catalog.setval('favorite_id_seq', 1); -- @@ -22066,7 +22066,7 @@ -- Name: filter_value_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: lada -- -SELECT pg_catalog.setval('filter_value_id_seq', 15, true); +SELECT pg_catalog.setval('filter_value_id_seq', 1, false); -- @@ -23189,7 +23189,7 @@ -- Name: messprogramm_kategorie_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: lada -- -SELECT pg_catalog.setval('messprogramm_kategorie_id_seq', 5, true); +SELECT pg_catalog.setval('messprogramm_kategorie_id_seq', 968, true); -- @@ -36834,7 +36834,7 @@ -- Name: probenehmer_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: lada -- -SELECT pg_catalog.setval('probenehmer_id_seq', 5, true); +SELECT pg_catalog.setval('probenehmer_id_seq', 1859, true); --