Tables [dbo].[wtCACMO_VCServiceGroup]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count0
Created2:46:11 PM Saturday, July 19, 2008
Last Modified2:46:11 PM Saturday, July 19, 2008
Columns
NameData TypeMax Length (Bytes)Allow Nulls
uuidbinary(16)16
No
VPM_Property1varchar(255)255
Yes
VPM_Property2varchar(255)255
Yes
VPM_Property3varchar(255)255
Yes
VPM_Property4varchar(255)255
Yes
VPM_Property5varchar(255)255
Yes
Cluster_Namevarchar(255)255
Yes
Cluster_Typevarchar(64)64
Yes
Manage_Clusterint4
Yes
Log_Levelint4
Yes
Log_File_Sizeint4
Yes
Console_Message_Levelint4
Yes
CMO_Portint4
Yes
Analysis_Intervalint4
Yes
Poll_Intervalint4
Yes
Manage_RGint4
Yes
Manager_Hostvarchar(64)64
Yes
Service_Group_Namevarchar(255)255
Yes
Service_Group_Nodevarchar(255)255
Yes
SQL Script
CREATE TABLE [dbo].[wtCACMO_VCServiceGroup]
(
[uuid] [binary] (16) NOT NULL,
[VPM_Property1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property3] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property4] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property5] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Cluster_Name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Cluster_Type] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Manage_Cluster] [int] NULL,
[Log_Level] [int] NULL,
[Log_File_Size] [int] NULL,
[Console_Message_Level] [int] NULL,
[CMO_Port] [int] NULL,
[Analysis_Interval] [int] NULL,
[Poll_Interval] [int] NULL,
[Manage_RG] [int] NULL,
[Manager_Host] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Service_Group_Name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Service_Group_Node] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
Uses