Rem drv: <create type="tables"/>
Rem
Rem $Header: emtp/oracle_cell/cell/latest/cell/cell_tables.sql /main/2 2009/03/18 13:45:28 spalapud Exp $
Rem
Rem cell_tables.sql
Rem
Rem Copyright (c) 2008, 2009, Oracle and/or its affiliates.
Rem All rights reserved. 
Rem
Rem    NAME
Rem      cell_tables.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 column
Rem    ysun        11/12/08 - Created
Rem

 ------------------ 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