Rem drv: <create type="tables" pos="mp_homepage/mp_homepage_tables.sql+"/>
Rem
Rem $Header: website_tables.sql 09-nov-2006.17:09:25 yxie Exp $
Rem
Rem website_tables.sql
Rem
Rem Copyright (c) 2005, 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      website_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    yxie        11/09/06 - XbranchMerge yxie_bug5567723 from main
Rem    yxie        09/27/06 - 
Rem    gsbhatia    06/26/05 - New repmgr header impl 
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,
     is_group              NUMBER          DEFAULT 0 NOT NULL,
     expand_group          NUMBER          DEFAULT 0 NOT NULL);