[dbo].[wtVPM_PhysicalNIC]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	0
Created	2:46:13 PM Saturday, July 19, 2008
Last Modified	2:46:13 PM Saturday, July 19, 2008

Name	Data Type	Max Length (Bytes)
uuid	binary(16)	16
VPM_Property1	varchar(255)	255
VPM_Property2	varchar(255)	255
VPM_Property3	varchar(255)	255
VPM_Property4	varchar(255)	255
VPM_Property5	varchar(255)	255
VPM_Property6	varchar(255)	255
VPM_Property7	varchar(255)	255
VPM_Property8	varchar(255)	255
VPM_Property9	varchar(255)	255
VPM_Property10	varchar(255)	255
PhysicalNicName	varchar(255)	255
PhysicalNicPCI	varchar(255)	255
PhysicalNicLongName	varchar(255)	255
PhysicalNicVendor	varchar(255)	255
PhysicalNicDriver	varchar(255)	255
PhysicalNicIPIsDHCP	int	4
PhysicalNicIP	varchar(255)	255
PhysicalNicSubnetMask	varchar(255)	255
PhysicalNicSppedDuplex	varchar(255)	255
PhysicalNicVirtualSwitch	int	4
PhysicalNicLinkState	int	4
PhysicalNicHost	varchar(255)	255
PhysicalNicMonitor	varchar(255)	255
PhysicalNicAlert	int	4
DatacenterName	varchar(255)	255
VC_ServerName	varchar(255)	255
ClusterName	varchar(255)	255
VMServer_Name	varchar(255)	255
DatacenterIndex	varchar(255)	255
ClusterIndex	varchar(255)	255
VMServer_ID	varchar(255)	255

SQL Script

CREATE TABLE [dbo].[wtVPM_PhysicalNIC]
(
[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,
[PhysicalNicName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PhysicalNicPCI] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PhysicalNicLongName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PhysicalNicVendor] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PhysicalNicDriver] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PhysicalNicIPIsDHCP] [int] NULL,
[PhysicalNicIP] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PhysicalNicSubnetMask] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PhysicalNicSppedDuplex] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PhysicalNicVirtualSwitch] [int] NULL,
[PhysicalNicLinkState] [int] NULL,
[PhysicalNicHost] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PhysicalNicMonitor] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PhysicalNicAlert] [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,
[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