Extension:FlaggedRevs/flaggedrevs table
This table contains all revisions which are flagged ("reviewed").
Fields
editfr_rev_id
editrev_id of the flagged revision.
fr_page_id
editpage_id of the page to which the revision belongs.
fr_user
edituser_id of the user which reviewed this revision.
fr_timestamp
editTime when the revision was reviewed.
fr_comment
editfr_quality
editfr_tags
editfr_text
editfr_flags
editComma-separated list of flags. Contains "auto" for autoreviewed revisions.
fr_img_name
editfr_img_timestamp
editfr_img_sha1
editfr_rev_timestamp
editTimestamp 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 |