CREATE TABLE [dbo].[wtssmedia]
(
[uuid] [binary] (16) NOT NULL,
[suuid] [binary] (16) NOT NULL,
[address] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[if_index] [int] NOT NULL,
[tng_uuid] [binary] (16) NULL,
[tng_class] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[nc_tng_uuid] [binary] (16) NULL,
[nc_seg_uuid] [binary] (16) NULL,
[nc_seg_class] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sc_tng_uuid] [binary] (16) NULL,
[sc_seg_uuid] [binary] (16) NULL,
[sc_seg_class] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mac_address] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wtssmedia] ADD CONSTRAINT [XPKwtssmedia] PRIMARY KEY CLUSTERED ([uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ssmedia_dx2] ON [dbo].[wtssmedia] ([address], [if_index]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ssmedia_dx3] ON [dbo].[wtssmedia] ([mac_address]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ssmedia_dx4] ON [dbo].[wtssmedia] ([nc_seg_class]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ssmedia_dx1] ON [dbo].[wtssmedia] ([suuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [x_ssmedia_suuid_x] ON [dbo].[wtssmedia] ([suuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ssmedia_dx6] ON [dbo].[wtssmedia] ([tng_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ssmedia_dx5] ON [dbo].[wtssmedia] ([uuid]) ON [PRIMARY]
GO