CREATE TABLE [dbo].[XLedgerHiddenSubledger]
(
[XLedgerHiddenSubledgerId] [int] NOT NULL IDENTITY(1, 1),
[XLedgerDbId] [bigint] NOT NULL,
[XLedgerSubledgerDbId] [bigint] NOT NULL,
[XLedgerSyncHistoryFid] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XLedgerHiddenSubledger] ADD CONSTRAINT [PK_XLedgerHiddenSubledger] PRIMARY KEY NONCLUSTERED  ([XLedgerHiddenSubledgerId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XLedgerHiddenSubledger] ADD CONSTRAINT [IX_XLedgerHiddenSubledger_XLedgerDbId] UNIQUE CLUSTERED  ([XLedgerDbId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XLedgerHiddenSubledger] ADD CONSTRAINT [IX_XLedgerHiddenSubledger_XLedgerSubledgerDbId] UNIQUE NONCLUSTERED  ([XLedgerSubledgerDbId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XLedgerHiddenSubledger] ADD CONSTRAINT [FK_XLedgerHiddenSubledger_XLedgerSyncHistory] FOREIGN KEY ([XLedgerSyncHistoryFid]) REFERENCES [dbo].[XLedgerSyncHistory] ([XLedgerSyncHistoryId]) ON DELETE SET NULL
GO
GRANT SELECT ON  [dbo].[XLedgerHiddenSubledger] TO [MssExec]
GRANT INSERT ON  [dbo].[XLedgerHiddenSubledger] TO [MssExec]
GRANT DELETE ON  [dbo].[XLedgerHiddenSubledger] TO [MssExec]
GRANT UPDATE ON  [dbo].[XLedgerHiddenSubledger] TO [MssExec]
GO