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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2017-03-30 01:50:56 -0700 (Thu, 30 Mar 2017)
New Revision: 9723

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
style fixing from karlo

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 08:47:55 UTC (rev 9722)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2017-03-30 08:50:56 UTC (rev 9723)
@@ -1588,8 +1588,8 @@
 fieldset {margin-top: 10px;}
 .dataTables_wrapper{min-height:unset;}
 .metadata_span {padding-right:0;vertical-align: top;}
-.help-dialog {cursor: pointer;}
-.metadata_img, .help-dialog, .original-metadata-wms {width: 25px;height: 25px;vertical-align: middle;}
+.help-dialog {cursor: pointer;}, . original-metadata-wms, .original-metadata-layer, .clickable, .original-metadata-wfs, .original-metadata-featuretype
+.metadata_img, .help-dialog, .original-metadata-wms {width: 25px;height: 25px;vertical-align: middle;}, .original-metadata-layer, .original-metadata-wfs, .original-metadata-featuretype
 .metadata_selectbox {height:66px;width:250px;vertical-align:top;}
 .label_classification {width: 150px;height: 40px;float: left;}
 div#choose {float: left;width: 30%;height:100%;position:relative;overflow:hidden;}
@@ -1875,6 +1875,10 @@
 ALTER TABLE search_wfs_view
   OWNER TO postgres;
 
+-- 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
    FROM ( SELECT dataset_dep.fkey_mb_user_id AS user_id, dataset_dep.dataset_id, dataset_dep.dataset_id AS metadata_id, dataset_dep.srs AS dataset_srs, dataset_dep.title, dataset_dep.abstract AS dataset_abstract, dataset_dep.accessconstraints, dataset_dep.isopen, dataset_dep.termsofuse, 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,