Manual:change_tag_def table

From MediaWiki.org
Jump to navigation Jump to search

Other languages:
English • ‎dansk • ‎polski • ‎日本語
Manual:Contents MediaWiki database layout change_tag_def table


MediaWiki version: 1.32

The change_tag_def table is a table defining tag names for IDs. It also stores hit counts to avoid expensive queries on change_tag.

Fields[edit]

ctd_id[edit]

Numerical ID of the tag (change_tag.ct_tag_id refers to this)

ctd_name[edit]

Symbolic name of the tag (what would previously be put in change_tag.ct_tag)

ctd_user_defined[edit]

Whether this tag was defined manually by a privileged user using Special:Tags

ctd_count[edit]

Number of times this tag was used

Schema summary[edit]

MediaWiki version: 1.32

DESCRIBE change_tag_def;

+------------------+---------------------+------+-----+---------+----------------+
| Field            | Type                | Null | Key | Default | Extra          |
+------------------+---------------------+------+-----+---------+----------------+
| ctd_id           | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| ctd_name         | varbinary(255)      | NO   | UNI | NULL    |                |
| ctd_user_defined | tinyint(1)          | NO   | MUL | NULL    |                |
| ctd_count        | bigint(20) unsigned | NO   | MUL | 0       |                |
+------------------+---------------------+------+-----+---------+----------------+