Rem drv: <create type="tables"  pos="assoc/assoc_tables.sql+"/>
Rem
Rem $Header: emcore/source/oracle/sysman/emdrep/sql/core/latest/cluster_node/cluster_node_tables.sql /st_emcore_10.2.0.4.2db11.2/2 2008/12/12 15:28:40 ajdsouza Exp $
Rem
Rem cluster_node_tables.sql
Rem
Rem Copyright (c) 2002, 2008, Oracle and/or its affiliates.
Rem All rights reserved. 
Rem
Rem    NAME
Rem      cluster_node_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    ajdsouza    12/08/08 - bug fix 7613499
Rem    ajdsouza    12/07/07 - added table MGMT_ECM_NODE_INFO
Rem    ajdsouza    12/07/07 - Created
Rem

-- 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 Host Cluster Node Config for target type host and snapshot type cluster_node_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_ECM_CLUSTER_NODE_INFO" (
  "ECM_SNAPSHOT_ID" RAW(16) NOT NULL CONSTRAINT "MGMT_ECM_CLUSTER_NODE_INFO0" REFERENCES "MGMT_ECM_GEN_SNAPSHOT" ("SNAPSHOT_GUID") ON DELETE CASCADE,
  "NODE_NAME" VARCHAR2(256),
  "CLUSTER_NAME" VARCHAR2(256),
  "CLUSTER_HOME" VARCHAR2(500),
  "NODE_LIST" VARCHAR2(4000),
  "NODE_STATUS" VARCHAR2(32),
  CONSTRAINT "MGMT_ECM_CLUSTER_NODE_INFO_PK" PRIMARY KEY ("ECM_SNAPSHOT_ID", "NODE_NAME")
) MONITORING;



CREATE INDEX MGMT_ECM_CLUSTER_NODE_INFO_I2 ON MGMT_ECM_CLUSTER_NODE_INFO( NODE_NAME );
CREATE INDEX MGMT_ECM_CLUSTER_NODE_INFO_I3 ON MGMT_ECM_CLUSTER_NODE_INFO( CLUSTER_NAME );


-- End of table (re)creation for metadata Host Cluster Node Config