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

[svn_mapbender at osgeo.org]

Author: christoph
Date: 2010-12-16 04:55:13 -0800 (Thu, 16 Dec 2010)
New Revision: 7319

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql
Log:
delete obsolete wms

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-12-16 11:40:51 UTC (rev 7318)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql	2010-12-16 12:55:13 UTC (rev 7319)
@@ -3505,3 +3505,28 @@
 
 DELETE FROM gui_element where fkey_gui_id = 'admin1' AND e_id = 'CreateTreeGDE';
 
+
+--
+-- delete obsolete wms
+--
+Delete from wms where wms_id = 625 AND wms_title LIKE 'DM Solutions';
+Delete from wms where wms_id = 836 AND wms_title LIKE 'NDOP (OGCConnector v1.1)';
+Delete from wms where wms_id = 842 AND wms_title LIKE 'Tsunami_Diasaster_Data';
+Delete from wms where wms_id = 882 AND wms_title LIKE 'Wahlen';
+Delete from wms where wms_id = 824 AND wms_title LIKE 'Image Web Server';
+Delete from wms where wms_id = 903 AND wms_title LIKE 'DNM 25';
+Delete from wms where wms_id = 828 AND wms_title LIKE 'IDERIOJA Gobierno de La Rioja OGC WMS';
+Delete from wms where wms_id = 328 AND wms_title LIKE 'NWSIB-online';
+Delete from wms where wms_id = 671 AND wms_title LIKE 'Wasserschutzgebiete NRW';
+Delete from wms where wms_id = 785 AND wms_title LIKE 'WMS Map Server';
+Delete from wms where wms_id = 786 AND wms_title LIKE 'Luftbilder';
+Delete from wms where wms_id = 615 AND wms_title LIKE 'ESRI Inc. Map Server';
+Delete from wms where wms_id = 614 AND wms_title LIKE 'ESRI Inc. Map Server';
+Delete from wms where wms_id = 645 AND wms_title LIKE 'Multi-Hazard Mapping Initiative WMS Map Server (HDM)';
+Delete from wms where wms_id = 792 AND wms_title LIKE 'WMS-Thueringen';
+Delete from wms where wms_id = 634 AND wms_title LIKE 'Location mapserver';
+Delete from wms where wms_id = 840 AND wms_title LIKE 'Intergraph World Map';
+Delete from wms where wms_id = 883 AND wms_title LIKE 'SICAD/SD-IMS V5.1-Luftbilder';
+Delete from wms where wms_id = 902 AND wms_title LIKE 'DNM 100/2';
+Delete from wms where wms_id = 843 AND wms_title LIKE 'WMS Map Server';
+Delete from wms where wms_id = 904 AND wms_title LIKE 'DNM 250/2';
\ No newline at end of file