Tables [dbo].[wtVPM_VirtualSwitch]
(local) > mdb > Tables > dbo.wtVPM_VirtualSwitch
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count0
Created2:46:13 PM Saturday, July 19, 2008
Last Modified2:46:13 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
VPM_Property6varchar(255)255
Yes
VPM_Property7varchar(255)255
Yes
VPM_Property8varchar(255)255
Yes
VPM_Property9varchar(255)255
Yes
VPM_Property10varchar(255)255
Yes
VSwtichNamevarchar(255)255
Yes
VSwtichNumPortsvarchar(255)255
Yes
VSwtichNumAvailPortsvarchar(255)255
Yes
VSwtichPortgroupvarchar(255)255
Yes
VSwtichBridgeTypevarchar(255)255
Yes
VSwtichBridgePNicvarchar(255)255
Yes
VSwtichPolicyOffloadChkSumint4
Yes
VSwtichPolicyOffloadtcpSegmtint4
Yes
VSwtichPolicyOffloadZeroCpyXint4
Yes
VSwtichPolicySecAllowPromisint4
Yes
VSwtichPolicySecForgedTransmitint4
Yes
VSwtichPolicySecMACChangesint4
Yes
VSwtichPolicySecShapingAvgBandvarchar(255)255
Yes
VSwtichPolicySecShapingAvgBursvarchar(255)255
Yes
VSwtichPolicySecShapingEnabledint4
Yes
VSwtichPolicySecShapingPeakBanvarchar(255)255
Yes
VSwtichPolicySecurityForgedTravarchar(255)255
Yes
VSwtichHostvarchar(255)255
Yes
VSwtichStateint4
Yes
VSwtichNicTeamActiveNicvarchar(255)255
Yes
VSwtichNicTeamStandByNicvarchar(255)255
Yes
VSwtichNicTeamNotifySwitchint4
Yes
VSwtichNicTeamNicTeamPolicyvarchar(255)255
Yes
VSwtichNicTeamReversePolicyint4
Yes
VSwtichNicTeamRollingOrderint4
Yes
VSwtichNicTeamFailureChkBeaconint4
Yes
VSwtichNicTeamFailureChkDuplexint4
Yes
VSwtichNicTeamFailureChkErrPctint4
Yes
VSwtichNicTeamFailureChkSpeedvarchar(255)255
Yes
VSwtichNicTeamFailureFullDupleint4
Yes
VSwtichNicTeamFailurePercentagvarchar(255)255
Yes
VSwtichNicTeamFailureSpeedvarchar(255)255
Yes
VSwtichMonitorint4
Yes
VSwtichAlertint4
Yes
DatacenterNamevarchar(255)255
Yes
VC_ServerNamevarchar(255)255
Yes
ClusterNamevarchar(255)255
Yes
VMServer_Namevarchar(255)255
Yes
VMhostnamevarchar(255)255
Yes
DatacenterIndexvarchar(255)255
Yes
ClusterIndexvarchar(255)255
Yes
VMServer_IDvarchar(255)255
Yes
SQL Script
CREATE TABLE [dbo].[wtVPM_VirtualSwitch]
(
[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,
[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,
[VSwtichName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VSwtichNumPorts] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VSwtichNumAvailPorts] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VSwtichPortgroup] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VSwtichBridgeType] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VSwtichBridgePNic] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VSwtichPolicyOffloadChkSum] [int] NULL,
[VSwtichPolicyOffloadtcpSegmt] [int] NULL,
[VSwtichPolicyOffloadZeroCpyX] [int] NULL,
[VSwtichPolicySecAllowPromis] [int] NULL,
[VSwtichPolicySecForgedTransmit] [int] NULL,
[VSwtichPolicySecMACChanges] [int] NULL,
[VSwtichPolicySecShapingAvgBand] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VSwtichPolicySecShapingAvgBurs] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VSwtichPolicySecShapingEnabled] [int] NULL,
[VSwtichPolicySecShapingPeakBan] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VSwtichPolicySecurityForgedTra] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VSwtichHost] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VSwtichState] [int] NULL,
[VSwtichNicTeamActiveNic] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VSwtichNicTeamStandByNic] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VSwtichNicTeamNotifySwitch] [int] NULL,
[VSwtichNicTeamNicTeamPolicy] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VSwtichNicTeamReversePolicy] [int] NULL,
[VSwtichNicTeamRollingOrder] [int] NULL,
[VSwtichNicTeamFailureChkBeacon] [int] NULL,
[VSwtichNicTeamFailureChkDuplex] [int] NULL,
[VSwtichNicTeamFailureChkErrPct] [int] NULL,
[VSwtichNicTeamFailureChkSpeed] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VSwtichNicTeamFailureFullDuple] [int] NULL,
[VSwtichNicTeamFailurePercentag] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VSwtichNicTeamFailureSpeed] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VSwtichMonitor] [int] NULL,
[VSwtichAlert] [int] NULL,
[DatacenterName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VC_ServerName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ClusterName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VMServer_Name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VMhostname] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DatacenterIndex] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ClusterIndex] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VMServer_ID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved