< Extension:PageTriage
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
- 0 = marked as unreviewed
- 1 = marked as reviewed
- 2 = marked as patrolled
- 3 = autopatrolled
ptrp_created
Page creation date, not date that the entry was added to the pagetriage_page
table.
ptrp_reviewed_updated
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
Contains the user_id
, not the actor_id
This article is issued from Mediawiki. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.