CREATE TABLE [dbo].[Audit]
(
[AuditID] [int] NOT NULL IDENTITY(1, 1),
[AccountID] [int] NOT NULL,
[AuditDate] [datetime] NOT NULL,
[Description] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Source] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ContactID] [int] NULL,
[UserIPAddr] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SourceVersion] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExpectedNextSync] [datetime] NULL,
[TaskType] [smallint] NULL,
[RetentionPoliciesHashCode] [int] NULL,
[LocationID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Audit] ADD CONSTRAINT [PK_Audit_AuditID] PRIMARY KEY CLUSTERED ([AuditID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Audit] ADD CONSTRAINT [FK_Audit_AccountID_Account_AccountID] FOREIGN KEY ([AccountID]) REFERENCES [dbo].[Account] ([AccountID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Audit] ADD CONSTRAINT [FK_Audit_ContactID_Contact_ContactID] FOREIGN KEY ([ContactID]) REFERENCES [dbo].[Contact] ([ContactID])
GO
ALTER TABLE [dbo].[Audit] ADD CONSTRAINT [FK_Audit_LocationID_AccountLocation_LocationID] FOREIGN KEY ([LocationID]) REFERENCES [dbo].[AccountLocation] ([LocationID])
GO