Tables [dbo].[wtcacmo_mscsresourcegroup]
Properties
PropertyValue
Row Count0
Created11:07:48 AM Wednesday, March 07, 2007
Last Modified2:46:10 PM Saturday, July 19, 2008
Columns
NameData TypeCollationMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKwtcacmo_mscsresourcegroup: uuiduuidbinary(16)16
No
cluster_namevarchar(255)SQL_Latin1_General_CP1_CS_AS255
Yes
cluster_typevarchar(64)SQL_Latin1_General_CP1_CS_AS64
Yes
manage_clusterint4
Yes
log_levelint4
Yes
log_file_sizeint4
Yes
console_message_levelint4
Yes
cacmo_portint4
Yes
analysis_intervalint4
Yes
poll_intervalint4
Yes
manager_hostvarchar(64)SQL_Latin1_General_CP1_CS_AS64
Yes
manage_rgint4
Yes
resource_group_namevarchar(255)SQL_Latin1_General_CP1_CS_AS255
Yes
resource_group_nodevarchar(255)SQL_Latin1_General_CP1_CS_AS255
Yes
resource_group_statusvarchar(64)SQL_Latin1_General_CP1_CS_AS64
Yes
VPM_Property1varchar(255)SQL_Latin1_General_CP1_CI_AS255
Yes
VPM_Property2varchar(255)SQL_Latin1_General_CP1_CI_AS255
Yes
VPM_Property3varchar(255)SQL_Latin1_General_CP1_CI_AS255
Yes
VPM_Property4varchar(255)SQL_Latin1_General_CP1_CI_AS255
Yes
VPM_Property5varchar(255)SQL_Latin1_General_CP1_CI_AS255
Yes
VPM_Property6varchar(255)SQL_Latin1_General_CP1_CI_AS255
Yes
VPM_Property7varchar(255)SQL_Latin1_General_CP1_CI_AS255
Yes
VPM_Property8varchar(255)SQL_Latin1_General_CP1_CI_AS255
Yes
VPM_Property9varchar(255)SQL_Latin1_General_CP1_CI_AS255
Yes
VPM_Property10varchar(255)SQL_Latin1_General_CP1_CI_AS255
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKwtcacmo_mscsresourcegroup: uuidXPKwtcacmo_mscsresourcegroupuuid
Yes
SQL Script
CREATE TABLE [dbo].[wtcacmo_mscsresourcegroup]
(
[uuid] [binary] (16) NOT NULL,
[cluster_name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[cluster_type] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[manage_cluster] [int] NULL,
[log_level] [int] NULL,
[log_file_size] [int] NULL,
[console_message_level] [int] NULL,
[cacmo_port] [int] NULL,
[analysis_interval] [int] NULL,
[poll_interval] [int] NULL,
[manager_host] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[manage_rg] [int] NULL,
[resource_group_name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[resource_group_node] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[resource_group_status] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS 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,
[VPM_Property6] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property7] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property8] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property9] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VPM_Property10] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wtcacmo_mscsresourcegroup] ADD CONSTRAINT [XPKwtcacmo_mscsresourcegroup] PRIMARY KEY CLUSTERED ([uuid]) ON [PRIMARY]
GO
Uses
Used By