CREATE TABLE [dbo].[XLedgerTransactionUploadFailureSysUserMap]
(
[XLedgerTransactionUploadFailureSysUserMapId] [int] NOT NULL IDENTITY(1, 1),
[SysUserFid] [int] NOT NULL,
[XLedgerTransactionUploadFailureFid] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XLedgerTransactionUploadFailureSysUserMap] ADD CONSTRAINT [PK_XLedgerTransactionUploadFailureSysUserMap] PRIMARY KEY CLUSTERED  ([XLedgerTransactionUploadFailureSysUserMapId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XLedgerTransactionUploadFailureSysUserMap] ADD CONSTRAINT [IX_XLedgerTransactionUploadFailureSysUserMap_SysUserFid_XLedgerTransactionUploadFailureFid] UNIQUE NONCLUSTERED  ([SysUserFid], [XLedgerTransactionUploadFailureFid] DESC) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_XLedgerTransactionUploadFailureSysUserMap_SysUser_Failure] ON [dbo].[XLedgerTransactionUploadFailureSysUserMap] ([SysUserFid], [XLedgerTransactionUploadFailureFid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XLedgerTransactionUploadFailureSysUserMap] ADD CONSTRAINT [FK_XLedgerTransactionUploadFailureSysUserMap_SysUser] FOREIGN KEY ([SysUserFid]) REFERENCES [dbo].[Sysuser] ([SysUserID])
GO
ALTER TABLE [dbo].[XLedgerTransactionUploadFailureSysUserMap] ADD CONSTRAINT [FK_XLedgerTransactionUploadFailureSysUserMap_XLedgerTransactionUploadFailure] FOREIGN KEY ([XLedgerTransactionUploadFailureFid]) REFERENCES [dbo].[XLedgerTransactionUploadFailure] ([XLedgerTransactionUploadFailureId])
GO
GRANT SELECT ON  [dbo].[XLedgerTransactionUploadFailureSysUserMap] TO [MssExec]
GRANT INSERT ON  [dbo].[XLedgerTransactionUploadFailureSysUserMap] TO [MssExec]
GRANT DELETE ON  [dbo].[XLedgerTransactionUploadFailureSysUserMap] TO [MssExec]
GRANT UPDATE ON  [dbo].[XLedgerTransactionUploadFailureSysUserMap] TO [MssExec]
GO