CREATE TABLE [dbo].[wtanofroif]
(
[cir] [int] NULL,
[containerhost] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[hostname] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dlcmi] [int] NULL,
[dlci] [int] NULL,
[incongestionthresh] [int] NULL,
[outcongestionthresh] [int] NULL,
[utilizationthreshold] [int] NULL,
[ifdescription] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ifindex] [int] NULL,
[iftype] [int] NULL,
[interface_no] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ip_address_hex] [binary] (4) NULL,
[network_address_hex] [binary] (4) NULL,
[pvclinkid] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[remote_ip_address_hex] [binary] (4) NULL,
[subnet_mask] [binary] (4) NULL,
[autoarrange_type] [int] NULL,
[frlink_uuid] [binary] (16) NULL,
[frlink_flag] [int] NULL,
[ifalias] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ref_wvid] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[uuid] [binary] (16) NOT NULL,
[name] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[device_name] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[address] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[neighbor] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ref_uuid] [binary] (16) NULL,
[class_name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[prop_status] [tinyint] NULL,
[checker] [tinyint] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wtanofroif] ADD CONSTRAINT [XPKwtanofroif] PRIMARY KEY CLUSTERED ([uuid]) ON [PRIMARY]
GO