[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mapbender-commits
Subject:    [Mapbender-commits] r9649 - trunk/mapbender/resources/db/pgsql/UTF-8/update
From:       svn_mapbender () osgeo ! org
Date:       2017-01-12 16:21:30
Message-ID: 20170112162130.1674039015C () trac ! osgeo ! org
[Download RAW message or body]

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  

_______________________________________________
Mapbender_commits mailing list
Mapbender_commits@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapbender_commits


[prev in list] [next in list] [prev in thread] [next in thread]