Rem drv: <migrate type="schema_upgrade" version="10.2.0.1" condition="EM_REPOS_MODE=CENTRAL"/>
Rem
Rem $Header: cm_schema_upgrade.sql 14-aug-2006.13:20:23 bmallipe Exp $
Rem
Rem cm_schema_upgrade.sql
Rem
Rem Copyright (c) 2005, 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      cm_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    bmallipe    08/14/06 - adding the CENTRAL condition because these
Rem                           upgrade scripts are specific to CENTRAL schema
Rem                           upgrade
Rem    abodge      08/23/05 - Add ANNOTATION_GUID etc. 
Rem    abodge      08/08/05 - Bug 4541977 
Rem    abodge      08/04/05 - abodge_bug-4493711
Rem    abodge      08/03/05 - Created
Rem

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

alter table MGMT_CM_BASELINE_OBJECTS
  add (ADDNL_INFO    VARCHAR2(30));

alter table MGMT_CM_BASELINE_DEPENDENTS
  add (BASE_OBJECT_COLUMN    VARCHAR2(30));

alter table MGMT_CM_COMPARISON_OBJECTS
  add ( ANNOTATION_GUID       RAW(16),
        IGNORED               NUMBER(1) DEFAULT 0,
        COMMENTS_DIFF_HASH    CHAR(32));