Fud30 group members

Description of FUDforum table fud30_group_members. This table tracks the users assigned to each group.

Fields

Column Name	Datatype	Can be Null?	Key?	Default	Description
id	int(11)	NO	PRI		auto_increment
user_id	int(11)	NO		0	References fud30_users.id.
group_id	int(11)	NO	MUL	0	References fud30_groups.id.
group_members_opt	int(11)	NO	MUL	65536	Options (see below).

Keys

Index Name	Uniqueness	Column Name	Seq in index	Comments
PRIMARY	UNIQUE	id	1
fud30_group_members_i_gu	UNIQUE	group_id	1
fud30_group_members_i_gu	UNIQUE	user_id	2
fud30_group_members_i_gmo	NOT UNIQUE	group_members_opt	1

Options

Binary values for group_members_opt:

• 1 up_VISIBLE
• 2 up_READ
• 4 up_POST
• 8 up_REPLY
• 16 up_EDIT
• 32 up_DEL
• 64 up_STICKY
• 128 up_POLL
• 256 up_FILE
• 512 up_VOTE
• 1024 up_RATE
• 2048 up_SPLIT
• 4096 up_LOCK
• 8192 up_MOVE
• 16384 up_SML
• 32768 up_IMG
• 65536 approved
• 131072 group_leader
• 262144 up_SEARCH

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