Manual:comment table
↑ Manual:Contents | MediaWiki database layout | comment table |
MediaWiki version: | ≥ 1.30 |
The comment table stores edits, blocks, and other actions which typically have a textual comment describing the action. They are stored in a separate table to reduce the size of the main tables, and to allow for de-duplication.
De-duplication is currently best-effort to avoid locking on inserts that would be required for strict de-duplication. There may be multiple rows with the same comment_text and comment_data.
This table was introduced in Gerrit change 357892.
FieldsEdit
comment_idEdit
Unique ID to identify each comment.
comment_hashEdit
Hash of comment_text and comment_data, for de-duplication.
comment_textEdit
Text comment summarizing the change, e.g. an editor's edit summary.
This text is shown in the history and contributions .
It is also used for recent changes , related changes , watchlists , and, in the case of page creation, for the list of new pages .
It is rendered in a sanitized subset of wiki markup by Linker::formatComment()
.
Size limits are enforced at the application level, and should take care to crop UTF-8 strings appropriately.
comment_dataEdit
JSON data, intended for localizing auto-generated comments. This holds structured data that is intended to be used to provide localized versions of automatically-generated comments. When not empty, comment_text should be the generated comment localized using the wiki's content language.
SchemaEdit
MediaWiki version: | ≥ 1.30 |
DESCRIBE comment;
+--------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+---------------------+------+-----+---------+----------------+ | comment_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | comment_hash | int(11) | NO | MUL | NULL | | | comment_text | blob | NO | | NULL | | | comment_data | blob | YES | | NULL | | +--------------+---------------------+------+-----+---------+----------------+
Code stewardshipEdit
- Maintained by Core Platform Team .
- Live chat (IRC): #mediawiki-core connect
- Issue tracker: Phabricator (Report an issue)