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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2017-03-30 02:34:08 -0700 (Thu, 30 Mar 2017)
New Revision: 9726

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
fix typo :-(

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:22:05 UTC (rev 9725)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2017-03-30 09:34:08 UTC (rev 9726)
@@ -1588,7 +1588,7 @@
 fieldset {margin-top: 10px;}
 .dataTables_wrapper{min-height:unset;}
 .metadata_span {padding-right:0;vertical-align: top;}
-.help-dialog, . original-metadata-wms, .original-metadata-layer, .clickable, .original-metadata-wfs, .original-metadata-featuretype {cursor: pointer;}
+.help-dialog, .original-metadata-wms, .original-metadata-layer, .clickable, .original-metadata-wfs, .original-metadata-featuretype {cursor: pointer;}
 .metadata_img, .help-dialog, .original-metadata-wms, .original-metadata-layer, .original-metadata-wfs, .original-metadata-featuretype {width: 25px;height: 25px;vertical-align: middle;}
 .metadata_selectbox {height:66px;width:250px;vertical-align:top;}
 .label_classification {width: 150px;height: 40px;float: left;}
@@ -1780,7 +1780,7 @@
 
 -- View: groups_for_publishing
 
-DROP VIEW groups_for_publishing;
+DROP VIEW groups_for_publishing CASCADE;
 
 CREATE OR REPLACE VIEW groups_for_publishing AS 
  SELECT mb_group.mb_group_id AS fkey_mb_group_id, mb_group.*
@@ -1794,7 +1794,7 @@
 
 --View: users_for_publishing
 
-DROP VIEW users_for_publishing;
+DROP VIEW users_for_publishing CASCADE;
 
 CREATE OR REPLACE VIEW users_for_publishing AS 
  SELECT DISTINCT f.fkey_mb_user_id, f.fkey_mb_group_id AS primary_group_id
@@ -1807,7 +1807,7 @@
 
 -- View: search_wms_view
 
-DROP VIEW search_wms_view;
+DROP VIEW IF EXISTS search_wms_view;
 
 CREATE OR REPLACE VIEW search_wms_view AS 
  SELECT DISTINCT ON (wms_unref.layer_id) wms_unref.wms_id, wms_unref.availability, wms_unref.status, wms_unref.wms_title, wms_unref.wms_abstract, wms_unref.stateorprovince, wms_unref.country, wms_unref.accessconstraints, wms_unref.termsofuse, wms_unref.isopen, wms_unref.wms_owner, wms_unref.layer_id, wms_unref.epsg, wms_unref.layer_title, wms_unref.layer_abstract, wms_unref.layer_name, wms_unref.layer_parent, wms_unref.layer_pos, wms_unref.layer_queryable, wms_unref.export2csw, wms_unref.load_count, wms_unref.searchtext, wms_unref.wms_timestamp, wms_unref.department, wms_unref.mb_group_name, f_collect_custom_cat_layer(wms_unref.layer_id) AS md_custom_cats, f_collect_inspire_cat_layer(wms_unref.layer_id) AS md_inspire_cats, f_collect_topic_cat_layer(wms_unref.layer_id) AS md_topic_cats, geometryfromtext(((((((((((((((((((('POLYGON(('::text || layer_epsg.minx::text) || ' '::text) || layer_epsg.miny::text) || ','::text) || layer_epsg.minx::text) || ' '::text) || layer_epsg.maxy::text) 
 || ','::text) || layer_epsg.maxx::text) || ' '::text) || layer_epsg.maxy::text) || ','::text) || layer_epsg.maxx::text) || ' '::text) || layer_epsg.miny::text) || ','::text) || layer_epsg.minx::text) || ' '::text) || layer_epsg.miny::text) || '))'::text, 4326) AS the_geom, (((((layer_epsg.minx::text || ','::text) || layer_epsg.miny::text) || ','::text) || layer_epsg.maxx::text) || ','::text) || layer_epsg.maxy::text AS bbox, wms_unref.wms_proxylog, wms_unref.wms_network_access, wms_unref.wms_pricevolume, wms_unref.mb_group_logo_path
@@ -1839,7 +1839,7 @@
 
 -- View: search_wfs_view
 
-DROP VIEW search_wfs_view;
+DROP VIEW IF EXISTS 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
@@ -1876,7 +1876,7 @@
 
 -- View: search_dataset_view
 
-DROP VIEW search_dataset_view;
+DROP VIEW IF EXISTS 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