| ref |
int(11)
|
|
|
|
| username |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| password |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| fullname |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| email |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| usergroup |
int(11)
|
|
|
|
| last_active |
datetime
|
|
|
|
| logged_in |
int(11)
|
|
|
|
| last_browser |
text
|
utf8mb4_general_ci
|
|
|
| last_ip |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| current_collection |
int(11)
|
|
|
|
| accepted_terms |
int(11)
|
|
|
|
| account_expires |
datetime
|
|
|
|
| comments |
text
|
utf8mb4_general_ci
|
|
|
| session |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| ip_restrict |
text
|
utf8mb4_general_ci
|
|
|
| search_filter_override |
text
|
utf8mb4_general_ci
|
|
|
| password_last_change |
datetime
|
|
|
|
| login_tries |
int(11)
|
|
|
|
| login_last_try |
datetime
|
|
|
|
| approved |
int(11)
|
|
|
|
| lang |
varchar(11)
|
utf8mb4_general_ci
|
|
|
| created |
timestamp
|
|
|
|
| hidden_collections |
text
|
utf8mb4_general_ci
|
|
|
| password_reset_hash |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| origin |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| unique_hash |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| csrf_token |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| search_filter_o_id |
int(11)
|
|
|
|
| profile_image |
text
|
utf8mb4_general_ci
|
|
|
| profile_text |
varchar(500)
|
utf8mb4_general_ci
|
|
|
| email_invalid |
int(1)
|
|
|
|
| email_rate_limit_active |
int(1)
|
|
|
|
| processing_messages |
text
|
utf8mb4_general_ci
|
|
|
