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

edit

Contains the user_id, not the actor_id

ptrl_reviewed

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

Automatic deletion of old data

edit

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

References

edit