Extension:PageTriage/pagetriage log table

mysql> describe pagetriage_log;
+----------------+---------------------+------+-----+---------+----------------+
| Field          | Type                | Null | Key | Default | Extra          |
+----------------+---------------------+------+-----+---------+----------------+
| ptrl_id        | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| ptrl_page_id   | int(10) unsigned    | NO   | MUL | NULL    |                |
| ptrl_user_id   | int(10) unsigned    | NO   |     | NULL    |                |
| ptrl_reviewed  | tinyint(3) unsigned | NO   |     | 0       |                |
| ptrl_timestamp | varbinary(14)       | NO   | MUL | NULL    |                |
+----------------+---------------------+------+-----+---------+----------------+

ptrl_user_id

Contains the user_id, not the actor_id

ptrl_reviewed

• 0 = marked as unreviewed
• 1 = marked as reviewed
• 2 = marked as patrolled
• 3 = autopatrolled

Automatic deletion of old data

This table appears to only store 12 months of data. Anything older than that appears to be automatically deleted.