-
Notifications
You must be signed in to change notification settings - Fork 2
BD Table: users
Cedric AUDRIT edited this page Dec 9, 2020
·
3 revisions
| COLUMN | TYPE (MYSQL) | CONTENT |
|---|---|---|
| user_id | int | primary key |
| user_name | varchar(30) | user alias (display name) |
| user_pass | varchar(255) | user password HASHED |
| user_fname | varchar(64) | user First Name |
| user_lname | varchar(64) | user Last Name |
| user_email | varchar(255) | user email address |
| user_sign | varchar(255) | user signature for post |
| user_image | varchar(255) | url of pictures to user as avatar |
| user_imgdata | mediumblob | USE for store user picture |
| user_gravatar | varchar(255) | gravatar url (auto generate) |
| user_imglocal | varchar(255) | uploaded file url |
| user_online | tinyint(1) | set to 1 if user online 0 to offline |
| user_date | datetime | date of registry |
| user_level | tinyint | permission lvl (0=guest, 1=user, 2=moderator, 3=admin, 4=god |
| user_token | mediumint | for activation link |
| user_token2 | int | for password recovery by mail |
| user_datebirthday | date | date of Bird day |
| user_datelastlog | datetime | last update date done by user |
| user_secquest | varchar(255) | Secret question for password recovery |
| user_secansw | varchar(255) | answer of secret question pwd recovery |
| user_active | tinyint(1) | NOT USE for activation link |
| user_ban_by | int | user how have made the BAN |
| user_last_ip | varchar(255) | last ip of user (update at login) |
| user_theme | tinyint(1) | for theme selection |
| user_imgtype | varchar(25) | normally for mime type (but all pic are webp |
| user_lastsee | datetime | for check if user is connected |