Rem drv: <migrate type="schema_upgrade" version="10.1.0.3"/> 
Rem
Rem $Header: license_schema_upgrade.sql 13-jan-2005.00:58:38 ktlaw Exp $
Rem
Rem license_schema_upgrade.sql
Rem
Rem Copyright (c) 2004, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      license_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    ktlaw       01/13/05 - add repmgr header 
Rem    yaofeng     04/23/04 - yaofeng_work0423 
Rem    yaofeng     04/23/04 - Created
Rem


CREATE TABLE MGMT_LICENSE_DEFINITIONS (
    pack_label              VARCHAR2(64)         NOT NULL,
    target_type             VARCHAR2(64)         DEFAULT ' ',
    pack_display_label      VARCHAR2(128)        DEFAULT ' ',
    pack_label_nlsid        VARCHAR2(64)         DEFAULT ' ',
    pack_description        VARCHAR2(256)        DEFAULT ' ',
    pack_description_nlsid  VARCHAR2(64)         DEFAULT ' ',
    CONSTRAINT MGMT_LICENSE_DEFINITIONS_PK PRIMARY KEY (pack_label))
  MONITORING;

CREATE TABLE MGMT_ADMIN_LICENSES (
    pack_name VARCHAR2(64) NOT NULL,
    CONSTRAINT MGMT_ADMIN_LICENSES_PK PRIMARY KEY (pack_name))
   MONITORING;

CREATE TABLE MGMT_LICENSABLE_TARGET_TYPES (
   pack_target_type VARCHAR2(64) NOT NULL,
   target_type    VARCHAR2(64)   NOT NULL,
   CONSTRAINT MGMT_LICENSABLE_TYPES_PK PRIMARY KEY (pack_target_type, target_type))
  ORGANIZATION INDEX MONITORING;