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)

This table is empty by default.

Please see the schema overview for context. This document was last updated on the 23rd of November 2020 at 16:35 (Europe/London time).