[Mapbender-commits] r8132 - branches/2.7/resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: verenadiewald
Date: 2011-09-12 01:52:45 -0700 (Mon, 12 Sep 2011)
New Revision: 8132

Modified:
   branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql
Log:
http://trac.osgeo.org/mapbender/ticket/867

Modified: branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql
===================================================================
--- branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql	2011-09-12 08:41:30 UTC (rev 8131)
+++ branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql	2011-09-12 08:52:45 UTC (rev 8132)
@@ -55,4 +55,13 @@
 ---> otherwise new wz_jsgraphics version leads to an error
 UPDATE gui_element set
 e_mb_mod = '../extensions/RaphaelJS/raphael-1.4.7.min.js'
-where e_id = 'body' and fkey_gui_id IN (SELECT DISTINCT fkey_gui_id FROM gui_element where e_js_file LIKE '%wz_jsgraphics%' OR e_mb_mod LIKE '%wz_jsgraphics%');
\ No newline at end of file
+where e_id = 'body' and fkey_gui_id IN (SELECT DISTINCT fkey_gui_id FROM gui_element where e_js_file LIKE '%wz_jsgraphics%' OR e_mb_mod LIKE '%wz_jsgraphics%');
+
+--update all gui elements using jquery-ui version 1.8.1 to 1.8.16
+update gui_element set e_mb_mod = replace(e_mb_mod, 'jquery-ui-1.8.1.custom', 'jquery-ui-1.8.16.custom') where e_mb_mod LIKE '%jquery-ui-1.8.1.custom%';
+--update all gui elements using jquery-ui version 1.8.14 to 1.8.16
+update gui_element set e_mb_mod = replace(e_mb_mod, 'jquery-ui-1.8.14.custom', 'jquery-ui-1.8.16.custom') where e_mb_mod LIKE '%jquery-ui-1.8.14.custom%';
+--update all gui elements using jquery-ui version 1.7.2 to 1.8.16
+update gui_element set e_mb_mod = replace(e_mb_mod, 'jquery-ui-1.7.2.custom', 'jquery-ui-1.8.16.custom') where e_mb_mod LIKE '%jquery-ui-1.7.2.custom%';
+--update gui element printPDF -> new file for jquery bgiframe js
+update gui_element set e_mb_mod = replace(e_mb_mod, '/external/bgiframe/jquery.bgiframe.min.js', '/external/jquery.bgiframe-2.1.2.js') where e_mb_mod LIKE '%jquery.bgiframe.min.js%';
\ No newline at end of file