CREATE TABLE [dbo].[QueueServiceCustomTransform]
(
[QueueServiceCustomTransformId] [int] NOT NULL IDENTITY(1, 1),
[QueueServiceMessageTypeFid] [int] NOT NULL,
[AppDomainName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TypeName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AssemblyBytes] [varbinary] (max) NOT NULL,
[IsPreTransform] [bit] NOT NULL CONSTRAINT [DF_QueueServiceCustomTransform_IsPreTransform] DEFAULT ((0))
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[QueueServiceCustomTransform] ADD CONSTRAINT [PK_QueueServiceCustomTransform] PRIMARY KEY NONCLUSTERED  ([QueueServiceCustomTransformId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[QueueServiceCustomTransform] ADD CONSTRAINT [IX_QueueServiceCustomTransform_QueueServiceMessageType_IsPreTransform] UNIQUE NONCLUSTERED  ([QueueServiceMessageTypeFid], [IsPreTransform]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[QueueServiceCustomTransform] ADD CONSTRAINT [FK_QueueServiceCustomTransform_QueueServiceMessageType] FOREIGN KEY ([QueueServiceMessageTypeFid]) REFERENCES [dbo].[QueueServiceMessageType] ([QueueServiceMessageTypeID])
GO
GRANT SELECT ON  [dbo].[QueueServiceCustomTransform] TO [MssExec]
GRANT INSERT ON  [dbo].[QueueServiceCustomTransform] TO [MssExec]
GRANT DELETE ON  [dbo].[QueueServiceCustomTransform] TO [MssExec]
GRANT UPDATE ON  [dbo].[QueueServiceCustomTransform] TO [MssExec]
GO