Manual:Change tag table
| ↑ Manual:Contents | MediaWiki database layout | change_tag table |
| MediaWiki version: | ≥ 1.15 |
The change_tag table tracks tags for revisions, logs and recent changes. See also the tag_summary and valid_tag tables.
Fields
ct_id
| MediaWiki version: | ≥ 1.28 |
The primary key.
ct_rc_id
rc_id for the change.
ct_log_id
log_id for the change.
ct_rev_id
rev_id for the change. Note that this will not be unique: for each tag applied to a change, a distinct row is added.
ct_tag
| MediaWiki versions: | 1.15 – 1.32 |
String corresponding to one tag applied to the change.
ct_tag_id
| MediaWiki version: | ≥ 1.32 |
Foreign key to primary key of change_tag_def table (change_tag_def.ctd_id). When it's populated, ct_tag is obsolete.
ct_params
Parameters for the tag. Example: gerrit:139881 in Extension:ContentTranslation.
Schema summary
| MediaWiki version: | ≥ 1.43 |
DESCRIBE change_tag;
+-----------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------------------+------+-----+---------+----------------+ | ct_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | ct_rc_id | bigint(20) 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 | | +-----------+---------------------+------+-----+---------+----------------+
| MediaWiki versions: | 1.36 – 1.42 |
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 | | +-----------+------------------+------+-----+---------+----------------+
| MediaWiki versions: | 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 | | +-----------+------------------+------+-----+---------+----------------+
| MediaWiki version: | 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 | | +-----------+------------------+------+-----+---------+----------------+
| MediaWiki versions: | 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 | | +-----------+------------------+------+-----+---------+----------------+
| MediaWiki versions: | 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 | | +-----------+------------------+------+-----+---------+----------------+
| MediaWiki versions: | 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 | | +-----------+----------------+------+-----+---------+-------+
Indexes
| MediaWiki version: | ≥ 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 | | | +------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+