Rem drv: <create type="tables" pos="esm/esm_tables.sql-" condition="EM_REPOS_MODE=SYSAUX"/>
Rem
Rem $Header: esm_tables_db.sql 03-apr-2007.23:00:17 jsadras Exp $
Rem
Rem esm_tables_db.sql
Rem
Rem Copyright (c) 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      esm_tables_db.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem     This tables will be created in DBSA mode only. For GC mode
Rem     the same tables will be created by em_tables_rc.sql ( with IOT)
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    jsadras     04/03/07 - Bug:5964364
Rem    jsadras     04/03/07 - Created
Rem

CREATE TABLE "ESM_COLLECTION" (
  "ECM_SNAPSHOT_ID" RAW(16) NOT NULL CONSTRAINT "ESM_COLLECTION0" REFERENCES "MGMT_ECM_GEN_SNAPSHOT" ("SNAPSHOT_GUID") ON DELETE CASCADE,
  "PROPERTY" VARCHAR2(64),
  "VALUE" VARCHAR2(512),
  "VALUE2" VARCHAR2(512) DEFAULT 'NA',
  CONSTRAINT "ESM_COLLECTION_PK" PRIMARY KEY ("ECM_SNAPSHOT_ID", "PROPERTY", "VALUE", "VALUE2")
)
MONITORING;


-- Create tables
CREATE TABLE "MGMT_ESA_REPORT" (
  "ECM_SNAPSHOT_ID" RAW(16) NOT NULL CONSTRAINT "MGMT_ESA_REPORT0" REFERENCES "MGMT_ECM_GEN_SNAPSHOT" ("SNAPSHOT_GUID") ON DELETE CASCADE,
  "PRINCIPAL" VARCHAR2(512),
  "OBJECT_NAME" VARCHAR2(512),
  "REPORT_NAME" VARCHAR2(256),
  CONSTRAINT "MGMT_ESA_REPORT_PK" PRIMARY KEY ("ECM_SNAPSHOT_ID", "PRINCIPAL", "OBJECT_NAME", "REPORT_NAME")
)
MONITORING;