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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2017-02-22 08:39:30 -0800 (Wed, 22 Feb 2017)
New Revision: 9699

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
Fix of new search method for wfs objects

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-02-22 14:08:55 UTC (rev 9698)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2017-02-22 16:39:30 UTC (rev 9699)
@@ -1719,9 +1719,9 @@
 
 -- View: search_wfs_view_2
 
--- DROP VIEW search_wfs_view_2;
+DROP VIEW search_wfs_view;
 
-CREATE OR REPLACE VIEW search_wfs_view_2 AS 
+CREATE OR REPLACE VIEW search_wfs_view AS 
 
 SELECT wfs_new.*, isopen FROM (SELECT wfs_table.*, wfs_termsofuse.fkey_termsofuse_id FROM
 (SELECT wfs_info.*, mb_group.mb_group_id as department, mb_group.mb_group_name, mb_group_logo_path  FROM (SELECT featuretype.*, geometryfromtext(((((((((((((((((((('POLYGON(('::text || featuretype.featuretype_latlon_array[1]) || ' '::text) || featuretype.featuretype_latlon_array[2]) || ','::text) || featuretype.featuretype_latlon_array[1]) || ' '::text) || featuretype.featuretype_latlon_array[4]) || ','::text) || featuretype.featuretype_latlon_array[3]) || ' '::text) || featuretype.featuretype_latlon_array[4]) || ','::text) || featuretype.featuretype_latlon_array[3]) || ' '::text) || featuretype.featuretype_latlon_array[2]) || ','::text) || featuretype.featuretype_latlon_array[1]) || ' '::text) || featuretype.featuretype_latlon_array[2]) || '))'::text, 4326) AS the_geom, (((((featuretype.featuretype_latlon_array[1] || ','::text) || featuretype.featuretype_latlon_array[2]) || ','::text) || featuretype.featuretype_latlon_array[3]) || ','::text) || featuretype.featuretype_latlon_array[
 4] AS bbox, f_collect_searchtext_wfs(wfs_id, featuretype.featuretype_id) AS searchtext, wfs_conf_id, wfs_conf_abstract, wfs_conf_description, wfs_conf_type as modultype FROM 
@@ -1732,7 +1732,7 @@
                     ELSE string_to_array(wfs_featuretype.featuretype_latlon_bbox::text, ','::text)
                 END AS featuretype_latlon_array, wfs.*  FROM 
 
-(SELECT DISTINCT wfs_id, wfs_title, wfs_abstract, wfs_timestamp_create, wfs_network_access, wfs_pricevolume, wfs_proxylog, wfs_owner, country, administrativearea, accessconstraints, fkey_mb_group_id, f_get_responsible_organization(wfs_owner, COALESCE(fkey_mb_group_id, 0)) AS orga_id
+(SELECT DISTINCT wfs_id, wfs_title, wfs_abstract, wfs_timestamp_create, wfs_timestamp, wfs_network_access, wfs_pricevolume, wfs_proxylog, wfs_owner, country, administrativearea, accessconstraints, fkey_mb_group_id, f_get_responsible_organization(wfs_owner, COALESCE(fkey_mb_group_id, 0)) AS orga_id
   
 FROM wfs WHERE wfs_owner IN (SELECT fkey_mb_user_id FROM users_for_publishing) ORDER BY wfs_id) AS wfs 
 
@@ -1742,5 +1742,5 @@
 
  WHERE element_type IS NOT NULL;
 
-ALTER TABLE search_wfs_view_2
+ALTER TABLE search_wfs_view
   OWNER TO postgres;