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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2017-03-30 02:22:05 -0700 (Thu, 30 Mar 2017)
New Revision: 9725

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
fix - drop views before recreate them again

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-03-30 09:02:11 UTC (rev 9724)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2017-03-30 09:22:05 UTC (rev 9725)
@@ -131,7 +131,7 @@
 --new option to search for datasets in the internal mb_metadata table 
 -- View: search_dataset_view
 
--- DROP VIEW search_dataset_view;
+DROP VIEW search_dataset_view;
 
 CREATE OR REPLACE VIEW search_dataset_view AS 
  SELECT dataset_dep.fkey_mb_user_id AS user_id, dataset_dep.dataset_id, dataset_dep.srs AS dataset_srs, dataset_dep.title, dataset_dep.abstract AS dataset_abstract, f_collect_searchtext_dataset(dataset_dep.dataset_id) AS searchtext, dataset_dep.dataset_timestamp, dataset_dep.department, dataset_dep.mb_group_name, dataset_dep.mb_group_title, dataset_dep.mb_group_country, 0 AS load_count, dataset_dep.mb_group_stateorprovince, f_collect_inspire_cat_dataset(dataset_dep.dataset_id) AS md_inspire_cats, f_collect_custom_cat_dataset(dataset_dep.dataset_id) AS md_custom_cats, f_collect_topic_cat_dataset(dataset_dep.dataset_id) AS md_topic_cats, dataset_dep.bbox, dataset_dep.mb_group_logo_path
@@ -180,7 +180,7 @@
   OWNER TO postgres;
 
 -- View: wms_list_view
--- DROP VIEW wms_list_view;
+DROP VIEW wms_list_view;
 
 CREATE OR REPLACE VIEW wms_list_view AS 
  
@@ -1537,7 +1537,7 @@
 --Alter view to react on searchable = true field
 -- View: search_dataset_view
 
--- DROP VIEW search_dataset_view;
+DROP VIEW search_dataset_view;
 
 CREATE OR REPLACE VIEW search_dataset_view AS 
  SELECT DISTINCT ON (datasets.metadata_id) datasets.user_id, datasets.dataset_id, datasets.metadata_id, datasets.dataset_srs, datasets.title, datasets.dataset_abstract, datasets.accessconstraints, datasets.isopen, datasets.termsofuse, datasets.searchtext, datasets.dataset_timestamp, datasets.department, datasets.mb_group_name, datasets.mb_group_title, datasets.mb_group_country, datasets.load_count, datasets.mb_group_stateorprovince, datasets.md_inspire_cats, datasets.md_custom_cats, datasets.md_topic_cats, datasets.the_geom, datasets.bbox, datasets.preview_url, datasets.fileidentifier, datasets.coupled_resources, datasets.mb_group_logo_path, datasets.timebegin, datasets.timeend
@@ -1606,7 +1606,7 @@
 -- solve multiple results for wfs_conf - fixing bug!
 -- View: search_wfs_view
 
--- DROP VIEW search_wfs_view;
+DROP VIEW search_wfs_view;
 
 CREATE OR REPLACE VIEW search_wfs_view AS 
  SELECT wfs_without_geom.wfs_id, wfs_without_geom.wfs_title, wfs_without_geom.wfs_abstract, wfs_without_geom.administrativearea, wfs_without_geom.country, wfs_without_geom.accessconstraints, wfs_without_geom.termsofuse, wfs_without_geom.isopen, wfs_without_geom.wfs_owner, wfs_without_geom.featuretype_id, wfs_without_geom.featuretype_srs, wfs_without_geom.featuretype_title, wfs_without_geom.featuretype_abstract, wfs_without_geom.searchtext, wfs_without_geom.element_type, wfs_without_geom.wfs_conf_id, wfs_without_geom.wfs_conf_abstract, wfs_without_geom.wfs_conf_description, wfs_without_geom.modultype, wfs_without_geom.wfs_timestamp, wfs_without_geom.department, wfs_without_geom.mb_group_name, wfs_without_geom.mb_group_logo_path, wfs_without_geom.wfs_network_access, wfs_without_geom.wfs_pricevolume, wfs_without_geom.wfs_proxylog, wfs_without_geom.featuretype_latlon_bbox, wfs_without_geom.featuretype_latlon_array, geometryfromtext(((((((((((((((((((('POLYGON(('::text || wfs_without_geo
 m.featuretype_latlon_array[1]) || ' '::text) || wfs_without_geom.featuretype_latlon_array[2]) || ','::text) || wfs_without_geom.featuretype_latlon_array[1]) || ' '::text) || wfs_without_geom.featuretype_latlon_array[4]) || ','::text) || wfs_without_geom.featuretype_latlon_array[3]) || ' '::text) || wfs_without_geom.featuretype_latlon_array[4]) || ','::text) || wfs_without_geom.featuretype_latlon_array[3]) || ' '::text) || wfs_without_geom.featuretype_latlon_array[2]) || ','::text) || wfs_without_geom.featuretype_latlon_array[1]) || ' '::text) || wfs_without_geom.featuretype_latlon_array[2]) || '))'::text, 4326) AS the_geom, (((((wfs_without_geom.featuretype_latlon_array[1] || ','::text) || wfs_without_geom.featuretype_latlon_array[2]) || ','::text) || wfs_without_geom.featuretype_latlon_array[3]) || ','::text) || wfs_without_geom.featuretype_latlon_array[4] AS bbox
@@ -1629,7 +1629,7 @@
 
 -- View: groups_for_publishing
 
--- DROP VIEW groups_for_publishing;
+DROP VIEW groups_for_publishing;
 
 CREATE OR REPLACE VIEW groups_for_publishing AS 
 
@@ -1646,7 +1646,7 @@
 
 -- View: users_for_publishing
 
--- DROP VIEW users_for_publishing;
+DROP VIEW users_for_publishing;
 
 CREATE OR REPLACE VIEW users_for_publishing AS 
 
@@ -1792,9 +1792,9 @@
 ALTER TABLE groups_for_publishing
   OWNER TO postgres;
 
-View: users_for_publishing
+--View: users_for_publishing
 
--- DROP VIEW users_for_publishing;
+DROP VIEW users_for_publishing;
 
 CREATE OR REPLACE VIEW users_for_publishing AS 
  SELECT DISTINCT f.fkey_mb_user_id, f.fkey_mb_group_id AS primary_group_id