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

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2011-02-22 15:59:00 -0800 (Tue, 22 Feb 2011)
New Revision: 7637

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql
Log:
schema mapbender. deleted in function mb_monitor_after(), new column cap_diff in mb_monitor - typo error - and mb_wms_availability

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql	2011-02-22 18:30:00 UTC (rev 7636)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql	2011-02-22 23:59:00 UTC (rev 7637)
@@ -79,7 +79,7 @@
 
 -- Function: mb_monitor_after()
 
--- DROP FUNCTION mb_monitor_after();
+--DROP FUNCTION mb_monitor_after();
 
 CREATE OR REPLACE FUNCTION mb_monitor_after()
   RETURNS "trigger" AS
@@ -100,7 +100,7 @@
       availability_new := round(cast(((select availability from mb_wms_availability where fkey_wms_id=NEW.fkey_wms_id)*count_monitors)/(count_monitors+1) as numeric),2);
      END IF;
 
-      UPDATE mapbender.mb_wms_availability SET average_resp_time=average_res_cap,last_status=NEW.status, availability=availability_new, image=NEW.image, status_comment=NEW.status_comment,upload_url=NEW.upload_url,map_url=NEW.map_url, cap_diff=NEW.cap_diff WHERE mb_wms_availability.fkey_wms_id=NEW.fkey_wms_id;
+      UPDATE mb_wms_availability SET average_resp_time=average_res_cap,last_status=NEW.status, availability=availability_new, image=NEW.image, status_comment=NEW.status_comment,upload_url=NEW.upload_url,map_url=NEW.map_url, cap_diff=NEW.cap_diff WHERE mb_wms_availability.fkey_wms_id=NEW.fkey_wms_id;
       RETURN NEW;
      END IF;
      IF TG_OP = 'INSERT' THEN
@@ -1665,3 +1665,10 @@
 gui_layer_maxscale,gui_layer_priority,gui_layer_style,gui_layer_wfs_featuretype,gui_layer_title
  FROM gui_layer WHERE fkey_gui_id = 'gui1' AND gui_layer_wms_id = 893);
 
+--
+-- monitoring - wrong column name fixed, column added to mb_wms_availability 
+--
+ALTER TABLE mb_monitor ADD COLUMN cap_diff text DEFAULT '';
+-- old column deleted 
+ALTER TABLE mb_monitor DROP COLUMN caps_diff;
+ALTER TABLE mb_wms_availability ADD COLUMN cap_diff text DEFAULT '';