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

[svn_mapbender at osgeo.org]

Author: verenadiewald
Date: 2010-03-17 05:54:54 -0400 (Wed, 17 Mar 2010)
New Revision: 5799

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql
Log:
added complete element vars inserting for featureInfo1 and featureInfoTunnel

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-03-17 09:49:54 UTC (rev 5798)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql	2010-03-17 09:54:54 UTC (rev 5799)
@@ -1469,3 +1469,100 @@
 
 -- remove obsolete js from dialog
 UPDATE gui_element SET e_js_file = '' WHERE e_id = 'jq_ui_dialog';
+
+--
+-- add element var featureInfoLayerPopup to element featureInfoTunnel
+--
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
+SELECT gui_element.fkey_gui_id,
+'featureInfoTunnel', 'featureInfoLayerPopup', 'true', 'display featureInfo in dialog popup' ,'var'
+from gui_element
+WHERE
+gui_element.e_id = 'featureInfoTunnel' AND
+gui_element.fkey_gui_id
+NOT IN (SELECT fkey_gui_id FROM gui_element_vars WHERE fkey_e_id = 'featureInfoTunnel' AND var_name = 'featureInfoLayerPopup');
+
+--
+-- add element var featureInfoPopupHeight to element featureInfoTunnel
+--
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
+SELECT gui_element.fkey_gui_id,
+'featureInfoTunnel', 'featureInfoPopupHeight', '200', 'height of the featureInfo dialog popup' ,'var'
+from gui_element
+WHERE
+gui_element.e_id = 'featureInfoTunnel' AND
+gui_element.fkey_gui_id
+NOT IN (SELECT fkey_gui_id FROM gui_element_vars WHERE fkey_e_id = 'featureInfoTunnel' AND var_name = 'featureInfoPopupHeight');
+
+--
+-- add element var featureInfoPopupWidth to element featureInfoTunnel
+--
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
+SELECT gui_element.fkey_gui_id,
+'featureInfoTunnel', 'featureInfoPopupWidth', '270', 'width of the featureInfo dialog popup' ,'var'
+from gui_element
+WHERE
+gui_element.e_id = 'featureInfoTunnel' AND
+gui_element.fkey_gui_id
+NOT IN (SELECT fkey_gui_id FROM gui_element_vars WHERE fkey_e_id = 'featureInfoTunnel' AND var_name = 'featureInfoPopupWidth');
+
+--
+-- add element var featureInfoPopupWidth to element featureInfoTunnel
+--
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
+SELECT gui_element.fkey_gui_id,
+'featureInfoTunnel', 'featureInfoPopupPosition', '[100,100]', 'position of the featureInfoPopup' ,'var'
+from gui_element
+WHERE
+gui_element.e_id = 'featureInfoTunnel' AND
+gui_element.fkey_gui_id
+NOT IN (SELECT fkey_gui_id FROM gui_element_vars WHERE fkey_e_id = 'featureInfoTunnel' AND var_name = 'featureInfoPopupPosition');
+
+--
+-- add element var featureInfoLayerPopup to element featureInfo1
+--
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
+SELECT gui_element.fkey_gui_id,
+'featureInfo1', 'featureInfoLayerPopup', 'true', 'display featureInfo in dialog popup' ,'var'
+from gui_element
+WHERE
+gui_element.e_id = 'featureInfo1' AND
+gui_element.fkey_gui_id
+NOT IN (SELECT fkey_gui_id FROM gui_element_vars WHERE fkey_e_id = 'featureInfo1' AND var_name = 'featureInfoLayerPopup');
+
+--
+-- add element var featureInfoPopupHeight to element featureInfo1
+--
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
+SELECT gui_element.fkey_gui_id,
+'featureInfo1', 'featureInfoPopupHeight', '200', 'height of the featureInfo dialog popup' ,'var'
+from gui_element
+WHERE
+gui_element.e_id = 'featureInfo1' AND
+gui_element.fkey_gui_id
+NOT IN (SELECT fkey_gui_id FROM gui_element_vars WHERE fkey_e_id = 'featureInfo1' AND var_name = 'featureInfoPopupHeight');
+
+--
+-- add element var featureInfoPopupWidth to element featureInfo1
+--
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
+SELECT gui_element.fkey_gui_id,
+'featureInfo1', 'featureInfoPopupWidth', '270', 'width of the featureInfo dialog popup' ,'var'
+from gui_element
+WHERE
+gui_element.e_id = 'featureInfo1' AND
+gui_element.fkey_gui_id
+NOT IN (SELECT fkey_gui_id FROM gui_element_vars WHERE fkey_e_id = 'featureInfo1' AND var_name = 'featureInfoPopupWidth');
+
+--
+-- add element var featureInfoPopupWidth to element featureInfo1
+--
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
+SELECT gui_element.fkey_gui_id,
+'featureInfo1', 'featureInfoPopupPosition', '[100,100]', 'position of the featureInfoPopup' ,'var'
+from gui_element
+WHERE
+gui_element.e_id = 'featureInfo1' AND
+gui_element.fkey_gui_id
+NOT IN (SELECT fkey_gui_id FROM gui_element_vars WHERE fkey_e_id = 'featureInfo1' AND var_name = 'featureInfoPopupPosition');
+