[Mapbender-commits] r7214 - trunk/mapbender/resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: marc
Date: 2010-12-11 07:00:42 -0800 (Sat, 11 Dec 2010)
New Revision: 7214

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql
Log:
replace folder for ui elements

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql	2010-12-11 14:50:11 UTC (rev 7213)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql	2010-12-11 15:00:42 UTC (rev 7214)
@@ -2724,10 +2724,10 @@
 
 -- add new column gui_layer_title
 alter table gui_layer add column gui_layer_title character varying(255) NOT NULL DEFAULT ''::character varying;
--- fill new column gui_layer_title with layer_titles from layer, where gui_layer_title is ''
-Update gui_layer set 
-gui_layer_title = l.layer_title from layer l where
-gui_layer_title = '' AND fkey_layer_id = l.layer_id;
+-- fill new column gui_layer_title with layer_titles from layer, where gui_layer_title is ''
+Update gui_layer set 
+gui_layer_title = l.layer_title from layer l where
+gui_layer_title = '' AND fkey_layer_id = l.layer_id;
 
 --adoptions for managing georss/kml urls and data in the mapbender database
 -- Table: datalink
@@ -2997,3 +2997,11 @@
 -- one special category as options to start mapbender geoportal 
 insert into custom_category (custom_category_key, custom_category_code_en,custom_category_code_de,custom_category_hidden) values ('mbc1','special standard wmc documents','Spezielle Standard WMC Dokumente',1);
 
+--
+--replace jquery ui minified folder
+--resizeable
+--
+UPDATE gui_element SET e_mb_mod=replace(e_mb_mod,'/minified/','/') where e_id ilike 'jq_ui%' ;
+UPDATE gui_element SET e_mb_mod=replace(e_mb_mod,'.min.js','.js') where e_id ilike 'jq_ui%' ;
+
+