Rem drv: <migrate type="schema_upgrade" version="10.2.0.1" pos="service_level/service_level_schema_upgrade.sql+"/>
Rem $Header: console_schema_upgrade.sql 10-nov-2006.18:00:52 rpatti Exp $
Rem
Rem gensvc_post_creation.sql
Rem
Rem Copyright (c) 2005, 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      console_scheme_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    rpatti      11/10/06 - pull in em_page_custmzn_tables
Rem    vesriniv    08/05/05 - add header 
Rem    vesriniv    08/04/05 - vesriniv_custtxn
Rem    vesriniv    07/12/05 - Created
Rem

Rem  Table:
Rem    EM_PAGE_CUST_METADATA 
Rem
Rem  Columns:
Rem    page_name       - Name of the page. Example: groups.edit_group, webapps.edit_webapp etc
Rem    cust_name       - Name of the customization. Example: disallow_member_edit, disallow_perf_metrics etc
Rem    def_cust_value  - Name of the customization. Example: true / false
Rem  

CREATE TABLE EM_PAGE_CUST_METADATA (      
    page_name         VARCHAR2(64) NOT NULL,
    cust_name         VARCHAR2(64) NOT NULL,
    def_cust_value    VARCHAR2(64) DEFAULT 'false' NOT NULL,
    CONSTRAINT em_page_cust_metadata_pk 
    Primary Key(page_name, cust_name)
)
MONITORING;

Rem  Table:
Rem      EM_PAGE_CONDITION_METADATA
Rem
Rem  Columns:
Rem    page_name       - Name of the page. Example: groups.edit_group, webapps.edit_webapp etc
Rem    condition_name  - Name of the condition.
Rem
CREATE TABLE EM_PAGE_CONDITION_METADATA (      
    page_name         VARCHAR2(64)  NOT NULL,
    condition_name    VARCHAR2(64)  NOT NULL,
    CONSTRAINT em_page_condition_metadata_pk 
    Primary Key(page_name, condition_name)
)
MONITORING;

Rem    Table:
Rem        EM_PAGE_CUSTOMIZATIONS
Rem
Rem  Columns:
Rem    page_name        - Name of the page. Example: groups.edit_group
Rem    cust_name        - Name of the customization. Example: disallow_member_edit, disallow_perf_metrics etc
Rem    cust_value       - Value of the customization. Example: true / false
Rem    condition_set_id - GUID of the condition - uniquely identified condition name and condition value
Rem
CREATE TABLE EM_PAGE_CUSTOMIZATIONS (      
    page_name         VARCHAR2(64) NOT NULL,
    cust_name         VARCHAR2(64) NOT NULL,
    cust_value        VARCHAR2(64) NOT NULL,
    condition_set_id  RAW(16)      NOT NULL,
    CONSTRAINT em_page_customizations_pk 
    Primary Key(page_name, cust_name, condition_set_id)
)
MONITORING;

Rem  Table:
Rem    EM_PAGE_CUSTOM_CONDITIONS
Rem
Rem  Columns:
Rem    condition_set_id  - GUID of the condition - uniquely identified condition name and condition value
Rem    condition_name    - Name of the condition. Example: Type, Target etc
Rem    condition_value   - Value of the condition. Example: ocs_email_system, website etc 
Rem
CREATE TABLE EM_PAGE_CUSTOM_CONDITIONS(      
    condition_set_id   RAW(16)       NOT NULL,
    condition_name     VARCHAR2(64)  NOT NULL,
    condition_value    VARCHAR2(64)  NOT NULL,
    CONSTRAINT em_page_custom_condition_pk 
    Primary Key(condition_set_id, condition_name)
)
MONITORING;