fud30_group_members - fudforum/FUDforum GitHub Wiki

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

[ Home ] [ Features ] [ Installation ] [ Upgrading ] [ Administration ] [ Support ] [ Internals ]
Mirror for robots like Google that cannot index GitHUB Wiki Pages: https://github-wiki-see.page/m/fudforum/FUDforum/wiki_index

⚠️ **GitHub.com Fallback** ⚠️