CREATE TABLE [dbo].[HARUSER]
(
[USROBJID] [int] NOT NULL,
[USERNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[LOGINDATE] [datetime] NULL,
[LASTLOGIN] [datetime] NULL,
[LOGGEDIN] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[REALNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PHONENUMBER] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EXTENSION] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FAXNUMBER] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ENCRYPTPSSWD] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PASSWDATTRS] [int] NOT NULL CONSTRAINT [DF__HARUSER__PASSWDA__0D44F85C] DEFAULT ((0)),
[CREATIONTIME] [datetime] NOT NULL CONSTRAINT [DF__HARUSER__CREATIO__0E391C95] DEFAULT (getutcdate()),
[CREATORID] [int] NOT NULL,
[MODIFIEDTIME] [datetime] NOT NULL CONSTRAINT [DF__HARUSER__MODIFIE__0F2D40CE] DEFAULT (getutcdate()),
[MODIFIERID] [int] NOT NULL,
[EMAIL] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NOTE] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARUSER] ADD CONSTRAINT [HARUSER_PK] PRIMARY KEY CLUSTERED ([USROBJID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [HARUSER_IND] ON [dbo].[HARUSER] ([USERNAME]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'Caption', N'The HARUSER table stores the definition of users.', 'SCHEMA', N'dbo', 'TABLE', N'HARUSER', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was created', 'SCHEMA', N'dbo', 'TABLE', N'HARUSER', 'COLUMN', N'CREATIONTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of creator', 'SCHEMA', N'dbo', 'TABLE', N'HARUSER', 'COLUMN', N'CREATORID'
GO
EXEC sp_addextendedproperty N'Caption', N'Email address of user', 'SCHEMA', N'dbo', 'TABLE', N'HARUSER', 'COLUMN', N'EMAIL'
GO
EXEC sp_addextendedproperty N'Caption', N'Encryption format', 'SCHEMA', N'dbo', 'TABLE', N'HARUSER', 'COLUMN', N'ENCRYPTPSSWD'
GO
EXEC sp_addextendedproperty N'Caption', N'Phone extension of user', 'SCHEMA', N'dbo', 'TABLE', N'HARUSER', 'COLUMN', N'EXTENSION'
GO
EXEC sp_addextendedproperty N'Caption', N'Fax number of user', 'SCHEMA', N'dbo', 'TABLE', N'HARUSER', 'COLUMN', N'FAXNUMBER'
GO
EXEC sp_addextendedproperty N'Caption', N'Time of last login', 'SCHEMA', N'dbo', 'TABLE', N'HARUSER', 'COLUMN', N'LASTLOGIN'
GO
EXEC sp_addextendedproperty N'Caption', N'User logged in (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARUSER', 'COLUMN', N'LOGGEDIN'
GO
EXEC sp_addextendedproperty N'Caption', N'Time of initial login', 'SCHEMA', N'dbo', 'TABLE', N'HARUSER', 'COLUMN', N'LOGINDATE'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was modified', 'SCHEMA', N'dbo', 'TABLE', N'HARUSER', 'COLUMN', N'MODIFIEDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of modifier', 'SCHEMA', N'dbo', 'TABLE', N'HARUSER', 'COLUMN', N'MODIFIERID'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined note', 'SCHEMA', N'dbo', 'TABLE', N'HARUSER', 'COLUMN', N'NOTE'
GO
EXEC sp_addextendedproperty N'Caption', N'Reserved for future use', 'SCHEMA', N'dbo', 'TABLE', N'HARUSER', 'COLUMN', N'PASSWDATTRS'
GO
EXEC sp_addextendedproperty N'Caption', N'Phone number of user', 'SCHEMA', N'dbo', 'TABLE', N'HARUSER', 'COLUMN', N'PHONENUMBER'
GO
EXEC sp_addextendedproperty N'Caption', N'Real name of user', 'SCHEMA', N'dbo', 'TABLE', N'HARUSER', 'COLUMN', N'REALNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of user', 'SCHEMA', N'dbo', 'TABLE', N'HARUSER', 'COLUMN', N'USERNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user', 'SCHEMA', N'dbo', 'TABLE', N'HARUSER', 'COLUMN', N'USROBJID'
GO