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

[svn_mapbender at osgeo.org]

Author: verenadiewald
Date: 2010-05-27 09:23:21 -0400 (Thu, 27 May 2010)
New Revision: 6219

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql
Log:
insert jquery-ui elements for all guis which are not admin guis or wms containers

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql	2010-05-26 14:55:49 UTC (rev 6218)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql	2010-05-27 13:23:21 UTC (rev 6219)
@@ -608,9 +608,9 @@
 
 -- jQuery UI
 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)
-SELECT gui.gui_id,'jq_ui',1,1,'The jQuery UI core','','','','',NULL ,NULL ,NULL ,NULL ,NULL ,'','','','','../extensions/jquery-ui-1.7.2.custom/development-bundle/ui/min.ui.core.js','','',''
-FROM gui WHERE gui.gui_id = 'gui1' AND gui.gui_id
-NOT IN (SELECT fkey_gui_id FROM gui_element
+SELECT gui.gui_id,'jq_ui',1,1,'The jQuery UI core','','','','',NULL ,NULL ,NULL ,NULL ,NULL ,'','','','','../extensions/jquery-ui-1.7.2.custom/development-bundle/ui/min.ui.core.js','','',''
+FROM gui WHERE gui.gui_id NOT LIKE 'admin%' AND gui.gui_id NOT LIKE 'wms%' AND gui.gui_id
+NOT IN (SELECT fkey_gui_id FROM gui_element
 WHERE e_id = 'jq_ui');
 
 INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
@@ -623,7 +623,7 @@
 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)
 SELECT gui.gui_id,'jq_datatables',1,1,'Includes the jQuery plugin datatables, use like this
 $(selector).datatables(options)','','','','',NULL ,NULL ,NULL ,NULL ,NULL ,'','','','../plugins/jq_datatables.js','../extensions/dataTables-1.5/media/js/jquery.dataTables.min.js','','','http://www.datatables.net/'
-FROM gui WHERE gui.gui_id = 'gui1' AND gui.gui_id
+FROM gui WHERE gui.gui_id NOT LIKE 'admin%' AND gui.gui_id NOT LIKE 'wms%' AND gui.gui_id
 NOT IN (SELECT fkey_gui_id FROM gui_element
 WHERE e_id = 'jq_datatables');
 
@@ -636,14 +636,14 @@
 -- jQuery UI tabs
 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)
 SELECT gui.gui_id,'jq_ui_tabs',5,1,'horizontal tabs from the jQuery UI framework','','','','',NULL ,NULL ,NULL ,NULL ,NULL ,'','','','','../extensions/jquery-ui-1.7.2.custom/development-bundle/ui/min.ui.tabs.js','','jq_ui',''
-FROM gui WHERE gui.gui_id = 'gui1' AND gui.gui_id
+FROM gui WHERE gui.gui_id NOT LIKE 'admin%' AND gui.gui_id NOT LIKE 'wms%' AND gui.gui_id
 NOT IN (SELECT fkey_gui_id FROM gui_element
 WHERE e_id = 'jq_ui_tabs');
 
 -- jQuery upload
 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)
 SELECT gui.gui_id,'jq_upload',1,1,'','','','','',NULL ,NULL ,NULL ,NULL ,NULL ,'','','','','../plugins/jq_upload.js','','',''
-FROM gui WHERE gui.gui_id = 'gui1' AND gui.gui_id
+FROM gui WHERE gui.gui_id NOT LIKE 'admin%' AND gui.gui_id NOT LIKE 'wms%' AND gui.gui_id
 NOT IN (SELECT fkey_gui_id FROM gui_element
 WHERE e_id = 'jq_upload');
 
@@ -2470,6 +2470,7 @@
 WITHOUT OIDS;
 
 -- terms of use content
+
 INSERT INTO termsofuse (termsofuse_id, name, symbollink, description, descriptionlink) VALUES (1, 'CC by-nc-nd','http://i.creativecommons.org/l/by-nc-nd/3.0/de/88x31.png','Creative Commons: Namensnennung - Keine kommerzielle Nutzung - Keine Bearbeitungen 3.0 Deutschland','http://creativecommons.org/licenses/by-nc-nd/3.0/de/');
 
 --update to jQuery 1.4.2 and jQuery UI 1.8.1
@@ -2509,4 +2510,3 @@
 
 UPDATE gui_element SET e_mb_mod = '../extensions/jquery-ui-1.8.1.custom/development-bundle/ui/minified/jquery.effects.core.min.js' WHERE e_id = 'jq_ui_effects';
 
-