Manual:Tag summary table/de

The tag_summary table is used to pull a LIST of tags simply without ugly GROUP_CONCAT. Siehe auch die -Tabelle. For background, see this announcement: "Deprecation of tag_summary table"

ts_id
The primary key.

ts_rc_id
for the change.

ts_log_id
for the change.

ts_rev_id
for the change.

ts_tags
Comma-separated list of tags.

Schematische Übersicht
+---+--+--+-+-++ +---+--+--+-+-++ +---+--+--+-+-++
 * Field    | Type             | Null | Key | Default | Extra          |
 * ts_id    | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
 * ts_rc_id | int(11)          | YES  | UNI | NULL    |                |
 * ts_log_id | int(10) unsigned | YES | UNI | NULL    |                |
 * ts_rev_id | int(10) unsigned | YES | UNI | NULL    |                |
 * ts_tags  | blob             | NO   |     | NULL    |                |

+---+--+--+-+-++ +---+--+--+-+-++ +---+--+--+-+-++
 * Field    | Type             | Null | Key | Default | Extra          |
 * ts_id    | int(10) unsigned | NO   | PRI | NULL    | AUTO_INCREMENT |
 * ts_rc_id | int(11)          | YES  | UNI | NULL    |                |
 * ts_log_id | int(11)         | YES  | UNI | NULL    |                |
 * ts_rev_id | int(11)         | YES  | UNI | NULL    |                |
 * ts_tags  | blob             | NO   |     | NULL    |                |

+---+-+--+-+-+---+ +---+-+--+-+-+---+ +---+-+--+-+-+---+
 * Field    | Type    | Null | Key | Default | Extra |
 * ts_rc_id | int(11) | YES  | UNI | NULL    |       |
 * ts_log_id | int(11) | YES | UNI | NULL    |       |
 * ts_rev_id | int(11) | YES | UNI | NULL    |       |
 * ts_tags  | blob    | NO   |     | NULL    |       |

Indexe
 +-+++--+-+---+-+--++--++-+---+ +-+++--+-+---+-+--++--++-+---+ +-+++--+-+---+-+--++--++-+---+
 * Table      | Non_unique | Key_name           | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
 * tag_summary |         0 | PRIMARY            |            1 | ts_id       | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * tag_summary |         0 | tag_summary_rc_id  |            1 | ts_rc_id    | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
 * tag_summary |         0 | tag_summary_log_id |            1 | ts_log_id   | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
 * tag_summary |         0 | tag_summary_rev_id |            1 | ts_rev_id   | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |