CREATE TABLE [dbo].[QueueServiceQueueExport]
(
[QueueServiceQueueExportID] [int] NOT NULL IDENTITY(1, 1),
[QueueServiceSetupFID] [int] NOT NULL,
[QueueServiceMessageTypeFID] [int] NOT NULL,
[Inactive] [bit] NOT NULL CONSTRAINT [DF_QueueServiceQueueExport_Inactive] DEFAULT ((0)),
[ExportPath] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DisableProcessing] [bit] NOT NULL CONSTRAINT [DF_QueueServiceQueueExport_DisableProcessing] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[QueueServiceQueueExport] ADD CONSTRAINT [PK_QueueServiceQueueExport] PRIMARY KEY CLUSTERED  ([QueueServiceQueueExportID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[QueueServiceQueueExport] ADD CONSTRAINT [IX_QueueServiceQueueExport_QueueServiceSetupFID_QueueServiceMessageTypeFID] UNIQUE NONCLUSTERED  ([QueueServiceSetupFID], [QueueServiceMessageTypeFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[QueueServiceQueueExport] ADD CONSTRAINT [FK_QueueServiceQueueExport_QueueServiceMessageType] FOREIGN KEY ([QueueServiceMessageTypeFID]) REFERENCES [dbo].[QueueServiceMessageType] ([QueueServiceMessageTypeID])
GO
ALTER TABLE [dbo].[QueueServiceQueueExport] ADD CONSTRAINT [FK_QueueServiceQueueExport_QueueServiceSetup] FOREIGN KEY ([QueueServiceSetupFID]) REFERENCES [dbo].[QueueServiceSetup] ([QueueServiceSetupID])
GO
GRANT SELECT ON  [dbo].[QueueServiceQueueExport] TO [MssExec]
GRANT INSERT ON  [dbo].[QueueServiceQueueExport] TO [MssExec]
GRANT DELETE ON  [dbo].[QueueServiceQueueExport] TO [MssExec]
GRANT UPDATE ON  [dbo].[QueueServiceQueueExport] TO [MssExec]
GO