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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2017-01-23 09:09:56 -0800 (Mon, 23 Jan 2017)
New Revision: 9666

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
Further bugfix cause wrong schema was choosed

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-23 16:10:49 UTC (rev 9665)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2017-01-23 17:09:56 UTC (rev 9666)
@@ -1293,16 +1293,16 @@
 
 
 -- 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 search_wfs_view;
+DROP VIEW wfs_service_metadata_new;
+DROP VIEW wfs_service_metadata;
 
 -- Ä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  
-CREATE OR REPLACE VIEW mapbender.search_wfs_view AS 
+CREATE OR REPLACE VIEW search_wfs_view AS 
  SELECT wfs_without_geom.wfs_id,
     wfs_without_geom.wfs_title,
     wfs_without_geom.wfs_abstract,
@@ -1424,7 +1424,7 @@
   OWNER TO postgres;
 
 
-CREATE OR REPLACE VIEW mapbender.wfs_service_metadata_new AS 
+CREATE OR REPLACE VIEW wfs_service_metadata_new AS 
  SELECT wfs_dep.wfs_id,
     wfs_dep.wfs_title,
     wfs_dep.wfs_abstract,
@@ -1474,7 +1474,7 @@
 ALTER TABLE wfs_service_metadata_new
   OWNER TO postgres;
 
-CREATE OR REPLACE VIEW mapbender.wfs_service_metadata AS 
+CREATE OR REPLACE VIEW wfs_service_metadata AS 
  SELECT wfs.wfs_id,
     wfs.wfs_version,
     wfs.wfs_name,