CREATE TABLE [dbo].[DeviceAuditSummary]
(
[DeviceID] [int] NOT NULL,
[AuditDate] [datetime] NOT NULL,
[Source] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SourceVersion] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Meters] [bit] NULL,
[Supplies] [bit] NULL,
[Status] [bit] NULL,
[Service] [bit] NULL,
[Agent] [bit] NULL,
[LocationID] [int] NOT NULL,
[UserData] [bit] NULL,
[HpMeters] [bit] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DeviceAuditSummary] ADD CONSTRAINT [PK_DeviceAuditSummary_DeviceID_AuditDate_Source_SourceVersion_LocationID] PRIMARY KEY CLUSTERED ([DeviceID], [AuditDate], [Source], [SourceVersion], [LocationID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DeviceAuditSummary] ADD CONSTRAINT [FK_DeviceAuditSummary_DeviceID_Device_DeviceID] FOREIGN KEY ([DeviceID]) REFERENCES [dbo].[Device] ([DeviceID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[DeviceAuditSummary] ADD CONSTRAINT [FK_DeviceAuditSummary_LocationID_AccountLocation_LocationID] FOREIGN KEY ([LocationID]) REFERENCES [dbo].[AccountLocation] ([LocationID])
GO