[Mapbender-commits] r7489 - branches/2.7/resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2011-01-28 08:39:26 -0800 (Fri, 28 Jan 2011)
New Revision: 7489

Modified:
   branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql
Log:
Grant options deleted, drop view 

Modified: branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql
===================================================================
--- branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql	2011-01-28 16:38:39 UTC (rev 7488)
+++ branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql	2011-01-28 16:39:26 UTC (rev 7489)
@@ -2,13 +2,12 @@
 --bugfix for template_openlayers #759
 --
 UPDATE gui_element set e_pos='2' WHERE e_id='jq_ui_position';
+
 --
 --new function to get the load_count of wmc which are stored in the mapbender database
 --
 -- Function: f_wmc_load_count(integer)
 
--- DROP FUNCTION f_wmc_load_count(integer);
-
 CREATE OR REPLACE FUNCTION f_wmc_load_count(integer)
   RETURNS integer AS
 $BODY$
@@ -25,13 +24,14 @@
 $BODY$
   LANGUAGE 'plpgsql' VOLATILE
   COST 100;
-ALTER FUNCTION f_wmc_load_count(integer) OWNER TO postgres;
+
+
 --
 -- change view for search wmc to include the load_count
 --
 -- View: search_wmc_view
 
--- DROP VIEW search_wmc_view;
+DROP VIEW search_wmc_view;
 
 CREATE OR REPLACE VIEW search_wmc_view AS 
  SELECT wmc_dep.fkey_user_id AS user_id, wmc_dep.wmc_id, wmc_dep.srs AS wmc_srs, wmc_dep.wmc_title, wmc_dep.abstract AS wmc_abstract, f_collect_searchtext_wmc(wmc_dep.wmc_id) AS searchtext, wmc_dep.wmc_timestamp, wmc_dep.department, wmc_dep.mb_group_name, wmc_dep.mb_group_title, wmc_dep.mb_group_country, wmc_dep.wmc_serial_id, f_wmc_load_count(wmc_dep.wmc_serial_id) as load_count, wmc_dep.mb_group_stateorprovince, f_collect_inspire_cat_wmc(wmc_dep.wmc_serial_id) AS md_inspire_cats, f_collect_custom_cat_wmc(wmc_dep.wmc_serial_id) AS md_custom_cats, f_collect_topic_cat_wmc(wmc_dep.wmc_id) AS md_topic_cats, transform(geometryfromtext(((((((((((((((((((('POLYGON(('::text || wmc_dep.minx::text) || ' '::text) || wmc_dep.miny::text) || ','::text) || wmc_dep.minx::text) || ' '::text) || wmc_dep.maxy::text) || ','::text) || wmc_dep.maxx::text) || ' '::text) || wmc_dep.maxy::text) || ','::text) || wmc_dep.maxx::text) || ' '::text) || wmc_dep.miny::text) || ','::text) || wmc_dep.minx::
 text) || ' '::text) || wmc_dep.miny::text) || '))'::text, regexp_replace(upper(wmc_dep.srs::text), 'EPSG:'::text, ''::text)::integer), 4326) AS the_geom, (((((wmc_dep.minx::text || ','::text) || wmc_dep.miny::text) || ','::text) || wmc_dep.maxx::text) || ','::text) || wmc_dep.maxy::text AS bbox, wmc_dep.mb_group_logo_path
@@ -43,7 +43,6 @@
   WHERE wmc_dep.wmc_public = 1
   ORDER BY wmc_dep.wmc_id;
 
-ALTER TABLE search_wmc_view OWNER TO postgres;
 --
 -- Bugfix for normalize searchtext of wmc docs
 --
@@ -75,7 +74,6 @@
 $BODY$
   LANGUAGE 'plpgsql' VOLATILE
   COST 100;
-ALTER FUNCTION f_collect_searchtext_wmc(integer) OWNER TO postgres;
 
 --Bugfix in integral monitoring table
 
@@ -118,7 +116,6 @@
     END;
 $BODY$
   LANGUAGE 'plpgsql' VOLATILE;
-ALTER FUNCTION mb_monitor_after() OWNER TO postgres;
 
 --new columns with uuids for resources wms, layer, wfs, featuretype - is needed to generate konsistent metadatasets
 --you need a postgres >= 8.3 cause the new datatype uuid is used!