[dbo].[HARPASSWORDHISTORY]

Property	Value
Row Count	0
Created	5:00:01 AM Monday, March 02, 2009
Last Modified	5:00:27 AM Monday, March 02, 2009

	Name	Data Type	Max Length (Bytes)	Allow Nulls
	USROBJID	int	4
	PREVPSSWDS	image	max

	Name	Columns	Unique
	HARPASSWORDHISTORY_PK	USROBJID

Name	Delete	Columns
HARPASSWORDHISTORY_FK	Cascade	USROBJID->[dbo].[HARUSER].[USROBJID]

Name	Level 2 Type	Level 2 Name	Value
Caption			The HARPASSWORDHISTORY table stores the previously used passwords for the given UserObjId.
Caption	COLUMN	PREVPSSWDS	Previous password
Caption	COLUMN	USROBJID	Object ID of user

SQL Script

CREATE TABLE [dbo].[HARPASSWORDHISTORY]
(
[USROBJID] [int] NOT NULL,
[PREVPSSWDS] [image] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARPASSWORDHISTORY] ADD CONSTRAINT [HARPASSWORDHISTORY_PK] PRIMARY KEY CLUSTERED ([USROBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARPASSWORDHISTORY] ADD CONSTRAINT [HARPASSWORDHISTORY_FK] FOREIGN KEY ([USROBJID]) REFERENCES [dbo].[HARUSER] ([USROBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARPASSWORDHISTORY table stores the previously used passwords for the given UserObjId. ', 'SCHEMA', N'dbo', 'TABLE', N'HARPASSWORDHISTORY', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Previous password', 'SCHEMA', N'dbo', 'TABLE', N'HARPASSWORDHISTORY', 'COLUMN', N'PREVPSSWDS'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user', 'SCHEMA', N'dbo', 'TABLE', N'HARPASSWORDHISTORY', 'COLUMN', N'USROBJID'
GO