CREATE TABLE [dbo].[HARUSERDATA]
(
[USROBJID] [int] NOT NULL,
[ENCRYPTPSSWD] [image] NULL,
[MAXAGE] [int] NOT NULL CONSTRAINT [DF__HARUSERDA__MAXAG__13F1F5EB] DEFAULT ((-2)),
[FAILURES] [int] NOT NULL CONSTRAINT [DF__HARUSERDA__FAILU__14E61A24] DEFAULT ((0)),
[PSSWDTIME] [datetime] NOT NULL CONSTRAINT [DF__HARUSERDA__PSSWD__15DA3E5D] DEFAULT (getutcdate()),
[ACCOUNTEXTERNAL] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARUSERDA__ACCOU__16CE6296] DEFAULT ('N'),
[SWLOGIN] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARUSERDA__SWLOG__17C286CF] DEFAULT ('N'),
[ACCOUNTLOCKED] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARUSERDA__ACCOU__18B6AB08] DEFAULT ('N'),
[ACCOUNTDISABLED] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARUSERDA__ACCOU__19AACF41] DEFAULT ('N')
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARUSERDATA] ADD CONSTRAINT [HARUSERDATA_PK] PRIMARY KEY CLUSTERED ([USROBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARUSERDATA] ADD CONSTRAINT [HARUSERDATA_FK] FOREIGN KEY ([USROBJID]) REFERENCES [dbo].[HARALLUSERS] ([USROBJID])
GO
ALTER TABLE [dbo].[HARUSERDATA] ADD CONSTRAINT [HARUSERDATA_USRID_FK] FOREIGN KEY ([USROBJID]) REFERENCES [dbo].[HARUSER] ([USROBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARUSERDATA table stores the user data for all active users. ', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERDATA', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Y = The user account is disabled. N (Default) = The user account is not disabled.', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERDATA', 'COLUMN', N'ACCOUNTDISABLED'
GO
EXEC sp_addextendedproperty N'Caption', N'Y = The user account is external. N (Default) = The user account is internal.', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERDATA', 'COLUMN', N'ACCOUNTEXTERNAL'
GO
EXEC sp_addextendedproperty N'Caption', N'Y = The internal account is locked. N (Default) = The internal account is unlocked.', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERDATA', 'COLUMN', N'ACCOUNTLOCKED'
GO
EXEC sp_addextendedproperty N'Caption', N'Encrypted password', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERDATA', 'COLUMN', N'ENCRYPTPSSWD'
GO
EXEC sp_addextendedproperty N'Caption', N'Number of consecutive password-related login failures', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERDATA', 'COLUMN', N'FAILURES'
GO
EXEC sp_addextendedproperty N'Caption', N'User-level override for password rule', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERDATA', 'COLUMN', N'MAXAGE'
GO
EXEC sp_addextendedproperty N'Caption', N'Password creation time', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERDATA', 'COLUMN', N'PSSWDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Y = The user account may not have multiple CA SCM sessions running on more than one workstation for the same broker.; N (Default) = The user account has no restrictions for running multiple CA SCM sessions on different workstations.', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERDATA', 'COLUMN', N'SWLOGIN'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user', 'SCHEMA', N'dbo', 'TABLE', N'HARUSERDATA', 'COLUMN', N'USROBJID'
GO