[Mapbender-commits] r7853 - branches/2.7/resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2011-06-10 06:48:24 -0700 (Fri, 10 Jun 2011)
New Revision: 7853

Modified:
   branches/2.7/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: branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql
===================================================================
--- branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql	2011-06-10 10:32:49 UTC (rev 7852)
+++ branches/2.7/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)
@@ -26,3 +26,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;