CREATE TABLE [dbo].[harpasswordpolicy]
(
[maxage] [int] NOT NULL CONSTRAINT [DF__harpasswo__maxag__78A9CE29] DEFAULT ((-1)),
[minage] [int] NOT NULL CONSTRAINT [DF__harpasswo__minag__799DF262] DEFAULT ((0)),
[minlen] [int] NOT NULL CONSTRAINT [DF__harpasswo__minle__7A92169B] DEFAULT ((6)),
[reuserule] [int] NOT NULL CONSTRAINT [DF__harpasswo__reuse__7B863AD4] DEFAULT ((0)),
[maxfailures] [int] NOT NULL CONSTRAINT [DF__harpasswo__maxfa__7C7A5F0D] DEFAULT ((-1)),
[allowusrchgexp] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__harpasswo__allow__7D6E8346] DEFAULT ('Y'),
[warningage] [int] NOT NULL CONSTRAINT [DF__harpasswo__warni__7E62A77F] DEFAULT ((-1)),
[chrepetition] [int] NOT NULL CONSTRAINT [DF__harpasswo__chrep__7F56CBB8] DEFAULT ((-1)),
[minnumeric] [int] NOT NULL CONSTRAINT [DF__harpasswo__minnu__004AEFF1] DEFAULT ((0)),
[lowercase] [int] NOT NULL CONSTRAINT [DF__harpasswo__lower__013F142A] DEFAULT ((0)),
[uppercase] [int] NOT NULL CONSTRAINT [DF__harpasswo__upper__02333863] DEFAULT ((0)),
[nonalphanum] [int] NOT NULL CONSTRAINT [DF__harpasswo__nonal__03275C9C] DEFAULT ((0)),
[allowusername] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__harpasswo__allow__041B80D5] DEFAULT ('Y'),
[modifiedtime] [datetime] NOT NULL,
[modifierid] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[harpasswordpolicy] ADD CONSTRAINT [harpasswordpolicy_modid_fk] FOREIGN KEY ([modifierid]) REFERENCES [dbo].[harallusers] ([usrobjid])
GO
GRANT SELECT ON  [dbo].[harpasswordpolicy] TO [harvest_group]
GRANT INSERT ON  [dbo].[harpasswordpolicy] TO [harvest_group]
GRANT DELETE ON  [dbo].[harpasswordpolicy] TO [harvest_group]
GRANT UPDATE ON  [dbo].[harpasswordpolicy] TO [harvest_group]
GRANT SELECT ON  [dbo].[harpasswordpolicy] TO [harvest_rep]
GO