Name

Type

Idx?

Description

id

integer

primary key

not null

yes

Unique id for the user. User id 1 is reserved for the sysop, and cannot be deleted.

access

integer

no

Access level for the WebHare interface

0: normal user

500: power user

1000: sysop

authinfo

varchar(4096)

no

Field for additional authentication information, for use by authentication scripts.

creationdate

datetime

no

Time this user was created. Contains a default datetime value for users created in older WebHare AP versions.

dateformat

integer

no

The date format selected by this user:

100=DD-MM-YYYY, 200=MM/DD/YYYY, 300=MM-DD-YYYY, 400=MM/DD/YYYY

description

varchar (1024)

no

Free space for any user-defined description of the manager (can be used for address, telephone number, etc).

disable

boolean

no

If true, this manager’s account is disabled.

email

varchar (256)

no

Email address.

language

varchar (256)

no

Language to show the WebHare interface in

login

varchar (64)

not null

no

Manager’s login name (handle). This name is case-sensitive.

publisher_access

integer

no

Access level to the Publisher module

0: normal user

1000: can create new sites

realname

varchar (256)

no

Real, full name.

skin

varchar (256)

no

Skin to show the WebHare interface in

timeformat

integer

no

The time format selected by this uers:

100=military time (24-hour clock), 200=am/pm (12-hour clock)

unit

integer

foreign key

not null

yes

Refers to system_units.id. Tthe unit this user belongs to.

userpassword

password

no

Manager’s password. The password is hashed (using the MD5 algorithm) before storage. It can not be directly recovered