Extension:Report/report_reports table
A table for the Report extension.
Fields[edit]
report_id[edit]
Primary key
report_revid[edit]
Revision ID for report
report_timestamp[edit]
Timestamp of report
report_reason[edit]
Text of the report
report_user[edit]
report_user_text[edit]
report_handled[edit]
Whether the report has been handled
report_handled_by[edit]
User ID of who the report was handled by, or 0 if not handled
report_handled_by_text[edit]
Username of who the report was handled by, or the empty string if not handled
report_handled_timestamp[edit]
The timestamp when the report was handled, or the empty string if not handled
Schema[edit]
mysql> describe report_reports; +--------------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------------+------------------+------+-----+---------+----------------+ | report_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | report_revid | int(10) unsigned | NO | MUL | NULL | | | report_timestamp | varbinary(14) | NO | MUL | NULL | | | report_reason | varbinary(255) | NO | | | | | report_user | int(10) unsigned | NO | MUL | NULL | | | report_user_text | varbinary(255) | NO | | NULL | | | report_handled | tinyint(1) | NO | MUL | 0 | | | report_handled_by | int(10) unsigned | NO | MUL | 0 | | | report_handled_by_text | varbinary(255) | NO | | | | | report_handled_timestamp | varbinary(14) | NO | MUL | | | +--------------------------+------------------+------+-----+---------+----------------+ 10 rows in set (0.01 sec)