fud30_users - fudforum/FUDforum GitHub Wiki
Description of FUDforum table fud30_users. This table contains the forum's users with their details and preferences. For more information, see Moderator/User Manager, Add User and Merge Users.
| Column Name | Datatype | Can be Null? | Key? | Default | Description |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | - | auto_increment |
| login | varchar(50) | NO | UNI | - | User's login ID. |
| alias | varchar(50) | NO | UNI | - | User alias. |
| passwd | varchar(32) | NO | - | - | User's password (encrypted). |
| salt | varchar(32) | NO | - | - | Password salt. (Added in FUDforum 3.0.1). |
| name | varchar(255) | NO | - | - | User's name. |
| varchar(255) | NO | UNI | - | User's e-mail address. | |
| location | varchar(255) | YES | - | - | |
| interests | varchar(255) | YES | - | - | |
| occupation | varchar(255) | YES | - | - | |
| avatar | int(11) | NO | - | 0 | References fud30_avatar.id. |
| avatar_loc | varchar(512) | YES | - | - | Avatar location. Changed from TEXT to VARCHAR(512) in FUDforum 3.0.2. |
| icq | bigint(20) | YES | - | - | ICQ handle. |
| aim | varchar(255) | YES | - | - | AIM handle. |
| yahoo | varchar(255) | YES | - | - | Yahoo handle. |
| msnm | varchar(255) | YES | - | - | MSN Messenger handle. |
| jabber | varchar(255) | YES | - | - | Jabber handle. |
| affero | varchar(255) | YES | - | - | Affero handle. (From FUDforum 3.0.7 this column is no longer used). |
| varchar(255) | YES | - | - | Google handle. | |
| skype | varchar(255) | YES | - | - | Skype handle. |
| varchar(255) | YES | - | - | Twitter handle. | |
| posts_ppg | int(11) | NO | - | 0 | |
| time_zone | varchar(255) | NO | - | UTC | Time zone. Changed default from America/Montreal to URC in FUDforum 3.0.2. |
|
birthday |
CHAR(8) |
YES | MUL | - | User's date of birth (MMDDYYYY). (Added in FUDforum 3.0.2). bday was removed in FUDforum 3.0.2. |
| join_date | bigint(20) | NO | MUL | 0 | User's registration date. |
| conf_key | varchar(32) | YES | MUL | - | Confirmation key. Removed NOT NULL and default in FUDforum 3.0.2. |
| reset_key | varchar(32) | YES | MUL | - | Password reset key. Removed NOT NULL and default in FUDforum 3.0.5. |
| user_image | varchar(255) | YES | - | - | |
| theme | int(11) | NO | - | 0 | References fud30_themes.id. |
| posted_msg_count | int(11) | NO | - | 0 | |
| last_visit | bigint(20) | NO | MUL | 0 | Date of last visit. |
| referer_id | int(11) | NO | MUL | 0 | References 'id' (above). |
| last_read | bigint(20) | NO | - | 0 | |
| custom_status | text | YES | - | - | |
| sig | text | YES | - | - | Signature. |
| level_id | int(11) | NO | - | 0 | User's level. References fud30_level.id. |
| u_last_post_id | int(11) | NO | - | 0 | References fud30_msg.id. |
| home_page | varchar(255) | YES | - | - | Users home page. |
| bio | text | YES | - | - | Users biography. |
| cat_collapse_status | text | YES | - | - | |
| custom_color | varchar(255) | YES | - | - | |
| buddy_list | text | YES | - | - | |
| ignore_list | text | YES | - | - | |
| group_leader_list | text | YES | - | - | |
| users_opt | int(11) | NO | MUL | 4488117 | Options (see below). |
| sq | varchar(32) | YES | - | - | |
|
registration_ip |
VARCHAR(46) bigint(20) | NO | - | 0 | Registration IP address. Was registration_ip before FUDforum 3.0.4. |
| ban_expiry | bigint(20) | NO | - | 0 | If user is banned, when the ban will expire. |
| topics_per_page | int(11) | NO | - | 40 | Number of topics to display per page. |
| last_login | bigint(20) | NO | - | 0 | Last login time. |
| flag_cc | char(2) | YES | - | - | Country code. |
| flag_country | varchar(50) | YES | - | - | Country name. |
|
last_used_ip |
VARCHAR(46) |
NO | - | 0 | Last IP address used. Was last_known_ip before FUDforum 3.0.4. |
| custom_fields | text | YES | - | - | Values for Custom profile fields. (Added in FUDforum 3.0.2). |
| Index Name | Uniqueness | Column Name | Seq in index | Comments |
|---|---|---|---|---|
| PRIMARY | UNIQUE | id | 1 | |
| fud30_users_i_l | UNIQUE | login | 1 | |
| fud30_users_i_e | UNIQUE | 1 | ||
| fud30_users_i_a | UNIQUE | alias | 1 | |
| fud30_users_i_rk | NOT UNIQUE | reset_key | 1 | |
| fud30_users_i_lv | NOT UNIQUE | last_visit | 1 | |
| fud30_users_i_ck | NOT UNIQUE | conf_key | 1 | |
| fud30_users_i_ri | NOT UNIQUE | referer_id | 1 | |
| fud30_users_i_uo | NOT UNIQUE | users_opt | 1 | |
| fud30_users_i_jd | NOT UNIQUE | join_date | 1 | |
| fud30_users_i_bd | NOT UNIQUE | birthday | 1 | (Added in FUDforum 3.0.2). |
Binary values for users_opt:
- 1 = display_email (ON/OFF)
- 2 = notify (ON/OFF)
- 4 = notify_method (EMAIL/ICQ) (ICQ notification is no longer used)
- 8 = ignore_admin (ON/OFF)
- 16 = email_messages (ON/OFF)
- 32 = pm_messages (ON/OFF)
- 64 = pm_notify (ON/OFF)
- 128 = default_topic_view (MSG/TREE)
- 256 = default_message_view (MSG/TREE)
- 512 = gender (UNSPECIFIED)
- 1024 = gender (MALE/FEMALE)
- 2048 = append_sig (ON/OFF)
- 4096 = show_sigs (ON/OFF)
- 8192 = show_avatars (ON/OFF)
- 16384 = show_im (ON/OFF)
- 32768 = invisible_mode (ON/OFF)
- 65536 = blocked (or banned) (ON/OFF)
- 131072 = email_conf (ON/OFF)
- 262144 = coppa (ON/OFF)
- 524288 = is_mod (ON/OFF)
- 1048576 = is_admin (ON/OFF)
- 2097152 = acc_status (PENDING/APPROVED)
- 4194304 = avatar_approved (No Avatar)
- 8388608 = avatar_approved YES
- 16777216 = avatar_approved NO
- 33554432 = admin disabled PM (ON/OFF)
- 67108864 = admin disabled signature (ON/OFF)
- 134217728 = do not send e-mail notifications (ON/OFF)
- 268435456 = account moderator (ON/OFF)
- 536870912 = always moderate user's posts (ON/OFF)
- 1073741824 = is_spider