fud30_group_cache
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
