Rem
Rem $Header: storage_ui_tables.sql 26-jul-2005.15:27:34 sreddy Exp $
Rem
Rem storage_ui_tables.sql
Rem
Rem Copyright (c) 2004, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      storage_ui_tables.sql - 
Rem
Rem    DESCRIPTION
Rem      contains tables used in rendering UI.
Rem
Rem    NOTES
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    sreddy      07/26/05 - sreddy_bug4253179
Rem    sreddy      07/23/05 - Created
Rem

-- Drop global temporary table first
DROP TABLE MGMT_STORAGE_REPORT_UI_TARGETS;

--
-- Now create the global temporary table with an additional column
-- of ECM_SNAPSHOT_ID
--
CREATE GLOBAL TEMPORARY TABLE MGMT_STORAGE_REPORT_UI_TARGETS
(
  TARGET_TYPE VARCHAR2(64) NOT NULL,
  TARGET_NAME VARCHAR2(256) NOT NULL,
  TARGET_GUID RAW(16) NOT NULL,
  ECM_SNAPSHOT_ID RAW(16) DEFAULT NULL
);