# HG changeset patch # User Tom Gottfried # Date 1462799962 -7200 # Node ID 9f0ea64d06438cc812c3b0bda7b3f4b5fc2c6d05 # Parent f1142c2ed5209a349a4c03c772ff1a88be3705e7 Fix IDs vs. sequence values. diff -r f1142c2ed520 -r 9f0ea64d0643 db_schema/stammdaten_data.sql --- 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); --