Mercurial > lada > lada-server
comparison db_schema/lada_data.sql @ 913:adc0a47b7b9d
Sequences in bund schema have to be set to correct values.
This is because the inheriting tables use these sequences too.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 08 Apr 2016 12:32:34 +0200 |
| parents | 8c61587f7a7b |
| children | 6ab17d8b5558 |
comparison
equal
deleted
inserted
replaced
| 912:d8c66007fa14 | 913:adc0a47b7b9d |
|---|---|
| 1 -- | 1 -- |
| 2 -- PostgreSQL database dump | 2 -- PostgreSQL database dump |
| 3 -- | 3 -- |
| 4 | |
| 5 -- Dumped from database version 9.5.1 | |
| 6 -- Dumped by pg_dump version 9.5.0 | |
| 7 | |
| 8 -- Started on 2016-03-31 11:55:47 | |
| 9 | 4 |
| 10 SET statement_timeout = 0; | 5 SET statement_timeout = 0; |
| 11 SET lock_timeout = 0; | 6 SET lock_timeout = 0; |
| 12 SET client_encoding = 'UTF8'; | 7 SET client_encoding = 'UTF8'; |
| 13 SET standard_conforming_strings = on; | 8 SET standard_conforming_strings = on; |
| 14 SET check_function_bodies = false; | 9 SET check_function_bodies = false; |
| 15 SET client_min_messages = warning; | 10 SET client_min_messages = warning; |
| 11 | |
| 16 | 12 |
| 17 SET search_path = land, pg_catalog; | 13 SET search_path = land, pg_catalog; |
| 18 | 14 |
| 19 -- | 15 -- |
| 20 -- TOC entry 4685 (class 0 OID 535642) | 16 -- TOC entry 4685 (class 0 OID 535642) |
| 1233 \. | 1229 \. |
| 1234 | 1230 |
| 1235 | 1231 |
| 1236 ALTER TABLE zusatz_wert ENABLE TRIGGER ALL; | 1232 ALTER TABLE zusatz_wert ENABLE TRIGGER ALL; |
| 1237 | 1233 |
| 1238 -- Completed on 2016-03-31 11:55:55 | 1234 |
| 1235 | |
| 1236 SET search_path = bund, pg_catalog; | |
| 1237 | |
| 1238 SELECT pg_catalog.setval('kommentar_id_seq', 661, true); | |
| 1239 | |
| 1240 SELECT pg_catalog.setval('messung_id_seq', 1009, true); | |
| 1241 | |
| 1242 SELECT pg_catalog.setval('messwert_id_seq', 6471, true); | |
| 1243 | |
| 1244 SELECT pg_catalog.setval('ort_id_seq', 921, true); | |
| 1245 | |
| 1246 SELECT pg_catalog.setval('probe_id_seq', 733, true); | |
| 1247 | |
| 1248 SELECT pg_catalog.setval('zusatz_wert_id_seq', 30, true); | |
| 1249 | |
| 1239 | 1250 |
| 1240 -- | 1251 -- |
| 1241 -- PostgreSQL database dump complete | 1252 -- PostgreSQL database dump complete |
| 1242 -- | 1253 -- |
| 1243 | 1254 |