CREATE TABLE [dbo].[wtssport]
(
[uuid] [binary] (16) NOT NULL,
[name] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[status_no] [int] NULL,
[status] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[propagate_status] [tinyint] NOT NULL,
[mac_address] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[if_index] [int] NOT NULL,
[port_index] [int] NULL,
[module_index] [int] NULL,
[dot1d_port_index] [int] NULL,
[speed] [int] NULL,
[port_type] [int] NULL,
[managed_bits] [int] NULL,
[pbnc_type] [int] NULL,
[vlan_index] [int] NULL,
[vlan_admin_status] [int] NULL,
[is_trunk] [tinyint] NULL,
[vlans_allowed] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[priority_vlans] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[parent_uuid] [binary] (16) NOT NULL,
[switch_uuid] [binary] (16) NOT NULL,
[switch_class] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[switch_address] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[port_ip_address] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[port_mode] [int] NULL,
[upper_if] [int] NULL,
[remote_ip_address] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[bgp_peer_id] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wtssport] ADD CONSTRAINT [XPKwtssport] PRIMARY KEY CLUSTERED ([uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ssport_dx3] ON [dbo].[wtssport] ([parent_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ssport_dx4] ON [dbo].[wtssport] ([switch_address]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ssport_dx2] ON [dbo].[wtssport] ([switch_address], [if_index]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ssport_dx1] ON [dbo].[wtssport] ([switch_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ssport_dx5] ON [dbo].[wtssport] ([uuid]) ON [PRIMARY]
GO