35 lines
1018 B
Plaintext
35 lines
1018 B
Plaintext
ref,int(11),NO,PRI,,auto_increment
|
|
username,varchar(50),YES,,,
|
|
password,varchar(255),YES,,,
|
|
fullname,varchar(100),YES,,,
|
|
email,varchar(100),YES,,,
|
|
usergroup,int(11),YES,,,
|
|
last_active,datetime,YES,,,
|
|
logged_in,int(11),YES,,,
|
|
last_browser,text,YES,,,
|
|
last_ip,varchar(100),YES,,,
|
|
current_collection,int(11),YES,,,
|
|
accepted_terms,int(11),NO,,0,
|
|
account_expires,datetime,YES,,,
|
|
comments,text,YES,,,
|
|
session,varchar(50),YES,,,
|
|
ip_restrict,text,YES,,,
|
|
search_filter_override,text,YES,,,
|
|
password_last_change,datetime,YES,,,
|
|
login_tries,int(11),NO,,0,
|
|
login_last_try,datetime,YES,,,
|
|
approved,int(11),NO,,1,
|
|
lang,varchar(11),YES,,,
|
|
created,timestamp,YES,,CURRENT_TIMESTAMP,
|
|
hidden_collections,text,YES,,,
|
|
password_reset_hash,varchar(100),YES,,,
|
|
origin,varchar(50),YES,,,
|
|
unique_hash,varchar(50),YES,,,
|
|
csrf_token,varchar(255),YES,,,
|
|
search_filter_o_id,int(11),YES,,,
|
|
profile_image,text,YES,,,
|
|
profile_text,varchar(500),YES,,,
|
|
email_invalid,int(1),YES,,0,
|
|
email_rate_limit_active,int(1),YES,,0,
|
|
processing_messages,text,YES,,,
|