Extension:FlaggedRevs/flaggedrevs table
From mediawiki.org
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 |