CREATE TABLE [dbo].[AccountPasswordPolicies]
(
[AccountID] [int] NOT NULL,
[ExpirationDays] [int] NULL,
[MinimumLength] [int] NULL,
[NumberOfNonAlpha] [int] NULL,
[MaxInvalidPasswordAttempts] [int] NULL,
[PasswordAttemptWindow] [int] NULL,
[PasswordForNewContacts] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AccountPasswordPolicies] ADD CONSTRAINT [PK_AccountPasswordPolicies_AccountID] PRIMARY KEY CLUSTERED ([AccountID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AccountPasswordPolicies] ADD CONSTRAINT [FK_AccountPasswordPolicies_AccountID_Account_AccountID] FOREIGN KEY ([AccountID]) REFERENCES [dbo].[Account] ([AccountID]) ON DELETE CASCADE
GO