Rem drv: <migrate type="schema_upgrade" version="10.2.0.1" pos="severity/severity_schema_upgrade.sql+"/>
Rem
Rem $Header: rep_metric_schema_upgrade.sql 28-aug-2005.23:22:41 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 idx01 to v102010 
Rem                           and add idx02 from v102010
Rem    gan         08/18/05 - add more column 
Rem    gan         08/15/05 - add col opt_code 
Rem    chyu        07/25/05 - modifying the upgrade header 
Rem    chyu        07/18/05 - adding the upgrade 
Rem                           header
Rem    pmodi       07/14/05 - pmodi_bug-4486836
Rem    pmodi       07/12/05 - Created. Bug:4487462
Rem


Rem
Rem Creating Index on edep_target_guid
Rem

CREATE INDEX MGMT_METRIC_DEP_DETAILS_IDX_02 ON
  MGMT_METRIC_DEPENDENCY_DETAILS (EDEP_TARGET_GUID);

REM add repo_metric_only, opt_code to mgmt_metric_dependency
Alter table mgmt_metric_dependency ADD (opt_code NUMBER DEFAULT 0,
                                        repo_metric_only NUMBER DEFAULT 0
                                        );

REM add opt_code to mgmt_metric_dependency_def
Alter table mgmt_metric_dependency_def ADD (opt_code NUMBER DEFAULT 0);