Extension:FlaggedRevs/flaggedrevs table

From MediaWiki.org
Jump to navigation Jump to search


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