Description of FUDforum table fud30_index. This table is used to index words in messages for the forum's search feature.
Fields
Column Name | Datatype | Can be Null? | Key? | Default | Description
|
id | int(11) | NO | PRI | | auto_increment (removed in FUDforum 3.0.2)
|
word_id | int(11) | NO | MUL | 0 | References fud30_search.id.
|
msg_id | int(11) | NO | MUL | 0 | References fud30_msg.id.
|
Keys
Index Name | Uniqueness | Column Name | Seq in index | Comments
|
fud30_index_i_wm | UNIQUE | word_id | 1 | Changed to UNIQUE in FUDforum 3.0.2.
|
fud30_index_i_wm | UNIQUE | msg_id | 2 |
|
fud30_index_i_m | NOT UNIQUE | msg_id | 1 |
|