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

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2010-10-28 07:29:49 -0700 (Thu, 28 Oct 2010)
New Revision: 7074

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql
Log:
changed SQL UPDATE: fill new column gui_layer_title with layer_titles from layer, where gui_layer_title is empty

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql	2010-10-28 12:12:35 UTC (rev 7073)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql	2010-10-28 14:29:49 UTC (rev 7074)
@@ -2724,8 +2724,10 @@
 
 -- add new column gui_layer_title
 alter table gui_layer add column gui_layer_title character varying(255) NOT NULL DEFAULT ''::character varying;
--- fill gui_layer_title with layer_titles from layer
-UPDATE gui_layer SET gui_layer_title = (SELECT layer_title FROM layer WHERE gui_layer.fkey_layer_id = layer.layer_id);
+-- fill new column gui_layer_title with layer_titles from layer, where gui_layer_title is ''
+Update gui_layer set 
+gui_layer_title = l.layer_title from layer l where
+gui_layer_title = '' AND fkey_layer_id = l.layer_id;
 
 --adoptions for managing georss/kml urls and data in the mapbender database
 -- Table: datalink