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_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
|
|
|
|
|
---|
Engines
| |
---|
Technical documentation
| |
---|
Configuration
| |
---|
Development
| |
---|
Core tables
| |
---|