Rem drv: <migrate type="schema_upgrade" version="10.2.0.0" pos="purge/purge_schema_upgrade.sql+"/>
Rem
Rem $Header: rep_metric_schema_upgrade.sql 28-aug-2005.23:20:52 pmodi Exp $
Rem
Rem rep_metric_schema_upgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      rep_metric_schema_upgrade.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    pmodi       08/28/05 - bug:4579107 - Move index idx02 to v102020 
Rem                           and add idx01 from v102020
Rem    chyu        07/25/05 - modifying the upgrade header 
Rem    chyu        07/18/05 - adding the <migration> header 
Rem    pmodi       06/17/05 - Bug:4305824- Index on 
Rem                           mgmt_metric_dependency_details 
Rem    gan         03/01/05 - Add column 
Rem    streddy     02/08/05 - streddy_bug-4172911
Rem    streddy     02/08/05 - Created
Rem


Rem Upgrade tables

ALTER TABLE MGMT_METRIC_DEPENDENCY
ADD (
  rs_metric           NUMBER(1) DEFAULT 0,
  eval_order          NUMBER(2) DEFAULT 0,
  eval_func           VARCHAR2(256) DEFAULT NULL,
  event_metric        NUMBER   DEFAULT 1,
  min_dep_interval    NUMBER   DEFAULT 5
);

ALTER TABLE MGMT_METRIC_DEPENDENCY_DETAILS
ADD (
  dep_coll_name       VARCHAR2(64)
);

Rem
Rem Indices for MGMT_METRIC_DEPENDENCY
Rem
CREATE INDEX MGMT_METRIC_DEPENDENCY_IDX_01 ON
   MGMT_METRIC_DEPENDENCY (TARGET_GUID);