Rem
Rem $Header: emcore/source/oracle/sysman/emdrep/sql/core/10.2.0.4.2/credentials/credentials_tables.sql /st_emcore_10.2.0.4.2db11.2/2 2009/03/19 08:57:52 aptrived Exp $
Rem
Rem credentials_tables.sql
Rem
Rem Copyright (c) 2009, Oracle and/or its affiliates.All rights reserved. 
Rem
Rem    NAME
Rem      credentials_tables.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    aptrived    03/10/09 - Backporting Bug#5499388
Rem    aptrived    07/07/08 - Bug#5499388, Modifying
Rem                           MGMT_ARU_CREDENTIALS.ARU_USERNAME
Rem    rkpandey    02/25/09 - Created
Rem


CREATE TABLE MGMT_CONT_CREDS_TEMP
AS (SELECT * FROM MGMT_CONTAINER_CREDENTIALS);

DROP TABLE MGMT_CONTAINER_CREDENTIALS;

CREATE TABLE MGMT_CONTAINER_CREDENTIALS
AS (SELECT * FROM MGMT_CONT_CREDS_TEMP);

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

ALTER TABLE MGMT_CONTAINER_CREDENTIALS
 ADD  CONSTRAINT PK_MGMT_CONTAINER_CREDS
         PRIMARY KEY (target_guid, container_location,
                      credential_set_name, user_name);

ALTER TABLE MGMT_CONTAINER_CREDENTIALS MONITORING;

ALTER TABLE MGMT_CONTAINER_CREDENTIALS INITRANS 2;

BEGIN
  EXECUTE IMMEDIATE 'alter table mgmt_container_credentials add pdp_data VARCHAR(512) DEFAULT NULL';
EXCEPTION WHEN OTHERS THEN
  IF SQLCODE NOT IN (-1430) THEN
    -- ORA-01430 : column being added already exists in table
    RAISE;
  END IF;
END;
/


DROP TABLE MGMT_CONT_CREDS_TEMP;

ALTER TABLE MGMT_ARU_CREDENTIALS MODIFY ARU_USERNAME VARCHAR2(255);