Fud30 users

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.

Fields

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.
email	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.
google	varchar(255)	YES			Google handle.
skype	varchar(255)	YES			Skype handle.
twitter	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 bday	CHAR(8) int(11)	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.
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.
reset_key	varchar(32)	NO	MUL	0	Password reset key.
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 reg_ip	VARCHAR(46) </s>bigint(20)</s>	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 last_known_ip	VARCHAR(46) bigint(20)	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).

Keys

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	email	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).

Options

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 (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

FUDforum tables

fud30_action log | fud30_ann forums | fud30_announce | fud30_attach | fud30_avatar | fud30_blocked_logins | fud30_bookmarks | fud30_buddy | fud30_calendar | fud30_cat | fud30_custom_fields | fud30_custom_tags | fud30_email_block | fud30_ext_block | fud30_fc_view | fud30_fl_1 | fud30_fl_pg | fud30_fl_pm | fud30_forum | fud30_forum_notify | fud30_forum_read | fud30_geoip | fud30_group_cache | fud30_group_members | fud30_group_resources | fud30_groups | fud30_index | fud30_ip_block | fud30_jobs | fud30_level | fud30_mime | fud30_mlist | fud30_mod | fud30_msg | fud30_msg_report | fud30_msg_store | fud30_nntp | fud30_pages | fud30_plugins | fud30_pmsg | fud30_poll | fud30_poll_opt | fud30_poll_opt_track | fud30_read | fud30_replace | fud30_search | fud30_search cache | fud30_ses | fud30_smiley | fud30_spiders | fud30_stats_cache | fud30_themes | fud30_thr_exchange | fud30_thread | fud30_thread_notify | fud30_thread_rate_track | fud30_title_index | fud30_tv_1 | fud30_user_ignore | fud30_users | fud30_xmlagg