Extension:PageTriage/pagetriage page table
Appearance
mysql> describe pagetriage_page; +-----------------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+---------------------+------+-----+---------+-------+ | ptrp_page_id | int(10) unsigned | NO | PRI | NULL | | | ptrp_reviewed | tinyint(3) unsigned | NO | MUL | 0 | | | ptrp_deleted | tinyint(3) unsigned | NO | MUL | 0 | | | ptrp_created | varbinary(14) | NO | MUL | NULL | | | ptrp_tags_updated | varbinary(14) | NO | MUL | NULL | | | ptrp_reviewed_updated | varbinary(14) | NO | MUL | NULL | | | ptrp_last_reviewed_by | int(10) unsigned | NO | | 0 | | +-----------------------+---------------------+------+-----+---------+-------+
ptrp_reviewed
[edit]- 0 = marked as unreviewed
- 1 = marked as reviewed
- 2 = marked as patrolled
- 3 = autopatrolled
ptrp_created
[edit]Page creation date, not date that the entry was added to the pagetriage_page
table.
ptrp_reviewed_updated
[edit]Appears to be the date that the entry was either added to the pagetriage_page
table, or had its ptrp_reviewed
status changed, or (for drafts) when the state of the draft (unsubmitted, submitted, declined, rejected) last changed.
Unclear if/how flipping from redirect to article affects this field, or page moves affect this field. More research needed.
ptrp_last_reviewed_by
[edit]
Contains the user_id
, not the actor_id