Rem drv: <migrate type="schema_upgrade" version="10.2.0.3"/>
Rem
Rem $Header: website_schema_upgrade.sql 03-nov-2006.15:49:02 yxie Exp $
Rem
Rem website_schema_upgrade.sql
Rem
Rem Copyright (c) 2006, 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    yxie        09/27/06 - 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. Add another column is_group in 10.2.0.3
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

ALTER TABLE &EM_REPOS_USER..EUME2E_ASSOCS_LOOKUP ADD IS_GROUP NUMBER DEFAULT 0 NOT NULL;

ALTER TABLE &EM_REPOS_USER..EUME2E_ASSOCS_LOOKUP ADD EXPAND_GROUP NUMBER DEFAULT 0 NOT NULL;