Extension:Report/report reports table

A table for the Report extension.

Fields

report_id

Primary key

report_revid

Revision ID for report

report_timestamp

Timestamp of report

report_reason

Text of the report

report_user

user_id

report_user_text

user_text

report_handled

Whether the report has been handled

report_handled_by

User ID of who the report was handled by, or 0 if not handled

report_handled_by_text

Username of who the report was handled by, or the empty string if not handled

report_handled_timestamp

The timestamp when the report was handled, or the empty string if not handled

Schema

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)