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

[svn_mapbender at osgeo.org]

Author: marc
Date: 2009-01-14 15:53:07 -0500 (Wed, 14 Jan 2009)
New Revision: 3455

Modified:
   trunk/mapbender/resources/db/update/update_2.6.sql
Log:
added a table column(gui_type) to build different categorys in login Zebra see http://trac.osgeo.org/mapbender/ticket/344

Modified: trunk/mapbender/resources/db/update/update_2.6.sql
===================================================================
--- trunk/mapbender/resources/db/update/update_2.6.sql	2009-01-14 20:47:57 UTC (rev 3454)
+++ trunk/mapbender/resources/db/update/update_2.6.sql	2009-01-14 20:53:07 UTC (rev 3455)
@@ -108,3 +108,27 @@
 -- a demo splash screen for gui1
 INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('gui1', 'body', 'use_load_message', 'true', '' ,'php_var');
 INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('gui1', 'body', 'includeWhileLoading', '../include/gui1_splash.php', '' ,'php_var');
+
+
+--to class the Mapbender gui list and hide the wms_container
+ALTER TABLE gui
+   ADD COLUMN gui_type character varying;
+   
+UPDATE gui SET gui_type='admin' WHERE gui_id='admin1';
+UPDATE gui SET gui_type='admin' WHERE gui_id='admin2_de';
+UPDATE gui SET gui_type='admin' WHERE gui_id='admin2_en';
+UPDATE gui SET gui_type='admin' WHERE gui_id='admin_de_services';
+UPDATE gui SET gui_type='admin' WHERE gui_id='admin_en_services';
+UPDATE gui SET gui_type='map' WHERE gui_id='gui';
+UPDATE gui SET gui_type='map' WHERE gui_id='gui1';
+UPDATE gui SET gui_type='map' WHERE gui_id='gui2';
+UPDATE gui SET gui_type='digitize' WHERE gui_id='gui_digitize';
+UPDATE gui SET gui_type='wms_container' WHERE gui_id='wms_africa';
+UPDATE gui SET gui_type='wms_container' WHERE gui_id='wms_australia';
+UPDATE gui SET gui_type='wms_container' WHERE gui_id='wms_europe';
+UPDATE gui SET gui_type='wms_container' WHERE gui_id='wms_gdi_de';
+UPDATE gui SET gui_type='wms_container' WHERE gui_id='wms_germany';
+UPDATE gui SET gui_type='wms_container' WHERE gui_id='wms_north_america';
+UPDATE gui SET gui_type='wms_container' WHERE gui_id='wms_worldwide';
+   
+