CREATE TABLE [dbo].[MoversConnectStatus]
(
[MoversConnectStatusID] [int] NOT NULL IDENTITY(1, 1),
[MoversConnectPollerFID] [int] NOT NULL,
[ServiceStarted] [datetime] NULL,
[ServiceStopped] [datetime] NULL,
[LastMessage] [datetime] NULL,
[LastMessageIDReceived] [bigint] NULL,
[LastMessageIDAcked] [bigint] NULL,
[CountersResetDate] [datetime] NOT NULL,
[MessagesReceived] [bigint] NOT NULL,
[MessagesProcessed] [bigint] NOT NULL,
[ErrorsHandled] [bigint] NOT NULL,
[ProcessingTimeUnits] [bigint] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MoversConnectStatus] ADD CONSTRAINT [PK_MoversConnectStatus] PRIMARY KEY NONCLUSTERED  ([MoversConnectStatusID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MoversConnectStatus] ADD CONSTRAINT [IX_MoversConnectStatus_MoversConnectPoller] UNIQUE NONCLUSTERED  ([MoversConnectPollerFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MoversConnectStatus] ADD CONSTRAINT [FK_MoversConnectStatus_MoversConnectPoller] FOREIGN KEY ([MoversConnectPollerFID]) REFERENCES [dbo].[MoversConnectPoller] ([MoversConnectPollerID])
GO
GRANT SELECT ON  [dbo].[MoversConnectStatus] TO [MssExec]
GRANT INSERT ON  [dbo].[MoversConnectStatus] TO [MssExec]
GRANT DELETE ON  [dbo].[MoversConnectStatus] TO [MssExec]
GRANT UPDATE ON  [dbo].[MoversConnectStatus] TO [MssExec]
GO