Extension:FlaggedRevs/flaggedrevs table


This table contains all revisions which are flagged ("reviewed").

FieldsEdit

fr_rev_idEdit

rev_id of the flagged revision.

fr_page_idEdit

page_id of the page to which the revision belongs.

fr_userEdit

user_id of the user which reviewed this revision.

fr_timestampEdit

Time when the revision was reviewed.

fr_commentEdit

fr_qualityEdit

fr_tagsEdit

fr_textEdit

fr_flagsEdit

Comma-separated list of flags. Contains "auto" for autoreviewed revisions.

fr_img_nameEdit

fr_img_timestampEdit

fr_img_sha1Edit

fr_rev_timestampEdit

Timestamp of the revision (should be the same as corresponding rev_timestamp in revisions table).

Schema summaryEdit

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