CREATE TABLE [dbo].[haruserdata]
(
[usrobjid] [int] NOT NULL,
[encryptpsswd] [image] NULL,
[failures] [int] NOT NULL CONSTRAINT [DF__haruserda__failu__646DCB52] DEFAULT ((0)),
[psswdtime] [datetime] NULL,
[maxage] [int] NULL CONSTRAINT [DF__haruserda__maxag__6561EF8B] DEFAULT ((-2)),
[AccountExternal] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__haruserda__Accou__50F27938] DEFAULT ('N'),
[SWLogin] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__haruserda__SWLog__06E47595] DEFAULT ('N'),
[AccountDisabled] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__haruserda__Accou__07D899CE] DEFAULT ('N'),
[AccountLocked] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__haruserda__Accou__08CCBE07] DEFAULT ('N')
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[haruserdata] ADD CONSTRAINT [HARUSERDATA_PK] PRIMARY KEY CLUSTERED ([usrobjid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [baseidx_haruserdata] ON [dbo].[haruserdata] ([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
GRANT SELECT ON  [dbo].[haruserdata] TO [harvest_group]
GRANT INSERT ON  [dbo].[haruserdata] TO [harvest_group]
GRANT DELETE ON  [dbo].[haruserdata] TO [harvest_group]
GRANT UPDATE ON  [dbo].[haruserdata] TO [harvest_group]
GRANT SELECT ON  [dbo].[haruserdata] TO [harvest_rep]
GO