mysql> show index from smf_attachments;
+-----------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-----------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| smf_attachments | 0 | PRIMARY | 1 | id_attach | A | 0 | NULL | NULL | | BTREE | |
| smf_attachments | 0 | id_member | 1 | id_member | A | NULL | NULL | NULL | | BTREE | |
| smf_attachments | 0 | id_member | 2 | id_attach | A | 0 | NULL | NULL | | BTREE | |
| smf_attachments | 1 | id_msg | 1 | id_msg | A | NULL | NULL | NULL | | BTREE | |
+-----------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
4 rows in set (0.00 sec)