[Mapbender-commits] r9649 - trunk/mapbender/resources/db/pgsql/UTF-8/update
svn_mapbender at osgeo.org
svn_mapbender at osgeo.org
Thu Jan 12 08:21:30 PST 2017
Author: armin11
Date: 2017-01-12 08:21:30 -0800 (Thu, 12 Jan 2017)
New Revision: 9649
Modified:
trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
Smal bugfix
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-01-12 15:54:57 UTC (rev 9648)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql 2017-01-12 16:21:30 UTC (rev 9649)
@@ -1293,12 +1293,12 @@
-- Loesche die abhängigen Sichten, um anschließend die Tabelle wfs_featuretype anpassen zu können
-DROP VIEW mapbender.search_wfs_view;
-DROP VIEW mapbender.wfs_service_metadata_new;
-DROP VIEW mapbender.wfs_service_metadata;
+DROP VIEW IF EXISTS mapbender.search_wfs_view;
+DROP VIEW IF EXISTS mapbender.wfs_service_metadata_new;
+DROP VIEW IF EXISTS mapbender.wfs_service_metadata;
--- Änderung Tabellenspalte auf varchar(100)
-alter table wfs_featuretype alter column featuretype_title TYPE varchar(100);
+-- Änderung Tabellenspalte auf varchar(200)
+alter table wfs_featuretype alter column featuretype_title TYPE varchar(200);
-- Erneutes anlegen der 3 zuvor gelöschten Sichten search_wfs_view,wfs_service_metadata_new,wfs_service_metadata
More information about the Mapbender_commits
mailing list