36 lines
2.4 KiB
Plaintext
36 lines
2.4 KiB
Plaintext
Stores all ResourceSpace users.
|
|
ref,int(11),
|
|
username,varchar(50),Username - users use this to log in
|
|
password,varchar(64),One way encrypted password, using hash chaining to support/upgrade old hash algorithms. Can store the password in plain text and it will be encrypted when the user next logs in.
|
|
fullname,varchar(100),User full name - used for display purposes
|
|
email,varchar(100),Email address
|
|
usergroup,int(11),
|
|
last_active,datetime,Date of last ResourceSpace activity
|
|
logged_in,int(11),Is user currently logged in?
|
|
last_browser,text,Browser user agent string
|
|
last_ip,varchar(100),Client IP last used to access ResourceSpace
|
|
current_collection,int(11),ID of current selected collection
|
|
accepted_terms,int(11),Has user accepted terms? (if $terms_login=true)
|
|
account_expires,datetime,Expiration date of account
|
|
comments,text,For admin use
|
|
session,varchar(50),Current session ID
|
|
ip_restrict,text,Only permit access from the given IPs. Uses wildcards instead of CIDR notation i.e. 192.168.*, not 192.168.0/24
|
|
search_filter_override,text,(deprecated) Old search filter string
|
|
password_last_change,datetime,Last password change date
|
|
login_tries,int(11),Number of failed logins
|
|
login_last_try,datetime,Timestamp of last failed login
|
|
approved,int(11),Approval state. 0 = not approved, 1 = approved, 2 = disabled
|
|
lang,varchar(11),User's preferred language code
|
|
created,timestamp,Account creation date
|
|
hidden_collections,text,Comma separated list of hidden collections
|
|
password_reset_hash,varchar(100),Used for password reset links
|
|
origin,varchar(50),Origin of account. Normally 'resourcespace' but may be set by plugins e.g. simplesaml, simpleldap
|
|
unique_hash,varchar(50),Used for antispam code
|
|
csrf_token,varchar(255),Not currently used
|
|
search_filter_o_id,int(11),Search filter ID - overrides any filter set at usergroup level
|
|
profile_image,text,The path to an optional image of the user, uploaded via the My Profile page.
|
|
profile_text,varchar(500),The user's profile text, entered via the My Profile page.
|
|
email_invalid,int(1),Sets that the e-mail is invalid and not to be used - is set externally via the API call mark_email_as_invalid() e.g. from a script processing bounced e-mails.
|
|
email_rate_limit_active,int(1),Sets that the e-mail rate limit is currently active. E-mails will not be sent if this is true.
|
|
processing_messages,text,Message text displayed in overlay when processing data e.g. uploading resources.
|