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

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2012-05-16 02:28:53 -0700 (Wed, 16 May 2012)
New Revision: 8357

Modified:
   branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql
Log:
for wms and wfs and layer_style replace wms1.ccgis.de -> wms.wheregroup.com

Modified: branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql
===================================================================
--- branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql	2012-05-16 09:11:57 UTC (rev 8356)
+++ branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.2_to_2.7.3_pgsql_UTF-8.sql	2012-05-16 09:28:53 UTC (rev 8357)
@@ -211,3 +211,18 @@
 ALTER TABLE gui_layer ALTER COLUMN gui_layer_style TYPE character varying(256);
 
 
+--
+-- replace server name wms1.ccgis.de to wms.wheregroup.com 
+--
+Update wms set wms_getcapabilities = replace(wms_getcapabilities,'wms1.ccgis.de','wms.wheregroup.com');
+Update wms set wms_getmap = replace(wms_getmap,'wms1.ccgis.de','wms.wheregroup.com');
+Update wms set wms_getfeatureinfo = replace(wms_getfeatureinfo,'wms1.ccgis.de','wms.wheregroup.com');
+Update wms set wms_getlegendurl = replace(wms_getlegendurl,'wms1.ccgis.de','wms.wheregroup.com');
+
+Update layer_style set legendurl = replace(legendurl,'wms1.ccgis.de','wms.wheregroup.com');
+
+Update wfs set wfs_getcapabilities = replace(wfs_getcapabilities,'wms1.ccgis.de','wms.wheregroup.com');
+Update wfs set wfs_describefeaturetype = replace(wfs_describefeaturetype,'wms1.ccgis.de','wms.wheregroup.com');
+Update wfs set wfs_getfeature = replace(wfs_getfeature,'wms1.ccgis.de','wms.wheregroup.com');
+Update wfs set wfs_transaction = replace(wfs_transaction,'wms1.ccgis.de','wms.wheregroup.com');
+