CREATE TABLE [dbo].[wtSANSwitchPortThresholds]
(
[uuid] [binary] (16) NOT NULL,
[name] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CRC_Errors_Warning] [int] NULL,
[CRC_Errors_Critical] [int] NULL,
[AddressErrors_Warning] [int] NULL,
[AddressErrors_Critical] [int] NULL,
[DelimiterErrors_Warning] [int] NULL,
[DelimiterErrors_Critical] [int] NULL,
[InvalidTxWords_Warning] [int] NULL,
[InvalidTxWords_Critical] [int] NULL,
[LinkFailures_Warning] [int] NULL,
[LinkFailures_Critical] [int] NULL,
[LinkResetsRx_Warning] [int] NULL,
[LinkResetsRx_Critical] [int] NULL,
[LinkResetsTx_Warning] [int] NULL,
[LinkResetsTx_Critical] [int] NULL,
[PSPErrors_Warning] [int] NULL,
[PSPErrors_Critical] [int] NULL,
[SignalLossDetections_Warning] [int] NULL,
[SignalLossDetections_Critical] [int] NULL,
[SyncLossDetections_Warning] [int] NULL,
[SyncLossDetections_Critical] [int] NULL,
[EDErrors_Warning] [int] NULL,
[EDErrors_Critical] [int] NULL,
[FramesTooLong_Warning] [int] NULL,
[FramesTooLong_Critical] [int] NULL,
[FramesTruncated_Warning] [int] NULL,
[FramesTruncated_Critical] [int] NULL,
[InvalidOrderedSets_Warning] [int] NULL,
[InvalidOrderedSets_Critical] [int] NULL,
[DataReceived_Warning] [int] NULL,
[DataReceived_Critical] [int] NULL,
[DataTransmitted_Warning] [int] NULL,
[DataTransmitted_Critical] [int] NULL,
[DataThroughput_Warning] [int] NULL,
[DataThroughput_Critical] [int] NULL,
[TimeBase] [int] NULL,
[TimeRange] [int] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [x_SANSwitchPortThresholds_x] ON [dbo].[wtSANSwitchPortThresholds] ([uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[wtSANSwitchPortThresholds] TO [uniadmin]
GRANT INSERT ON  [dbo].[wtSANSwitchPortThresholds] TO [uniadmin]
GRANT DELETE ON  [dbo].[wtSANSwitchPortThresholds] TO [uniadmin]
GRANT UPDATE ON  [dbo].[wtSANSwitchPortThresholds] TO [uniadmin]
GRANT SELECT ON  [dbo].[wtSANSwitchPortThresholds] TO [uniuser]
GRANT SELECT ON  [dbo].[wtSANSwitchPortThresholds] TO [wvadmin]
GRANT INSERT ON  [dbo].[wtSANSwitchPortThresholds] TO [wvadmin]
GRANT DELETE ON  [dbo].[wtSANSwitchPortThresholds] TO [wvadmin]
GRANT UPDATE ON  [dbo].[wtSANSwitchPortThresholds] TO [wvadmin]
GRANT SELECT ON  [dbo].[wtSANSwitchPortThresholds] TO [wvuser]
GO