[Mapbender-commits] r3643 - trunk/mapbender/resources/db/update

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2009-03-06 10:40:30 -0500 (Fri, 06 Mar 2009)
New Revision: 3643

Modified:
   trunk/mapbender/resources/db/update/update_2.6.sql
Log:
setsequence category_id

Modified: trunk/mapbender/resources/db/update/update_2.6.sql
===================================================================
--- trunk/mapbender/resources/db/update/update_2.6.sql	2009-03-06 15:37:07 UTC (rev 3642)
+++ trunk/mapbender/resources/db/update/update_2.6.sql	2009-03-06 15:40:30 UTC (rev 3643)
@@ -328,6 +328,8 @@
 INSERT INTO gui_gui_category VALUES('wms_germany',3);
 INSERT INTO gui_gui_category VALUES('wms_europe',3);
 
+SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('gui_category', 'category_id'), (Select max(category_id) from gui_category), true);
+
 -- admin2_de - create a new category
 INSERT INTO gui_element(fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES('admin2_de','createCategory',2,1,'create a gui category','Create a new category','a','','href = "../php/mod_createCategory.php?sessionID" target = "AdminFrame" ',8,680,140,20,5,'','create a gui category','a','','','','AdminFrame','http://www.mapbender.org/GUI_Category');
 INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('admin2_de', 'createCategory', 'cssfile', '../css/administration_alloc.css', '' ,'file/css');