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

[svn_mapbender at osgeo.org]

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');