fud30_msg_report
Description of FUDforum table fud30_msg_report. This table tracks messages that are reported to the forum's moderators.
| Column Name | Datatype | Can be Null? | Key? | Default | Description |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | - | auto_increment |
| msg_id | int(11) | NO | MUL | 0 | References fud30_msg.id. |
| user_id | int(11) | NO | MUL | 0 | References fud30_users.id. |
| reason | text | YES | - | - | Reason why message was reported. |
| stamp | bigint(20) | NO | - | 0 | Date/time reported. |
| Index Name | Uniqueness | Column Name | Seq in index | Comments |
|---|---|---|---|---|
| PRIMARY | UNIQUE | id | 1 | |
| fud30_msg_report_i_mu | UNIQUE | msg_id | 1 | Changed to UNIQUE in FUDforum 3.0.2. |
| fud30_msg_report_i_mu | UNIQUE | user_id | 2 | |
| fud30_msg_report_i_u | NOT UNIQUE | user_id | 1 |
