Rem drv: <migrate type="schema_downgrade" version="10.1.0.4"/>
Rem
Rem $Header: credentials_schema_downgrade.sql 19-jul-2005.13:21:59 chyu Exp $
Rem
Rem credentials_schema_downgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      credentials_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/19/05 - modifying the new rep manager header 
Rem       skini    02/16/05 - skini_job_bo_migration
Rem       skini    02/16/05 - Upgrade CRED_SET_COL_RECORD 
Rem

DROP TYPE MGMT_CRED_SET_COL_VAL_ARRAY;
DROP TYPE MGMT_CRED_SET_COL_VAL;
DROP TYPE MGMT_CREDS_SOUTPUT;
DROP TYPE MGMT_CREDS_LOUTPUT;
DROP TYPE MGMT_COLLECTION_CRED_ARRAY;
DROP TYPE MGMT_COLLECTION_CRED_RECORD;
DROP TYPE MGMT_CRED_ARRAY;

ALTER TABLE MGMT_CREDENTIAL_TYPE_COL_VALS DROP(value_nlsid);
DROP TABLE MGMT_CREDENTIAL_SET_COL_VALS;

ALTER TABLE MGMT_TARGET_CREDENTIALS MODIFY (user_name VARCHAR2(32) DEFAULT '<SYSTEM>');

ALTER TABLE MGMT_HOST_CREDENTIALS MODIFY (user_name VARCHAR2(32) DEFAULT '<SYSTEM>');

ALTER TABLE MGMT_ENTERPRISE_CREDENTIALS MODIFY (user_name VARCHAR2(32) DEFAULT '<SYSTEM>');

ALTER TABLE MGMT_CONTAINER_CREDENTIALS MODIFY (user_name VARCHAR2(32) DEFAULT '<SYSTEM>');

ALTER TABLE MGMT_JOB_CREDENTIALS MODIFY (user_name VARCHAR2(32) DEFAULT '<SYSTEM>');


DROP TABLE MGMT_COLLECTION_CREDENTIALS;
CREATE TABLE MGMT_COLLECTION_CREDENTIALS
    (target_guid RAW(16),
     metric_guid RAW(16),
     collection_name VARCHAR2(64),
     credential_set_name VARCHAR2(32),
     credential_guid RAW(16),
     CONSTRAINT PK_MGMT_COLL_CREDS 
         PRIMARY KEY (target_guid, metric_guid, collection_name, credential_set_name)
) ORGANIZATION INDEX
  INITRANS 2
  MONITORING;

ALTER TYPE MGMT_CRED_SET_COL_RECORD DROP attribute (set_column_values) CASCADE;