Rem drv: <migrate type="schema_upgrade" version="10.2.0.0" pos="provision_schema_upgrade.sql+" condition="EM_REPOS_MODE=SYSAUX"/>
Rem $Header: esm_schema_upgrade_db.sql 03-apr-2007.23:16:42 jsadras Exp $
Rem
Rem esm_schema_upgrade_db.sql
Rem
Rem Copyright (c) 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      esm_schema_upgrade_db.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    jsadras     04/03/07 - Bug:5964364, create dbsa specific upgrade
Rem    jsadras     04/03/07 - Created
Rem



CREATE TABLE mgmt_esa_report (
  "ECM_SNAPSHOT_ID" RAW(16) NOT NULL CONSTRAINT "mgmt_esa_report0" 
                            REFERENCES mgmt_ecm_gen_snapshot (snapshot_guid) 
							ON DELETE CASCADE,
  "PRINCIPAL" VARCHAR2(512),
  "OBJECT_NAME" VARCHAR2(512),
  "REPORT_NAME" VARCHAR2(256),
  CONSTRAINT "MGMT_ESA_REPORT_PK" 
  PRIMARY KEY ("ECM_SNAPSHOT_ID", "PRINCIPAL", "OBJECT_NAME", "REPORT_NAME")
)
MONITORING;

ALTER TABLE esm_collection 
      ADD "VALUE2" VARCHAR2(512) DEFAULT 'NA' NOT NULL;
ALTER TABLE esm_collection 
      MODIFY "VALUE" VARCHAR2(512);