Description of FUDforum table fud30_group_cache. This table caches group assignments.
|
Column Name
|
Datatype
|
Can be Null?
|
Key?
|
Default
|
Description
|
|
id
|
int(11)
|
NO
|
PRI
|
-
|
auto_increment
|
|
user_id
|
int(11)
|
NO
|
MUL
|
0
|
References fud30_users.id.
|
|
resource_id
|
int(11)
|
NO
|
MUL
|
0
|
References fud30_forum.id.
|
|
group_id
|
int(11)
|
NO
|
MUL
|
0
|
References fud30_groups.id.
|
|
group_cache_opt
|
int(11)
|
NO
|
-
|
0
|
Options (see below).
|
|
Index Name
|
Uniqueness
|
Column Name
|
Seq in index
|
Comments
|
|
PRIMARY
|
UNIQUE
|
id
|
1
|
|
|
fud30_group_cache_i_ru
|
UNIQUE
|
resource_id
|
1
|
|
|
fud30_group_cache_i_ru
|
UNIQUE
|
user_id
|
2
|
|
|
fud30_group_cache_i_g
|
NOT UNIQUE
|
group_id
|
1
|
|
|
fud30_group_cache_i_u
|
NOT UNIQUE
|
user_id
|
1
|
|
- 1 = p_VISIBLE
- 2 = p_READ
- 4 = p_POST
- 8 = p_REPLY
- 16 = p_EDIT
- 32 = p_DEL
- 64 = p_STICKY
- 128 = p_POLL
- 256 = p_FILE
- 512 = p_VOTE
- 1024 = p_RATE
- 2048 = p_SPLIT
- 4096 = p_LOCK
- 8192 = p_MOVE
- 16384 = p_SML
- 32768 = p_IMG
- 262144 = p_SEARCH