Manual:Change tag table

The change_tag table tracks tags for revisions, logs and recent changes. See also the tag_summary and valid_tag tables.

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
String corresponding to one tag applied to the change.

ct_params
Parameters for the tag. Example: 139881 in Extension:ContentTranslation.

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