Příručka:Databázová tabulka change_tag
| ↑ Manuál:Obsah | MediaWiki schéma databáze | Tabulka change_tag |
| Verze MediaWiki: | ≥ 1.15 |
Tabulka change_tag sleduje tagy pro revize, záznamy a poslední změny. Viz také tabulky tag_summary a valid_tag.
Pole
ct_id
| Verze MediaWiki: | ≥ 1.28 |
Primární klíč.
ct_rc_id
rc_id pro změnu.
ct_log_id
log_id pro změnu.
ct_rev_id
rev_id pro změnu. Všimněte si, že toto není jedinečné: Pro každou značku použitou na změnu je přidán samostatný řádek.
ct_tag
| Verze MediaWiki: | 1.15 – 1.32 |
Řetězec odpovídající jednomu tagu použitému na změnu.
ct_tag_id
| Verze MediaWiki: | ≥ 1.32 |
Cizí klíč k primárnímu klíči tabulky change_tag_def (change_tag_def.ctd_id). Když je ct_tag naplněn, je zastaralý.
ct_params
Parametry pro značku. Příklad: gerrit:139881 v Extension:ContentTranslation.
Přehled změn ve schématu tabulky
| Verze MediaWiki: | ≥ 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 | | +-----------+---------------------+------+-----+---------+----------------+
| Verze MediaWiki: | 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 | | +-----------+------------------+------+-----+---------+----------------+
| Verze 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 | | +-----------+------------------+------+-----+---------+----------------+
| Verze 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 | | +-----------+------------------+------+-----+---------+----------------+
| Verze 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 | | +-----------+------------------+------+-----+---------+----------------+
| Verze 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 | | +-----------+------------------+------+-----+---------+----------------+
| Verze 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 | | +-----------+----------------+------+-----+---------+-------+
Indexy
| Verze 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 | | | +------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+