Rem drv: <migrate type="schema_downgrade" version="10.1.0.4"/>
Rem
Rem $Header: ecm_schema_downgrade.sql 30-aug-2005.00:52:36 mningomb Exp $
Rem
Rem ecm_schema_downgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      ecm_schema_downgrade.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    mningomb    08/28/05 - 
Rem    chyu        07/19/05 - modifying the new rep manager header 
Rem    pdasika     07/11/05 - Dropping types created for bug 4407016 
Rem    abhalla     07/07/05 - Drop new table MGMT_CPF_METRIC_SOURCE of 10.2 
Rem    asaraswa    03/04/05 - dropping mgmt_inv_summary table 
Rem    apbharga    02/23/05 - apbharga_ecm_downgrade
Rem    apbharga    02/23/05 - Created
Rem

Rem Defines for column sizes
DEFINE DISPLAY_NAME_LENGTH        = 128
DEFINE TARGET_NAME_LENGTH         = 256

Rem Downgrading MGMT_BUG_ADV_HOME_PATCH
Rem In 10.2 we added a new column BUG_NUMBER as part of the Primary Key
Rem Since the dependent views, procs and data will be recreated, I am going to simply drop the
Rem table and create the old table

DROP TABLE MGMT_BUG_ADV_HOME_PATCH;
CREATE TABLE MGMT_BUG_ADV_HOME_PATCH
(
  ADVISORY_NAME VARCHAR2(&DISPLAY_NAME_LENGTH) NOT NULL,
  HOST_NAME VARCHAR2(&TARGET_NAME_LENGTH) NOT NULL,
  HOME_LOCATION VARCHAR2( 128 ) NOT NULL,
  PATCH_GUID RAW(16) NOT NULL,
  PREREQ_RELEASE VARCHAR2(256),
  HOME_LOCATION_DISPLAY VARCHAR2(256),
  TARGET_GUID RAW(16),
  CONSTRAINT MBAHP_PK PRIMARY KEY ( ADVISORY_NAME, HOST_NAME, HOME_LOCATION, PATCH_GUID )
) MONITORING;

DROP TABLE MGMT_INV_SUMMARY;

DROP TYPE VARCHAR_TABLE; 

DROP TYPE HOME_CREDS_REC_TYPE;

DROP TYPE HOME_CRED_ARRAY; 

DROP TYPE DEST_PLATFORM_REC_TYPE;

DROP TYPE DEST_PLATFORM_ARRAY;