Rem
Rem $Header: syshist_tables.sql 18-jul-2006.19:33:47 vkarpura Exp $
Rem
Rem syshist_tables.sql
Rem
Rem Copyright (c) 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      syshist_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    vkarpura    04/14/06 - Creation
Rem    vkarpura    04/14/06 - Creation
Rem    vkarpura    04/14/06 - Created
Rem

--
-- Generated by generateCreateTables.pl at Fri Apr 14 14:35:35 2006
--

-- Uncomment the following line to see the commands during the script execution
-- SET ECHO ON 

-- Do not use substitution variables in this script so that there is no
-- additional restrictions on the string values that are being inserted (such as ampersand 
-- being interpreted specially by SQLPlus).
SET DEFINE OFF 

--------------------------------------------
-- Table (re)creation statements based on metadata Service Dependency  for target type generic_system and snapshot type system_change_config
-- Please REVIEW the table (re)creation statements below and modify them if necessary. Examples: 
--   (1) You meant for a TABLE tag in the metadata to represent a view. Then, remove the corresponding drop-table / create-table statements.
--   (2) Generated PRIMARY KEY constraints are supposed to be uniqueness constraints instead.
--   (3) You want to impose additional constraints on the tables.
--------------------------------------------
-- Create tables

CREATE TABLE "MGMT_SYSTEM_CHANGES" (
  "ECM_SNAPSHOT_ID" RAW(16) NOT NULL CONSTRAINT "MGMT_SYSTEM_CHANGES0" REFERENCES "MGMT_ECM_GEN_SNAPSHOT" ("SNAPSHOT_GUID") ON DELETE CASCADE,
  "SYSTEM_NAME" VARCHAR2(200) NOT NULL,
  "SYSTEM_TYPE" VARCHAR2(200) NOT NULL,
  "MEMBER_NAME" VARCHAR2(200) NOT NULL,
  "MEMBER_TYPE" VARCHAR2(200) NOT NULL,
  "MODIFIED_BY" VARCHAR2(200),
  CONSTRAINT "MGMT_SYSTEM_CHANGES_PK" PRIMARY KEY ("ECM_SNAPSHOT_ID", "MEMBER_NAME", "MEMBER_TYPE")
) MONITORING;


-- End of table (re)creation for metadata Service Dependency 

--------------------------------------------

SET DEFINE ON