Rem drv: <migrate type="schema_upgrade" version="10.2.0.1" pos="preferences_schema_upgrade.sql+"/>
Rem
Rem $Header: rca_schema_upgrade.sql 24-aug-2005.12:49:20 jriel Exp $
Rem
Rem rca_schema_upgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      rca_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    jriel       08/24/05 - correct upgrades that were not in original beta 
Rem                           schema 
Rem    chyu        07/25/05 - modifying the upgrade header 
Rem    chyu        07/18/05 - adding the upgrade header 
Rem    saramasa    07/07/05 - Fix for bug#4475697 
Rem    jriel       07/01/05 - jriel_rca_beta_upgrade
Rem    jriel       07/01/05 - upgrade RCA schema
Rem

SET ECHO ON
SET FEEDBACK 1
SET NUMWIDTH 10
SET LINESIZE 80
SET TRIMSPOOL ON
SET TAB OFF
SET PAGESIZE 100

-- table upgrades
ALTER TABLE &EM_REPOS_USER..MGMT_RCA_SUMMARY ADD 
  (  last_run_time          DATE DEFAULT NULL );

ALTER TABLE &EM_REPOS_USER..MGMT_RCA_TEST_RESULT ADD 
  (  last_coll_timestamp    DATE,
     last_test_value        VARCHAR2(256),
     result_status          NUMBER(1) );
     
CREATE TABLE MGMT_RCA_RECOVERY
     (source_guid                RAW(16)        NOT NULL,
      start_time                 DATE           NOT NULL,
      recovery_type              NUMBER(1))
   MONITORING;     
  
-- index upgrades  
CREATE INDEX MGMT_RCA_RECOV_IDX_01
 ON MGMT_RCA_RECOVERY (source_guid);