CREATE TABLE [dbo].[DataSync]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[DataSyncDefID] [int] NOT NULL,
[StartDate] [datetime] NOT NULL,
[EndDate] [datetime] NULL,
[StartedBy] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Status] [tinyint] NOT NULL CONSTRAINT [DF_DataSync_Status] DEFAULT ((0)),
[StatusMessage] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AccountsRequested] [int] NULL,
[AccountsMatched] [int] NULL,
[AccountsUpdated] [int] NULL,
[DevicesRequested] [int] NULL,
[DevicesMatched] [int] NULL,
[DevicesUpdated] [int] NULL,
[MetersRequested] [int] NULL,
[MetersMatched] [int] NULL,
[MetersSubmitted] [int] NULL,
[ResultsEmailStatus] [tinyint] NULL,
[ResultsEmailDetails] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DataSync] ADD CONSTRAINT [PK_DataSync_ID] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DataSync] ADD CONSTRAINT [FK_DataSync_DataSyncDefID_DataSyncDef_ID] FOREIGN KEY ([DataSyncDefID]) REFERENCES [dbo].[DataSyncDef] ([ID]) ON DELETE CASCADE
GO