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

svn_mapbender at osgeo.org svn_mapbender at osgeo.org
Fri Jun 10 09:49:03 EDT 2011


Author: astrid_emde
Date: 2011-06-10 06:49:03 -0700 (Fri, 10 Jun 2011)
New Revision: 7854

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql
Log:
delete new entries from gui_treegde from old configuration

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql	2011-06-10 13:48:24 UTC (rev 7853)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql	2011-06-10 13:49:03 UTC (rev 7854)
@@ -33,3 +33,5 @@
 UPDATE gui_element set e_width = 0, e_height = 0
 where fkey_gui_id = 'admin2_de' and e_id ='body' ;
 
+-- delete old entries from old treeConfiguration
+DELETE FROM gui_treegde WHERE my_layer_title ILIKE 'new' AND wms_id IS NULL;



More information about the Mapbender_commits mailing list