CREATE TABLE [dbo].[QueueServiceSetup]
(
[QueueServiceSetupID] [int] NOT NULL IDENTITY(1, 1),
[QueueServiceName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TransferedFromCustomerBuild] [bit] NOT NULL CONSTRAINT [DF_QueueServiceSetup_TransferedFromCustomerBuild] DEFAULT ((0)),
[TrusteeName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TrusteeSystemName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TrusteeType] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SaveMessageData] [bit] NOT NULL CONSTRAINT [DF_QueueServiceSetup_SaveMessageData] DEFAULT ((0)),
[SaveXmlFilesPath] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DiscardFirstMsgIfBad] [bit] NOT NULL CONSTRAINT [DF_QueueServiceSetup_DiscardFirstMsgIfBad] DEFAULT ((0)),
[DiscardAllBadMessages] [bit] NOT NULL CONSTRAINT [DF_QueueServiceSetup_DiscardAllBadMessages] DEFAULT ((0)),
[BadMessagesFolder] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ThreadSleepTime] [int] NOT NULL CONSTRAINT [DF_QueueServiceSetup_ThreadSleepTime] DEFAULT ((5000)),
[MessageWaitTime] [int] NOT NULL CONSTRAINT [DF_QueueServiceSetup_MessageWaitTime] DEFAULT ((5000)),
[MaxMessageRetryCount] [int] NOT NULL CONSTRAINT [DF_QueueServiceSetup_MaxMessageRetryCount] DEFAULT ((5)),
[CommandTimeoutSeconds] [int] NOT NULL CONSTRAINT [DF_QueueServiceSetup_CommandTimeoutSeconds] DEFAULT ((30))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[QueueServiceSetup] ADD CONSTRAINT [PK_QueueServiceSetup] PRIMARY KEY CLUSTERED  ([QueueServiceSetupID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[QueueServiceSetup] ADD CONSTRAINT [IX_QueueServiceSetup_QueueServiceName] UNIQUE NONCLUSTERED  ([QueueServiceName]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[QueueServiceSetup] TO [MssExec]
GRANT INSERT ON  [dbo].[QueueServiceSetup] TO [MssExec]
GRANT DELETE ON  [dbo].[QueueServiceSetup] TO [MssExec]
GRANT UPDATE ON  [dbo].[QueueServiceSetup] TO [MssExec]
GO