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

[svn_mapbender at osgeo.org]

Author: verenadiewald
Date: 2011-09-19 04:23:21 -0700 (Mon, 19 Sep 2011)
New Revision: 8155

Modified:
   branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql
Log:
changed sql for inserting raphael.js into body element

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-16 18:46:12 UTC (rev 8154)
+++ branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql	2011-09-19 11:23:21 UTC (rev 8155)
@@ -54,8 +54,7 @@
 -- update all body elements for guis containing wz_jsgraphics.js
 ---> 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%');
+e_mb_mod = CASE WHEN e_mb_mod IS NULL THEN '../extensions/RaphaelJS/raphael-1.4.7.min.js' ELSE e_mb_mod::text ||',../extensions/RaphaelJS/raphael-1.4.7.min.js' END 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%';