Manual:Change tag table/zh

change_tag表格跟踪标签的修订、日志和最近的更改. 另请参阅和表.

ct_id
表结构：主键

ct_rc_id
为了这一变化.

ct_log_id
为了这一变化.

ct_rev_id
为了这一变化. 请注意，这将是唯一的：对于应用于更改的每个标记，都会添加一个不同的行.

ct_tag
与应用于更改的一个tag相对应的字符串.

ct_tag_id
表(change_tag_def.ctd_id)的主键的外键. 填充后，ct_tag就过时了.

ct_params
标记的参数. 例如：中的139881.



架构摘要
+---+--+--+-+-++ +---+--+--+-+-++ +---+--+--+-+-++
 * 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    |                |

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

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

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

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

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

索引
 +++---+--+-+---+-+--++--++-+---+ +++---+--+-+---+-+--++--++-+---+ +++---+--+-+---+-+--++--++-+---+
 * 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      |         |               |