Rem drv: <migrate type="schema_upgrade" version="10.2.0.1" pos="rca_schema_upgrade.sql+"/>
Rem
Rem $Header: website_schema_upgrade.sql 25-jul-2005.14:22:32 chyu Exp $
Rem
Rem website_schema_upgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      website_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 - adding the upgrade 
Rem                           header
Rem    yxie        06/20/05 - yxie_bug-4390544
Rem    yxie        05/25/05 - Created
Rem

rem
rem  PURPOSE
rem
rem     The EUME2E_ASSOCS_LOOKUP table contains the target types
rem     that may have corresponding supports_eum_on or supports_e2e_on
rem     associations.
rem
rem  COLUMNS
rem
rem     TARGET_TYPE - target type that can have supports_eum_on or
rem                   supports_e2e_on associations
rem
rem     ASSOC_GUID  - the unique id of the association
rem
rem  NOTES
rem
rem     None of the target_type or assoc_guid can be NULL;
rem
rem

CREATE TABLE EUME2E_ASSOCS_LOOKUP
    (target_type           VARCHAR2(64)    NOT NULL,
     assoc_guid            RAW(16)         NOT NULL);

Rem
Rem Index for EUME2E_ASSOCS_LOOKUP table
Rem
ALTER TABLE EUME2E_ASSOCS_LOOKUP
   ADD CONSTRAINT eume2e_lookup_primary_key
       PRIMARY KEY (target_type, assoc_guid)
       USING INDEX STORAGE
                (FREELISTS 4)
                INITRANS 4;