Manual:change_tag テーブル

From MediaWiki.org
Jump to navigation Jump to search
This page is a translated version of the page Manual:Change tag table and the translation is 43% complete.

Other languages:
English • ‎español • ‎日本語
Manual:コンテンツ MediaWiki のデータベース レイアウト change_tag table


MediaWiki バージョン: 1.15

change_tag テーブルでは、版、記録、最近の更新についてタグを追跡します。 tag_summary および valid_tag の各テーブルも参照してください。

フィールド

ct_id

MediaWiki バージョン: 1.28

主キー。

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 バージョン: 1.15 – 1.32

String corresponding to one tag applied to the change.

ct_tag_id

MediaWiki バージョン: 1.32

Foreign key to primary key of Manual: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 .

スキーマの要約

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    |                |
+-----------+------------------+------+-----+---------+----------------+
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    |                |
+-----------+------------------+------+-----+---------+----------------+
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    |                |
+-----------+------------------+------+-----+---------+----------------+
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    |       |
+-----------+----------------+------+-----+---------+-------+