[Mapbender-commits] r3732 - trunk/mapbender/resources/db/update

[svn_mapbender at osgeo.org]

Author: christoph
Date: 2009-03-16 05:48:02 -0400 (Mon, 16 Mar 2009)
New Revision: 3732

Modified:
   trunk/mapbender/resources/db/update/update_2.6.sql
Log:
at the end of a line, a ; marks the end of the SQL. This is violated by CSS definition. Reformatted this SQL

Modified: trunk/mapbender/resources/db/update/update_2.6.sql
===================================================================
--- trunk/mapbender/resources/db/update/update_2.6.sql	2009-03-16 09:32:35 UTC (rev 3731)
+++ trunk/mapbender/resources/db/update/update_2.6.sql	2009-03-16 09:48:02 UTC (rev 3732)
@@ -43,30 +43,15 @@
 </select>', f_operator = 'equal' WHERE wfs_conf_element_id = 4 AND fkey_wfs_conf_id = 1;
 
 --add style class to element var text css of element digitize in gui_digitize
-UPDATE gui_element_vars SET var_value = '
-.digitizeGeometryList{
-	position:absolute;
-	top:50px;
-	left:0px;
-}
+UPDATE gui_element_vars SET var_value = 
+'
+.digitizeGeometryList {position:absolute; top:50px; left:0px;}
+.digitizeGeometryListItem {color:#000000; font-size:10px;}
+body {font-family: Arial, Helvetica, sans-serif; font-size:12px; color:#ff00ff; background-color:#ffffff; margin-top: 0px; margin-left:0px;}
+.button {height:18px; width:32px;}
+' 
+WHERE fkey_e_id = 'digitize' AND var_name = 'text css';
 
-.digitizeGeometryListItem{
-	color:#000000;
-	font-size:10px;
-}
-body{
-	font-family: Arial, Helvetica, sans-serif;
-	font-size : 12px;
-	color: #ff00ff;
-	background-color: #ffffff;
-	margin-top: 0px;
-	margin-left: 0px;
-}
-.button{
-	height: 18px;
-	width: 32px;
-}' WHERE fkey_e_id = 'digitize' AND var_name = 'text css';
-
 -- http://trac.osgeo.org/mapbender/ticket/336
 UPDATE gui_element SET e_js_file = 'wfs.php', e_target='mapframe1,overview' WHERE e_id = 'wfs';
 
@@ -495,11 +480,7 @@
 UPDATE gui_element SET e_url = 'http://www.mapbender.org/index.php/ZoomOut' where fkey_gui_id IN ('gui','gui2','gui1','gui_digitize') AND e_id= 'zoomOut1';
 
 -- new language fr, es pt
-Update gui_element_vars set var_value = 
-'de,en,bg,gr,nl,it,fr,es,pt'
-where fkey_gui_id = 'gui' AND fkey_e_id = 'switchLocale_noreload';
+Update gui_element_vars set var_value = 'de,en,bg,gr,nl,it,fr,es,pt' where fkey_gui_id = 'gui' AND fkey_e_id = 'switchLocale_noreload';
 
-
 -- customisable tree in admin1
 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) VALUES('admin1','Customize Tree',0002,1,'Create a set of nested folders that contain the applications WMS','Customize Tree','a','','href = "../php/mod_customTree.php?sessionID" target="AdminFrame"',10,975,250,20,NULL ,'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;','CUSTOMIZE TREE','a','','','','AdminFrame','');
-