Mercurial > lada > lada-server
diff db_schema/stammdaten_init_sequences.sql @ 1197:4c6f8984ff03
Fixed setup db script.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Wed, 30 Nov 2016 12:13:36 +0100 |
| parents | 3923b41f8783 |
| children |
line wrap: on
line diff
--- a/db_schema/stammdaten_init_sequences.sql Tue Nov 29 16:00:27 2016 +0100 +++ b/db_schema/stammdaten_init_sequences.sql Wed Nov 30 12:13:36 2016 +0100 @@ -1,3 +1,5 @@ +SET search_path TO stammdaten; + SELECT pg_catalog.setval('auth_id_seq', (SELECT max(id) FROM stammdaten.auth), true); SELECT pg_catalog.setval('auth_lst_umw_id_seq', (SELECT max(id) FROM auth_lst_umw) , true); @@ -26,7 +28,7 @@ SELECT pg_catalog.setval('messgroesse_id_seq', (SELECT max(id) FROM messgroesse), true); -SELECT pg_catalog.setval('messgroessen_gruppe_id_seq', (SELECT max(id) FROM messgreossen_gruppe), true); +SELECT pg_catalog.setval('messgroessen_gruppe_id_seq', (SELECT max(id) FROM messgroessen_gruppe), true); SELECT pg_catalog.setval('messprogramm_kategorie_id_seq', (SELECT max(id) FROM messprogramm_kategorie), true); @@ -38,7 +40,7 @@ SELECT pg_catalog.setval('probenehmer_id_seq', (SELECT max(id) FROM probenehmer), true); -SELECT pg_catalog.setval('query_id_seq', SELECT max(id) FROM query), true); +SELECT pg_catalog.setval('query_id_seq', (SELECT max(id) FROM query), true); SELECT pg_catalog.setval('result_id_seq', (SELECT max(id) FROM result), true);