Rem drv: <migrate type="schema_upgrade" version="10.2.0.0" pos="storage/storage_schema_upgrade.sql+"/> 
Rem
Rem $Header: webapp_schema_upgrade.sql 04-aug-2005.17:56:20 mfidanbo Exp $
Rem
Rem webapp_schema_upgrade.sql
Rem
Rem Copyright (c) 2004, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      webapp_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    chyu        07/25/05 - modifying the upgrade header 
Rem    chyu        07/18/05 - modify the version number in header 
Rem    mfidanbo    08/04/05 - dont drop mgmt_bcn_target_txn until we are done 
Rem                           with webapp upgrade 
Rem    mfidanbo    02/17/05 - add types and upgrade_pkg 
Rem    ktlaw       01/13/05 - add repmgr header 
Rem    rmarripa    12/24/04 - rmarripa_webapp_upgrade_changes
Rem    rmarripa    12/16/04 - Created
Rem

---------------------------------------------------------------------
--  Drop Types
---------------------------------------------------------------------

---------------------------------------------------------------------
--  Create Types
---------------------------------------------------------------------

---------------------------------------------------------------------
--  Drop Table Constraints 
---------------------------------------------------------------------


---------------------------------------------------------------------
--  Drop Tables 
---------------------------------------------------------------------
DROP TABLE MGMT_BCN_TARGET_LOCK;

---------------------------------------------------------------------
--  Create/Alter Tables 
---------------------------------------------------------------------
ALTER TABLE MGMT_BCN_TARGET 
  ADD (IS_LOCAL CHAR(1) DEFAULT 'N' NOT NULL );

@&EM_SQL_ROOT/core/v102010/webapp/webapp_upgrade_types.sql