Manual:change_tag/es table
From Linux Web Expert
| ↑ Manual: Contenidos de | <translate> MediaWiki database layout</translate> | <translate> <tvar name=1>change_tag/es</tvar> table</translate> |
| Versión de MediaWiki: | <translate> ≥</translate> 1.15 |
The change_tag table tracks tags for revisions, logs and recent changes. See also the tag_summary and valid_tag tables.
Campos
ct_id
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>"><translate> ≥</translate> 1.28
| <translate> MediaWiki version:</translate> |
The primary key.
ct_rc_id
rc_id para el cambio.
ct_log_id
log_id para el cambio
ct_rev_id
rev_id para el cambio. Note that this will not be unique: for each tag applied to a change, a distinct row is added.
ct_tag
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.32</tvar> is unsupported version</translate>"> 1.15 – 1.32
| <translate> MediaWiki versions:</translate> |
String corresponding to one tag applied to the change.
ct_tag_id
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>"><translate> ≥</translate> 1.32
| <translate> MediaWiki version:</translate> |
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. Ejemplo: gerrit:139881 en Extensión:ContentTranslation.
Schema resumen
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>"><translate> ≥</translate> 1.36
| <translate> MediaWiki version:</translate> |
DESCRIBE change_tag/es;
+-----------+------------------+------+-----+---------+----------------+ | 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 | | +-----------+------------------+------+-----+---------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.35</tvar> is unsupported version</translate>">
1.33 – 1.35
| <translate> MediaWiki versions:</translate> |
DESCRIBE change_tag/es;
+-----------+------------------+------+-----+---------+----------------+ | 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 | | +-----------+------------------+------+-----+---------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.32</tvar> is unsupported version</translate>">
1.32
| <translate> MediaWiki version:</translate> |
DESCRIBE change_tag/es;
+-----------+------------------+------+-----+---------+----------------+ | 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 | | +-----------+------------------+------+-----+---------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.31</tvar> is unsupported version</translate>">
1.30 – 1.31
| <translate> MediaWiki versions:</translate> |
DESCRIBE change_tag/es;
+-----------+------------------+------+-----+---------+----------------+ | 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 | | +-----------+------------------+------+-----+---------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.29</tvar> is unsupported version</translate>">
1.28 – 1.29
| <translate> MediaWiki versions:</translate> |
DESCRIBE change_tag/es;
+-----------+------------------+------+-----+---------+----------------+ | 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 | | +-----------+------------------+------+-----+---------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.27</tvar> is unsupported version</translate>">
1.15 – 1.27
| <translate> MediaWiki versions:</translate> |
DESCRIBE change_tag/es;
+-----------+----------------+------+-----+---------+-------+ | 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
<translate> ≥</translate> 1.37
| <translate> MediaWiki version:</translate> |
SHOW INDEX IN change_tag/es;
+------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | 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 | | | +------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
