[Mapbender-commits] r2020 - branches/2.5/resources/db/postgresql

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2008-01-23 10:02:28 -0500 (Wed, 23 Jan 2008)
New Revision: 2020

Modified:
   branches/2.5/resources/db/postgresql/pgsql_serial_set_sequences.sql
Log:
new entries for new serial fields

Modified: branches/2.5/resources/db/postgresql/pgsql_serial_set_sequences.sql
===================================================================
--- branches/2.5/resources/db/postgresql/pgsql_serial_set_sequences.sql	2008-01-23 15:01:29 UTC (rev 2019)
+++ branches/2.5/resources/db/postgresql/pgsql_serial_set_sequences.sql	2008-01-23 15:02:28 UTC (rev 2020)
@@ -25,3 +25,7 @@
 -- new sequences from Mapbender version 2.4.1
 SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('keyword', 'keyword_id'), (Select max(keyword_id) from keyword), true);
 SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('md_topic_category', 'md_topic_category_id'), (Select max(md_topic_category_id) from md_topic_category), true);
+
+-- new sequences from Mapbender version 2.5
+SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('translations', 'trs_id'), (Select max(trs_id) from translations), true);
+SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('gui_kml', 'kml_id'), (Select max(kml_id) from gui_kml), true);