Mercurial > lada > lada-server
changeset 1197:4c6f8984ff03
Fixed setup db script.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Wed, 30 Nov 2016 12:13:36 +0100 |
| parents | fffd66b6ee8a |
| children | d7ffadffd363 |
| files | db_schema/stammdaten_data_verwaltungseinheit.sql db_schema/stammdaten_init_sequences.sql |
| diffstat | 2 files changed, 4 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- a/db_schema/stammdaten_data_verwaltungseinheit.sql Tue Nov 29 16:00:27 2016 +0100 +++ b/db_schema/stammdaten_data_verwaltungseinheit.sql Wed Nov 30 12:13:36 2016 +0100 @@ -13,7 +13,6 @@ SET standard_conforming_strings = on; SET check_function_bodies = false; SET client_min_messages = warning; -SET row_security = off; SET search_path = stammdaten, pg_catalog;
--- 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);