Manuel:table change_tag
| ↑ Manuel:Contenu | Schéma de base de données MédiaWiki | table change_tag |
| Version de MediaWiki : | ≥ 1.15 |
La table change_tag suit les étiquettes des révisions, des journaux et des modifications récentes. Voir aussi les tables tag_summary et valid_tag.
Champs
ct_id
| Version de MediaWiki : | ≥ 1.28 |
Clé primaire.
ct_rc_id
rc_id de la modification.
ct_log_id
log_id de la modification.
ct_rev_id
rev_id de la modification. Notez que cela ne sera pas unique : pour chaque balise appliquée à une modification, une rangée différente sera ajoutée.
ct_tag
| Versions de MediaWiki : | 1.15 – 1.32 |
Chaîne correspondant à une étiquette appliquée à la modification.
ct_tag_id
| Version de MediaWiki : | ≥ 1.32 |
Clé externe pour la clé primaire de change_tag_def table (change_tag_def.ctd_id). Si elle est initialisée, ct_tag est obsolète.
ct_params
Paramètres de l'étiquette. Exemple : gerrit:139881 pour Extension:ContentTranslation/fr.
Résumé du schéma
| Version de MediaWiki : | ≥ 1.36 |
DESCRIBE change_tag;
+-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | ct_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | ct_rc_id | int(10) unsigned | YES | MUL | NULL | | | ct_log_id | int(10) unsigned | YES | MUL | NULL | | | ct_rev_id | int(10) unsigned | YES | MUL | NULL | | | ct_params | blob | YES | | NULL | | | ct_tag_id | int(10) unsigned | NO | MUL | NULL | | +-----------+------------------+------+-----+---------+----------------+
| Versions de MediaWiki : | 1.33 – 1.35 |
DESCRIBE change_tag;
+-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | ct_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | ct_rc_id | int(11) | YES | MUL | NULL | | | ct_log_id | int(10) unsigned | YES | MUL | NULL | | | ct_rev_id | int(10) unsigned | YES | MUL | NULL | | | ct_params | blob | YES | | NULL | | | ct_tag_id | int(10) unsigned | NO | MUL | NULL | | +-----------+------------------+------+-----+---------+----------------+
| Version de MediaWiki : | 1.32 |
DESCRIBE change_tag;
+-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | ct_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | ct_rc_id | int(11) | YES | MUL | NULL | | | ct_log_id | int(10) unsigned | YES | MUL | NULL | | | ct_rev_id | int(10) unsigned | YES | MUL | NULL | | | ct_tag | varbinary(255) | NO | MUL | | | | ct_params | blob | YES | | NULL | | | ct_tag_id | int(10) unsigned | YES | MUL | NULL | | +-----------+------------------+------+-----+---------+----------------+
| Versions de MediaWiki : | 1.30 – 1.31 |
DESCRIBE change_tag;
+-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | ct_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | ct_rc_id | int(11) | YES | MUL | NULL | | | ct_log_id | int(10) unsigned | YES | MUL | NULL | | | ct_rev_id | int(10) unsigned | YES | MUL | NULL | | | ct_tag | varbinary(255) | NO | MUL | NULL | | | ct_params | blob | YES | | NULL | | +-----------+------------------+------+-----+---------+----------------+
| Versions de MediaWiki : | 1.28 – 1.29 |
DESCRIBE change_tag;
+-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | ct_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | ct_rc_id | int(11) | YES | MUL | NULL | | | ct_log_id | int(11) | YES | MUL | NULL | | | ct_rev_id | int(11) | YES | MUL | NULL | | | ct_tag | varbinary(255) | NO | MUL | NULL | | | ct_params | blob | YES | | NULL | | +-----------+------------------+------+-----+---------+----------------+
| Versions de MediaWiki : | 1.15 – 1.27 |
DESCRIBE change_tag;
+-----------+----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+----------------+------+-----+---------+-------+ | ct_rc_id | int(11) | YES | MUL | NULL | | | ct_log_id | int(11) | YES | MUL | NULL | | | ct_rev_id | int(11) | YES | MUL | NULL | | | ct_tag | varbinary(255) | NO | MUL | NULL | | | ct_params | blob | YES | | NULL | | +-----------+----------------+------+-----+---------+-------+
Les index
| Version de MediaWiki : | ≥ 1.37 |
SHOW INDEX IN change_tag;
+------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | change_tag | 0 | PRIMARY | 1 | ct_id | A | 0 | NULL | NULL | | BTREE | | | | change_tag | 0 | ct_rc_tag_id | 1 | ct_rc_id | A | 0 | NULL | NULL | YES | BTREE | | | | change_tag | 0 | ct_rc_tag_id | 2 | ct_tag_id | A | 0 | NULL | NULL | | BTREE | | | | change_tag | 0 | ct_log_tag_id | 1 | ct_log_id | A | 0 | NULL | NULL | YES | BTREE | | | | change_tag | 0 | ct_log_tag_id | 2 | ct_tag_id | A | 0 | NULL | NULL | | BTREE | | | | change_tag | 0 | ct_rev_tag_id | 1 | ct_rev_id | A | 0 | NULL | NULL | YES | BTREE | | | | change_tag | 0 | ct_rev_tag_id | 2 | ct_tag_id | A | 0 | NULL | NULL | | BTREE | | | | change_tag | 1 | ct_tag_id_id | 1 | ct_tag_id | A | 0 | NULL | NULL | | BTREE | | | | change_tag | 1 | ct_tag_id_id | 2 | ct_rc_id | A | 0 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | ct_tag_id_id | 3 | ct_rev_id | A | 0 | NULL | NULL | YES | BTREE | | | | change_tag | 1 | ct_tag_id_id | 4 | ct_log_id | A | 0 | NULL | NULL | YES | BTREE | | | +------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+