Jump to content

Extension:PageTriage/pagetriage page table

From mediawiki.org
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