Rem drv: <migrate type="schema_upgrade" version="11.2.0.0"/>
Rem
Rem $Header: emdb/source/oracle/sysman/emdrep/sql/db/11.2.0.0/dg/dg_schema_upgrade.sql /st_emdbsa_11.2/1 2009/01/27 16:16:54 mmootha Exp $
Rem
Rem dg_schema_upgrade.sql
Rem
Rem Copyright (c) 2006, 2008, Oracle and/or its affiliates.
Rem All rights reserved. 
Rem
Rem    NAME
Rem      dg_schema_upgrade.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem ***********************IMPORTANT NOTE*********************
Rem **  file is hould contain only schema that requires oms **
Rem **  to be shutdown, othersie update                     **
Rem **  dg_schema_upgrade.sql                           **
Rem ***********************IMPORTANT NOTE*********************
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    ngade       08/04/08 - Add only delta here.
Rem    rimmidi     08/02/08 - 
Rem    ajdsouza    09/30/07 - moved schema creation sql to dg_pre_upgrade_schema
Rem    sjconnol    07/24/06 - Move content here from latest; add cols
Rem    sjconnol    08/14/06 - Creation
Rem

-- add new columns
ALTER TABLE MGMT_HA_DG_TARGET_SUMMARY ADD (
    SOURCE_TYPE varchar2(2),
    ROW_TYPE varchar2(2),
    USING_BROKER varchar2(4),
    ACTIVE_STBY varchar2(4),
    DB_ID NUMBER,
    PRMY_DB_ID NUMBER,
    STBY_LIST varchar2(1024)
);