Extension:PageTriage/pagetriage log table
Appearance
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]