Rem
Rem $Header: security_tables.sql 16-aug-2007.08:07:28 pchebrol Exp $
Rem
Rem security_tables_upgrade.sql
Rem
Rem Copyright (c) 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      security_tables_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    pchebrol    08/16/07 - Remove header
Rem    pchebrol    06/22/07 - Backport shianand_core_5121288 from main
Rem    pchebrol    06/21/07 - Created
Rem

ALTER TABLE MGMT_SEC_INFO ADD
( 
     B64_LOCAL_CA     CLOB DEFAULT EMPTY_CLOB(),
     B64_INTERNET_CA  CLOB DEFAULT EMPTY_CLOB()
) LOB(B64_LOCAL_CA, B64_INTERNET_CA) STORE AS (TABLESPACE &EM_ECM_DEPOT_TABLESPACE)
MONITORING;

ALTER TABLE MGMT_AGENT_SEC_INFO MODIFY (AGENT_KEY VARCHAR2(128) NULL);

ALTER TABLE MGMT_AGENT_SEC_INFO ADD
(
     AGENT_HOST    VARCHAR2(256),
     AGENT_SEED    VARCHAR2(256),
     OMS_SEED      VARCHAR2(256),
     REQUEST_STATUS    VARCHAR2(30),
     AGENT_VERSION VARCHAR2(30),
     AGENT_EWALLET BLOB DEFAULT EMPTY_BLOB()
) LOB(AGENT_EWALLET) STORE AS (TABLESPACE &EM_ECM_DEPOT_TABLESPACE)
MONITORING;