< Extension:FlaggedRevs
This table contains all revisions which are flagged ("reviewed").
Fields
fr_rev_id
rev_id of the flagged revision.
fr_page_id
page_id of the page to which the revision belongs.
fr_user
user_id of the user which reviewed this revision.
fr_timestamp
Time when the revision was reviewed.
fr_comment
fr_quality
fr_tags
fr_text
fr_flags
Comma-separated list of flags. Contains "auto" for autoreviewed revisions.
fr_img_name
fr_img_timestamp
fr_img_sha1
fr_rev_timestamp
Timestamp of the revision (should be the same as corresponding rev_timestamp in revisions table).
Schema summary
| 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 |
Wikimedia extension database tables | ||
|---|---|---|
| AbuseFilter |
|  |
| AntiSpoof | spoofuser | |
| Babel | babel | |
| BetaFeatures | betafeatures_user_counts | |
| BounceHandler | bounce_records | |
| CentralAuth |
| |
| CentralNotice |
| |
| CheckUser |
| |
| CodeReview |
| |
| Cognate |
| |
| ContentTranslation |
| |
| CreditsSource |
| |
| DiscussionTools |
| |
| Echo |
| |
| FlaggedRevs |
| |
| GeoData | geo_tags | |
| GlobalBlocking |
| |
| GlobalPreferences | global_preferences | |
| GlobalUsage | globalimagelinks | |
| GrowthExperiments |
| |
| Linter | linter | |
| LiquidThreads |
| |
| Math |
| |
| Newsletter |
| |
| OATHAuth | oathauth_users | |
| OAuth |
| |
| OpenStackManager |
| |
| ORES |
| |
| PageAssessments |
| |
| PageTriage |
| |
| Proofread Page | pr_index | |
| PropertySuggester | wbs_propertypairs | |
| ReadingLists |
| |
| SecurePoll |
| |
| ShortUrl | shorturls | |
| TimedMediaHandler | transcode | |
| Translate |
| |
| UploadWizard | uw_campaigns | |
| UrlShortener | urlshortcodes | |
| WikibaseQualityConstraints | wbqc_constraints | |
| WikiLove | wikilove_log | |
| WikimediaEditorTasks |
| |
This article is issued from Mediawiki. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.