[Mapbender-commits] r5644 -
trunk/mapbender/resources/db/pgsql/UTF-8/update
svn_mapbender at osgeo.org
svn_mapbender at osgeo.org
Wed Feb 24 11:56:51 EST 2010
Author: astrid_emde
Date: 2010-02-24 11:56:50 -0500 (Wed, 24 Feb 2010)
New Revision: 5644
Modified:
trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql
Log:
please add newline in SQL after about 80 characters
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-02-24 16:23:15 UTC (rev 5643)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql 2010-02-24 16:56:50 UTC (rev 5644)
@@ -1315,7 +1315,11 @@
FROM gui_element WHERE
( gui_element.e_id = 'resultList' AND
gui_element.fkey_gui_id NOT IN ( SELECT fkey_gui_id FROM gui_element WHERE e_id = 'resultList_Popup')
- )
+ ) ;
-- deactivate slippy map by default
-INSERT INTO gui_element_vars (fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) SELECT DISTINCT fkey_gui_id, 'mapframe1' AS fkey_e_id, 'slippy' AS var_name, '0' AS var_value, '1 = Activates an animated, pseudo slippy map' AS context, 'var' AS var_type FROM gui_element WHERE e_id = 'mapframe1' AND fkey_gui_id NOT IN (SELECT fkey_gui_id FROM gui_element_vars WHERE var_name = 'slippy');
+INSERT INTO gui_element_vars (fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
+SELECT DISTINCT fkey_gui_id, 'mapframe1' AS fkey_e_id, 'slippy' AS var_name, '0' AS var_value,
+'1 = Activates an animated, pseudo slippy map' AS context, 'var' AS var_type FROM gui_element
+WHERE e_id = 'mapframe1' AND fkey_gui_id NOT IN (SELECT fkey_gui_id FROM gui_element_vars
+WHERE var_name = 'slippy');
More information about the Mapbender_commits
mailing list