Collections functions
Encryption functions
General functions
Render functions
Theme permission functions
Video functions
Resource functions

Table: user

Stores all ResourceSpace users.

ColumnTypeNote
refint(11)Auto incrementing index
usernamevarchar(50)
passwordvarchar(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.
fullnamevarchar(100)
emailvarchar(100)
usergroupint(11)See table usergroup
last_activedatetime
logged_inint(11)
last_browsertext
last_ipvarchar(100)
current_collectionint(11)
accepted_termsint(11)
account_expiresdatetime
commentstext
sessionvarchar(50)
ip_restricttext
search_filter_overridetext
password_last_changedatetime
login_triesint(11)
login_last_trydatetime
approvedint(11)
langvarchar(11)
createdtimestamp
hidden_collectionstext
password_reset_hashvarchar(100)
originvarchar(50)
unique_hashvarchar(50)
csrf_tokenvarchar(255)
search_filter_o_idint(11)
profile_imagetextThe path to an optional image of the user, uploaded via the My Profile page.
profile_textvarchar(500)The user's profile text, entered via the My Profile page.

This table is empty by default.

Please see the schema overview for context. This document was last updated on the 12th of May 2021 at 06:05 (Europe/London time).