Extension:FlaggedRevs/flaggedrevs table
This table contains all revisions which are flagged ("reviewed").
Fields[edit]
fr_rev_id[edit]
rev_id of the flagged revision.
fr_page_id[edit]
page_id of the page to which the revision belongs.
fr_user[edit]
user_id of the user which reviewed this revision.
fr_timestamp[edit]
Time when the revision was reviewed.
fr_comment[edit]
fr_quality[edit]
fr_tags[edit]
fr_text[edit]
fr_flags[edit]
Comma-separated list of flags. Contains "auto" for autoreviewed revisions.
fr_img_name[edit]
fr_img_timestamp[edit]
fr_img_sha1[edit]
fr_rev_timestamp[edit]
Timestamp of the revision (should be the same as corresponding rev_timestamp in revisions table).
Schema summary[edit]
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| fr_page_id | int(11) | NO | 0 | ||
| fr_rev_id | int(11) | NO | 0 | ||
| fr_user | int(5) | NO | 0 | ||
| fr_timestamp | varbinary(14) | NO | |||
| fr_comment | mediumblob | NO | None | ||
| fr_quality | tinyint(1) | NO | 0 | ||
| fr_tags | mediumblob | NO | None | ||
| fr_text | mediumblob | NO | None | ||
| fr_flags | tinyblob | NO | None | ||
| fr_img_name | varbinary(255) | YES | None | ||
| fr_img_timestamp | varbinary(14) | YES | None | ||
| fr_img_sha1 | varbinary(32) | YES | None | ||
| fr_rev_timestamp | varbinary(14) | NO |
