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);
 
 
 --
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)