Mercurial > lada > lada-server
diff db_schema/lada_data.sql @ 930:d3d9cd5e18f8
add initialze sequences in lada_data.sql
| author | Michael Stanko <mstanko@bfs.de> |
|---|---|
| date | Wed, 04 May 2016 16:00:41 +0200 |
| parents | 18197a04b713 |
| children | 56d2dd058906 |
line wrap: on
line diff
--- a/db_schema/lada_data.sql Wed May 04 09:13:35 2016 +0200 +++ b/db_schema/lada_data.sql Wed May 04 16:00:41 2016 +0200 @@ -1188,9 +1188,20 @@ ALTER TABLE zusatz_wert ENABLE TRIGGER ALL; --- Completed on 2016-05-04 09:10:50 CEST +SET search_path = bund, pg_catalog; + +SELECT pg_catalog.setval('kommentar_id_seq', 661, true); + +SELECT pg_catalog.setval('messung_id_seq', 1009, true); + +SELECT pg_catalog.setval('messwert_id_seq', 6471, true); + +SELECT pg_catalog.setval('ort_id_seq', 921, true); + +SELECT pg_catalog.setval('probe_id_seq', 734, true); + +SELECT pg_catalog.setval('zusatz_wert_id_seq', 30, true); -- -- PostgreSQL database dump complete -- -