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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2013-08-27 23:37:01 -0700 (Tue, 27 Aug 2013)
New Revision: 8696

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.3_to_2.7.4_pgsql_UTF-8.sql
Log:
Adopt information model for further inspire demands

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.3_to_2.7.4_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.3_to_2.7.4_pgsql_UTF-8.sql	2013-08-26 14:20:08 UTC (rev 8695)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.3_to_2.7.4_pgsql_UTF-8.sql	2013-08-28 06:37:01 UTC (rev 8696)
@@ -551,4 +551,49 @@
   OWNER TO postgres;
 
 
+--exchange wms_max_imagesize with x and y components - see wms 1.3 spec
+-- Column: wms_max_imagesize_x
 
+-- ALTER TABLE wms DROP COLUMN wms_max_imagesize_x;
+
+ALTER TABLE wms ADD COLUMN wms_max_imagesize_x integer;
+ALTER TABLE wms ALTER COLUMN wms_max_imagesize_x SET DEFAULT 1000;
+
+-- Column: wms_max_imagesize_y
+
+-- ALTER TABLE wms DROP COLUMN wms_max_imagesize_y;
+
+ALTER TABLE wms ADD COLUMN wms_max_imagesize_y integer;
+ALTER TABLE wms ALTER COLUMN wms_max_imagesize_y SET DEFAULT 1000;
+
+-- the old values have to be transfered to the new ones - if wished
+-- the logic will get the lowest value from x and y for the wms_max_imagesize!
+
+
+-- mb_metadata
+-- New column: bounding_geom for generating inspire dls more accurate
+
+-- ALTER TABLE mb_metadata DROP COLUMN bounding_geom;
+
+ALTER TABLE mb_metadata ADD COLUMN bounding_geom geometry;
+
+
+--inspire monitoring and reporting
+
+-- ALTER TABLE mb_metadata DROP COLUMN inspire_whole_area;
+
+ALTER TABLE mb_metadata ADD COLUMN inspire_whole_area bigint;
+
+-- ALTER TABLE mb_metadata DROP COLUMN inspire_actual_coverage;
+
+ALTER TABLE mb_metadata ADD COLUMN inspire_actual_coverage bigint; 
+
+-- ALTER TABLE wms DROP COLUMN inspire_daily_requests;
+
+ALTER TABLE wms ADD COLUMN inspire_daily_requests double precision;
+
+-- ALTER TABLE wfs DROP COLUMN inspire_daily_requests;
+
+ALTER TABLE wfs ADD COLUMN inspire_daily_requests double precision;
+
+