CREATE TABLE [dbo].[ConsolidationProcessInfo]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[Enabled] [bit] NULL,
[ProcessStatus] [tinyint] NULL,
[StartDate] [datetime] NULL,
[RunningTime] [bigint] NULL,
[ResumeCounts] [int] NULL,
[ProcessedAccounts] [int] NULL,
[ProcessedDevices] [int] NULL,
[FirstConsolidationOccurred] [bit] NULL,
[FirstConsolidationAdminNotificationShown] [bit] NULL,
[FirstConsolidationAdminNotificationDismissed] [bit] NULL,
[CurrentDataRetentionPolicies] [xml] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ConsolidationProcessInfo] ADD CONSTRAINT [PK_ConsolidationProcessInfo_ID] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'RunTime in seconds', 'SCHEMA', N'dbo', 'TABLE', N'ConsolidationProcessInfo', 'COLUMN', N'RunningTime'
GO