CREATE TABLE [dbo].[wtssswitch]
(
[uuid] [binary] (16) NOT NULL,
[address] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[tng_uuid] [binary] (16) NOT NULL,
[tng_class] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[parent_uuid] [binary] (16) NULL,
[bridge_id] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[high_bridge_id] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[auto_update] [tinyint] NULL,
[update_interval] [int] NULL,
[snmp_timeout] [int] NULL,
[snmp_retries] [int] NULL,
[date_modify] [datetime] NULL,
[switch_type] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wtssswitch] ADD CONSTRAINT [XPKwtssswitch] PRIMARY KEY CLUSTERED ([uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ssswitch_dx1] ON [dbo].[wtssswitch] ([address]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [x_ssswitch_address_x] ON [dbo].[wtssswitch] ([address]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ssswitch_dx2] ON [dbo].[wtssswitch] ([parent_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ssswitch_dx3] ON [dbo].[wtssswitch] ([tng_uuid]) ON [PRIMARY]
GO