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 |