Rem drv: <migrate type="schema_upgrade" version="11.0.0.0"/>
Rem
Rem $Header: emdb/source/oracle/sysman/emdrep/sql/db/11.0.0.0/prefs/prefs_schema_upgrade.sql /st_emdbsa_11.2/1 2008/10/08 10:42:53 swexler Exp $
Rem
Rem prefs_schema_upgrade.sql
Rem
Rem Copyright (c) 2006, 2008, Oracle and/or its affiliates. All rights reserved.
Rem
Rem    NAME
Rem      prefs_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    swexler     10/03/08 - dont refer to latest
Rem    swexler     08/07/06 - Created
Rem


Rem Create prefs tables
Rem

CREATE TABLE DB_USER_PREFERENCES (
  TARGET_NAME             VARCHAR2(256),
  TARGET_TYPE             VARCHAR2(64),
  PAGE_NAME               VARCHAR2(64),
  USER_NAME               VARCHAR2(64) NOT NULL,
  PREFERENCE_NAME         VARCHAR2(256) NOT NULL,
  PREFERENCE_VALUE        VARCHAR2(1000)
) MONITORING;