svn commit: r969 - trunk/mapbender/resources/db/postgresql/pgsql_serial_set_sequences.sql

[astrid_emde at osgeo.org]

Author: astrid_emde
Date: 2006-12-01 08:43:01+0000
New Revision: 969

Modified:
   trunk/mapbender/resources/db/postgresql/pgsql_serial_set_sequences.sql

Log:
new sequences

Modified: trunk/mapbender/resources/db/postgresql/pgsql_serial_set_sequences.sql
Url: https://mapbender.osgeo.org/source/browse/mapbender/trunk/mapbender/resources/db/postgresql/pgsql_serial_set_sequences.sql?view=diff&rev=969&p1=trunk/mapbender/resources/db/postgresql/pgsql_serial_set_sequences.sql&p2=trunk/mapbender/resources/db/postgresql/pgsql_serial_set_sequences.sql&r1=968&r2=969
==============================================================================
--- trunk/mapbender/resources/db/postgresql/pgsql_serial_set_sequences.sql	(original)
+++ trunk/mapbender/resources/db/postgresql/pgsql_serial_set_sequences.sql	2006-12-01 08:43:01+0000
@@ -20,4 +20,8 @@
 SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('wfs_featuretype', 'featuretype_id'), (Select max(featuretype_id) from wfs_featuretype), true);
 
 
-SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('wms', 'wms_id'), (Select max(wms_id) from wms), true);
\ No newline at end of file
+SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('wms', 'wms_id'), (Select max(wms_id) from wms), true);
+
+-- 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);