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
|
|