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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2017-05-10 04:59:57 -0700 (Wed, 10 May 2017)
New Revision: 9736

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
Possibility to define that urls should be exchanged in ows secured getfeatureinfo results for each wms. New: defaults to true, but can be overwritten. Global excludes are defined in conf file as before.

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2017-05-09 12:41:59 UTC (rev 9735)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2017-05-10 11:59:57 UTC (rev 9736)
@@ -1930,3 +1930,14 @@
 ALTER TABLE search_wfs_view
   OWNER TO postgres;
 
+-- Column: wms_proxy_exchange_external_urls
+
+-- ALTER TABLE wms DROP COLUMN wms_proxy_exchange_external_urls;
+
+ALTER TABLE wms ADD COLUMN wms_proxy_exchange_external_urls integer;
+ALTER TABLE wms ALTER COLUMN wms_proxy_exchange_external_urls SET DEFAULT 1;
+
+UPDATE wms SET wms_proxy_exchange_external_urls = 1 WHERE wms_proxy_exchange_external_urls IS NULL;
+
+
+