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
[
edit
]
ct_id
[
edit
]
MediaWiki version:
|
≥
1.28
|
The primary key.
ct_rc_id
[
edit
]
rc_id
for the change.
ct_log_id
[
edit
]
log_id
for the change.
ct_rev_id
[
edit
]
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
[
edit
]
MediaWiki versions:
|
1.15 – 1.32
|
String corresponding to one
tag
applied to the change.
ct_tag_id
[
edit
]
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
[
edit
]
Parameters for the tag.
Example:
gerrit:139881
in
Extension:ContentTranslation
.
Schema summary
[
edit
]
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 | |
+-----------+------------------+------+-----+---------+----------------+
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
[
edit
]
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 | | |
+------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
|
---|
Engines
| |
---|
Technical documentation
| |
---|
Configuration
| |
---|
Development
| |
---|
Core tables
| |
---|