Rem drv: <migrate type="schema_upgrade" version="11.2.0.0"/>
Rem
Rem $Header: emtp/oracle_cell/cell/11.2.0.0/cell/cell_schema_upgrade.sql /main/2 2009/03/18 13:45:29 spalapud Exp $
Rem
Rem cell_schema_upgrade.sql
Rem
Rem Copyright (c) 2008, 2009, Oracle and/or its affiliates.
Rem All rights reserved. 
Rem
Rem    NAME
Rem      cell_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    spalapud    03/04/09 - remove bmcconfigured
Rem    ysun        10/29/08 - Created
Rem

CREATE OR REPLACE TYPE emxCellStringAggCollectType AS TABLE OF VARCHAR2(4000)
/

 ------------------ Create Table: MGMT_EMX_CELL_C_CONFIG  --------
  CREATE TABLE MGMT_EMX_CELL_C_CONFIG (
  "ECM_SNAPSHOT_ID" RAW(16) NOT NULL CONSTRAINT "MGMT_EMX_CELL_C_CONFIG0" REFERENCES "MGMT_ECM_GEN_SNAPSHOT" ("SNAPSHOT_GUID") ON DELETE CASCADE,
  "NAME" VARCHAR2(200),
  "STATUS" VARCHAR2(200),
  "REALMNAME" VARCHAR2(200),
  "ID" VARCHAR2(200),
  "MAKEMODEL" VARCHAR2(200),
  "LOCATION" VARCHAR2(200),
  "BMCTYPE" VARCHAR2(200),
  "IPBLOCK" VARCHAR2(200),
  "FANCOUNT" NUMBER,
  "POWERCOUNT" NUMBER,
  "METRICHISTORYDAYS" NUMBER,
  "SNMPSUBSCRIBER" VARCHAR2(200),
  "SMTPSERVER" VARCHAR2(200),
  "SMTPPORT" VARCHAR2(200),
  "IPADDRESS1" VARCHAR2(200),
  "IPADDRESS2" VARCHAR2(200),
  "IPADDRESS3" VARCHAR2(200),
  "IPADDRESS4" VARCHAR2(200),
  "KERNELVERSION" VARCHAR2(200),
  "OSSVERSION" VARCHAR2(200),
  "INTERCONNECTCOUNT" NUMBER,
  "CPUCOUNT" NUMBER,
  CONSTRAINT "MGMT_EMX_CELL_C_CONFIG_PK" PRIMARY KEY ("ECM_SNAPSHOT_ID")
  ) MONITORING  ;

 ------------------ Create Table: MGMT_EMX_CELL_GD_CONFIG  --------
  CREATE TABLE MGMT_EMX_CELL_GD_CONFIG (
  "ECM_SNAPSHOT_ID" RAW(16) NOT NULL CONSTRAINT "MGMT_EMX_CELL_GD_CONFIG0" REFERENCES "MGMT_ECM_GEN_SNAPSHOT" ("SNAPSHOT_GUID") ON DELETE CASCADE,
  "NAME" VARCHAR2(200),
  "CELLNAME" VARCHAR2(200),
  "REALMNAME" VARCHAR2(200),
  "STATUS" VARCHAR2(200),
  "GDSIZE" NUMBER,
  "CREATIONTIME" VARCHAR2(200),
  "CELLDISK" VARCHAR2(200),
  "OFFSET" NUMBER,
  "ERRORCOUNT" NUMBER,
  "AVAILABLETO" VARCHAR2(200),
  CONSTRAINT "MGMT_EMX_CELL_GD_CONFIG_PK" PRIMARY KEY ("ECM_SNAPSHOT_ID", "NAME", "CELLNAME", "REALMNAME", "CELLDISK")
  ) MONITORING  ;


 ------------------ Create Table: MGMT_EMX_CELL_CD_CONFIG  --------
   CREATE TABLE MGMT_EMX_CELL_CD_CONFIG (
  "ECM_SNAPSHOT_ID" RAW(16) NOT NULL CONSTRAINT "MGMT_EMX_CELL_CD_CONFIG0" REFERENCES "MGMT_ECM_GEN_SNAPSHOT" ("SNAPSHOT_GUID") ON DELETE CASCADE,
  "NAME" VARCHAR2(200),
  "CELLNAME" VARCHAR2(200),
  "REALMNAME" VARCHAR2(200),
  "STATUS" VARCHAR2(200),
  "CDSIZE" VARCHAR2(200),
  "LUN" VARCHAR2(200),
  "ERRORCOUNT" NUMBER,
  "FREESPACE" NUMBER,
  "DEVICEPARTITION" VARCHAR2(200),
  CONSTRAINT "MGMT_EMX_CELL_CD_CONFIG_PK" PRIMARY KEY ("ECM_SNAPSHOT_ID", "NAME", "CELLNAME", "REALMNAME")
  ) MONITORING  ;

 ------------------ Create Table: MGMT_EMX_CELL_L_CONFIG  --------
  CREATE TABLE MGMT_EMX_CELL_L_CONFIG (
  "ECM_SNAPSHOT_ID" RAW(16) NOT NULL CONSTRAINT "MGMT_EMX_CELL_L_CONFIG0" REFERENCES "MGMT_ECM_GEN_SNAPSHOT" ("SNAPSHOT_GUID") ON DELETE CASCADE,
  "NAME" VARCHAR2(200),
  "CELLNAME" VARCHAR2(200),
  "REALMNAME" VARCHAR2(200),
  "STATUS" VARCHAR2(200),
  "ID" VARCHAR2(200),
  "CELLDISK" VARCHAR2(200),
  "ERRORCOUNT" NUMBER,
  "RAIDLEVEL" VARCHAR2(200),
  "DEVICENAME" VARCHAR2(200),
  "LUNSIZE" NUMBER,
  "LUNUID" VARCHAR2(200),
  "LUNAUTOCREATE" VARCHAR2(200),
  "PHYSICALDISKS" VARCHAR2(1000),
  CONSTRAINT "MGMT_EMX_CELL_L_CONFIG_PK" PRIMARY KEY ("ECM_SNAPSHOT_ID", "NAME", "CELLNAME", "REALMNAME")
  ) MONITORING ;

 ------------------ Create Table: MGMT_EMX_CELL_PD_CONFIG  --------
   CREATE TABLE MGMT_EMX_CELL_PD_CONFIG (
  "ECM_SNAPSHOT_ID" RAW(16) NOT NULL CONSTRAINT "MGMT_EMX_CELL_PD_CONFIG0" REFERENCES "MGMT_ECM_GEN_SNAPSHOT" ("SNAPSHOT_GUID") ON DELETE CASCADE,
  "NAME" VARCHAR2(200),
  "CELLNAME" VARCHAR2(200),
  "REALMNAME" VARCHAR2(200),
  "STATUS" VARCHAR2(200),
  "ID" VARCHAR2(200),
  "MAKEMODEL" VARCHAR2(200),
  "LUNS" VARCHAR2(1000),
  "ERRORCOUNT" VARCHAR2(200),
  "CTRLFIRMWARE" VARCHAR2(200),
  "CTRLHWVERSION" VARCHAR2(200),
  "PHYSINTERFACE" VARCHAR2(200),
  "PHYSFIRMWARE" VARCHAR2(200),
  "PHYSSIZE" VARCHAR2(200),
  "PHYSSERIAL" VARCHAR2(200),
  "PHYSUSETYPE" VARCHAR2(200),
  "PHYSPORT" VARCHAR2(200),
  "PHYSINSERTTIME" VARCHAR2(200),
  CONSTRAINT "MGMT_EMX_CELL_PD_CONFIG_PK" PRIMARY KEY ("ECM_SNAPSHOT_ID", "NAME", "CELLNAME", "REALMNAME")
  ) MONITORING  ;

 ------------------ Create Table: MGMT_EMX_CELL_IORM_CONFIG  --------
  CREATE TABLE MGMT_EMX_CELL_IORM_CONFIG (
  "ECM_SNAPSHOT_ID" RAW(16) NOT NULL CONSTRAINT "MGMT_EMX_CELL_IORM_CONFIG0" REFERENCES "MGMT_ECM_GEN_SNAPSHOT" ("SNAPSHOT_GUID") ON DELETE CASCADE,
  "NAME" VARCHAR2(200),
  "CELLNAME" VARCHAR2(200),
  "REALMNAME" VARCHAR2(200),
  "STATUS" VARCHAR2(200),
  "LATENCY" VARCHAR2(200),
  "DIRECTIVETYPE" VARCHAR2(200),
  "DBCATNAME" VARCHAR2(200),
  "LEVEL1" VARCHAR2(200),
  "LEVEL2" VARCHAR2(200),
  "LEVEL3" VARCHAR2(200),
  "LEVEL4" VARCHAR2(200),
  "LEVEL5" VARCHAR2(200),
  "LEVEL6" VARCHAR2(200),
  "LEVEL7" VARCHAR2(200),
  "LEVEL8" VARCHAR2(200),
  "ROLE" VARCHAR2(200),
  CONSTRAINT "MGMT_EMX_CELL_IORM_CONFIG_PK" PRIMARY KEY ("ECM_SNAPSHOT_ID", "NAME", "CELLNAME", "REALMNAME", "DIRECTIVETYPE", "DBCATNAME")
  ) MONITORING  ;
-- End of table (re)creation for metadata Oracle Cell Configuration