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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2018-07-12 00:26:36 -0700 (Thu, 12 Jul 2018)
New Revision: 9922

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
Fix datamodel - allow longer urls for service operation endpoints

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	2018-07-12 07:25:49 UTC (rev 9921)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2018-07-12 07:26:36 UTC (rev 9922)
@@ -2432,3 +2432,20 @@
 
 ALTER TABLE search_wfs_view
   OWNER TO postgres;
+
+DROP VIEW IF EXISTS wfs_service_metadata;
+DROP VIEW IF EXISTS wfs_service_metadata_new;
+
+ALTER TABLE wfs ALTER COLUMN wfs_getcapabilities TYPE varchar(4096);
+ALTER TABLE wfs ALTER COLUMN wfs_describefeaturetype TYPE varchar(4096);
+ALTER TABLE wfs ALTER COLUMN wfs_getfeature TYPE varchar(4096);
+ALTER TABLE wfs ALTER COLUMN wfs_transaction TYPE varchar(4096);
+ALTER TABLE wfs ALTER COLUMN wfs_upload_url TYPE varchar(4096);
+
+ALTER TABLE wms ALTER COLUMN wms_getcapabilities TYPE varchar(4096);
+ALTER TABLE wms ALTER COLUMN wms_getmap TYPE varchar(4096);
+ALTER TABLE wms ALTER COLUMN wms_getfeatureinfo TYPE varchar(4096);
+ALTER TABLE wms ALTER COLUMN wms_getlegendurl TYPE varchar(4096);
+ALTER TABLE wms ALTER COLUMN wms_upload_url TYPE varchar(4096); 
+
+