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

[svn_mapbender at osgeo.org]

Author: christoph
Date: 2008-08-14 04:35:40 -0400 (Thu, 14 Aug 2008)
New Revision: 2779

Modified:
   branches/2.5/resources/db/postgresql/pgsql_serial_set_sequences_7x.sql
Log:
added sequences from 2.4.1 onwards

Modified: branches/2.5/resources/db/postgresql/pgsql_serial_set_sequences_7x.sql
===================================================================
--- branches/2.5/resources/db/postgresql/pgsql_serial_set_sequences_7x.sql	2008-08-14 08:22:39 UTC (rev 2778)
+++ branches/2.5/resources/db/postgresql/pgsql_serial_set_sequences_7x.sql	2008-08-14 08:35:40 UTC (rev 2779)
@@ -23,4 +23,15 @@
 SELECT pg_catalog.setval('wfs_featuretype_featuretype_id_seq', (Select max(featuretype_id) from wfs_featuretype), true);
 
 
-SELECT pg_catalog.setval('wms_wms_id_seq', (Select max(wms_id) from wms), true);
\ No newline at end of file
+SELECT pg_catalog.setval('wms_wms_id_seq', (Select max(wms_id) from wms), true);
+
+-- new sequences from Mapbender version 2.4.1
+SELECT pg_catalog.setval('keyword_id_seq', (Select max(keyword_id) from keyword), true);
+SELECT pg_catalog.setval('md_topic_category_id_seq', (Select max(md_topic_category_id) from md_topic_category), true);
+
+-- new sequences from Mapbender version 2.5
+SELECT pg_catalog.setval('trs_id_seq', (Select max(trs_id) from translations), true);
+SELECT pg_catalog.setval('kml_id_seq', (Select max(kml_id) from gui_kml), true);
+
+SELECT pg_catalog.setval('sld_user_layer_id_seq', (Select max(sld_user_layer_id) from sld_user_layer), true);
+