| 2 | |
| 3 | |
| 4 | This is what shows up for `SHOW INDEX FROM wp_bp_activity` afterwards: |
| 5 | |
| 6 | |
| 7 | {{{ |
| 8 | $ wp db query "SHOW INDEX FROM wp_bp_activity" |
| 9 | +----------------+------------+--------------------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ |
| 10 | | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | |
| 11 | +----------------+------------+--------------------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ |
| 12 | | wp_bp_activity | 0 | PRIMARY | 1 | id | A | 713 | NULL | NULL | | BTREE | | | |
| 13 | | wp_bp_activity | 1 | date_recorded | 1 | date_recorded | A | 713 | NULL | NULL | | BTREE | | | |
| 14 | | wp_bp_activity | 1 | user_id | 1 | user_id | A | 35 | NULL | NULL | | BTREE | | | |
| 15 | | wp_bp_activity | 1 | item_id | 1 | item_id | A | 89 | NULL | NULL | | BTREE | | | |
| 16 | | wp_bp_activity | 1 | secondary_item_id | 1 | secondary_item_id | A | 356 | NULL | NULL | YES | BTREE | | | |
| 17 | | wp_bp_activity | 1 | component | 1 | component | A | 13 | NULL | NULL | | BTREE | | | |
| 18 | | wp_bp_activity | 1 | type | 1 | type | A | 32 | NULL | NULL | | BTREE | | | |
| 19 | | wp_bp_activity | 1 | mptt_left | 1 | mptt_left | A | 33 | NULL | NULL | | BTREE | | | |
| 20 | | wp_bp_activity | 1 | mptt_right | 1 | mptt_right | A | 39 | NULL | NULL | | BTREE | | | |
| 21 | | wp_bp_activity | 1 | component_type_user_id_date_recorded | 1 | component | A | 13 | NULL | NULL | | BTREE | | | |
| 22 | | wp_bp_activity | 1 | component_type_user_id_date_recorded | 2 | type | A | 39 | NULL | NULL | | BTREE | | | |
| 23 | | wp_bp_activity | 1 | component_type_user_id_date_recorded | 3 | user_id | A | 118 | NULL | NULL | | BTREE | | | |
| 24 | | wp_bp_activity | 1 | component_type_user_id_date_recorded | 4 | date_recorded | A | 713 | NULL | NULL | | BTREE | | | |
| 25 | +----------------+------------+--------------------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ |
| 26 | }}} |
| 27 | |