CREATE TABLE [dbo].[HARPASSWORDPOLICY]
(
[MAXAGE] [int] NOT NULL CONSTRAINT [DF__HARPASSWO__MAXAG__2645B050] DEFAULT ((-1)),
[MINAGE] [int] NOT NULL CONSTRAINT [DF__HARPASSWO__MINAG__2739D489] DEFAULT ((0)),
[MINLEN] [int] NOT NULL CONSTRAINT [DF__HARPASSWO__MINLE__282DF8C2] DEFAULT ((6)),
[REUSERULE] [int] NOT NULL CONSTRAINT [DF__HARPASSWO__REUSE__29221CFB] DEFAULT ((0)),
[MAXFAILURES] [int] NOT NULL CONSTRAINT [DF__HARPASSWO__MAXFA__2A164134] DEFAULT ((-1)),
[ALLOWUSRCHGEXP] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARPASSWO__ALLOW__2B0A656D] DEFAULT ('Y'),
[WARNINGAGE] [int] NOT NULL CONSTRAINT [DF__HARPASSWO__WARNI__2BFE89A6] DEFAULT ((-1)),
[CHREPETITION] [int] NOT NULL CONSTRAINT [DF__HARPASSWO__CHREP__2CF2ADDF] DEFAULT ((-1)),
[MINNUMERIC] [int] NOT NULL CONSTRAINT [DF__HARPASSWO__MINNU__2DE6D218] DEFAULT ((0)),
[LOWERCASE] [int] NOT NULL CONSTRAINT [DF__HARPASSWO__LOWER__2EDAF651] DEFAULT ((0)),
[UPPERCASE] [int] NOT NULL CONSTRAINT [DF__HARPASSWO__UPPER__2FCF1A8A] DEFAULT ((0)),
[NONALPHANUM] [int] NOT NULL CONSTRAINT [DF__HARPASSWO__NONAL__30C33EC3] DEFAULT ((0)),
[ALLOWUSERNAME] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARPASSWO__ALLOW__31B762FC] DEFAULT ('Y'),
[MODIFIEDTIME] [datetime] NOT NULL CONSTRAINT [DF__HARPASSWO__MODIF__32AB8735] DEFAULT (getutcdate()),
[MODIFIERID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARPASSWORDPOLICY] ADD CONSTRAINT [HARPASSWORDPOLICY_MODID_FK] FOREIGN KEY ([MODIFIERID]) REFERENCES [dbo].[HARALLUSERS] ([USROBJID])
GO
EXEC sp_addextendedproperty N'Caption', N'The HARPASSWORDPOLICY table stores the password policy settings for both global and users overrides. ', 'SCHEMA', N'dbo', 'TABLE', N'HARPASSWORDPOLICY', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Allow user name as password (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARPASSWORDPOLICY', 'COLUMN', N'ALLOWUSERNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Users may change own expired passwords (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARPASSWORDPOLICY', 'COLUMN', N'ALLOWUSRCHGEXP'
GO
EXEC sp_addextendedproperty N'Caption', N'Maximum length of repeated characters in password', 'SCHEMA', N'dbo', 'TABLE', N'HARPASSWORDPOLICY', 'COLUMN', N'CHREPETITION'
GO
EXEC sp_addextendedproperty N'Caption', N'Minimum number of lower-case characters', 'SCHEMA', N'dbo', 'TABLE', N'HARPASSWORDPOLICY', 'COLUMN', N'LOWERCASE'
GO
EXEC sp_addextendedproperty N'Caption', N'Maximum password age in days', 'SCHEMA', N'dbo', 'TABLE', N'HARPASSWORDPOLICY', 'COLUMN', N'MAXAGE'
GO
EXEC sp_addextendedproperty N'Caption', N'Number of failures in lockout rule', 'SCHEMA', N'dbo', 'TABLE', N'HARPASSWORDPOLICY', 'COLUMN', N'MAXFAILURES'
GO
EXEC sp_addextendedproperty N'Caption', N'Minimum password age in days', 'SCHEMA', N'dbo', 'TABLE', N'HARPASSWORDPOLICY', 'COLUMN', N'MINAGE'
GO
EXEC sp_addextendedproperty N'Caption', N'Minimum password length', 'SCHEMA', N'dbo', 'TABLE', N'HARPASSWORDPOLICY', 'COLUMN', N'MINLEN'
GO
EXEC sp_addextendedproperty N'Caption', N'Minimum number of numeric characters', 'SCHEMA', N'dbo', 'TABLE', N'HARPASSWORDPOLICY', 'COLUMN', N'MINNUMERIC'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was modified', 'SCHEMA', N'dbo', 'TABLE', N'HARPASSWORDPOLICY', 'COLUMN', N'MODIFIEDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of modifier', 'SCHEMA', N'dbo', 'TABLE', N'HARPASSWORDPOLICY', 'COLUMN', N'MODIFIERID'
GO
EXEC sp_addextendedproperty N'Caption', N'Minimum number of nonalphanumeric characters', 'SCHEMA', N'dbo', 'TABLE', N'HARPASSWORDPOLICY', 'COLUMN', N'NONALPHANUM'
GO
EXEC sp_addextendedproperty N'Caption', N'Number of passwords in reuse rule', 'SCHEMA', N'dbo', 'TABLE', N'HARPASSWORDPOLICY', 'COLUMN', N'REUSERULE'
GO
EXEC sp_addextendedproperty N'Caption', N'Minimum number of uppercase characters', 'SCHEMA', N'dbo', 'TABLE', N'HARPASSWORDPOLICY', 'COLUMN', N'UPPERCASE'
GO
EXEC sp_addextendedproperty N'Caption', N'Password age at which to start warning message', 'SCHEMA', N'dbo', 'TABLE', N'HARPASSWORDPOLICY', 'COLUMN', N'WARNINGAGE'
GO