Manual:Comment table/fr

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 and.

This table was introduced in.

comment_id
ID unique pour identifier chaque commentaire.

comment_hash
Valeur de hachage de et, pour éviter la duplication.

comment_text
Texte du commentaire pour résumer la modification, par exemple le résumé de modification d'un éditeur. Ce texte est affiché dans l'historique et les. It is also used for, , , and, in the case of page creation, for the. Il est rendu avec un sous ensemble expurgé de balises wiki par. Size limits are enforced at the application level, and should take care to crop UTF-8 strings appropriately.

comment_data
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, should be the generated comment localized using the wiki's content language.

Schéma
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    |                |