mysql> show index from Bilder;
+--------+------------+-------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+
| Table  | Non_unique | Key_name          | Seq_in_index | Column_name       | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+--------+------------+-------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+
| Bilder |          0 | PRIMARY           |            1 | id                | A         |      158370 |     NULL | NULL   |      | BTREE      |         |
| Bilder |          0 | unique_identifier |            1 | unique_identifier | A         |      158370 |     NULL | NULL   | YES  | BTREE      |         |
| Bilder |          1 | bild              |            1 | bild              | A         |      158370 |     NULL | NULL   | YES  | BTREE      |         |
| Bilder |          1 | bild              |            2 | pool_id           | A         |      158370 |     NULL | NULL   | YES  | BTREE      |         |
| Bilder |          1 | bild              |            3 | id                | A         |      158370 |     NULL | NULL   |      | BTREE      |         |
+--------+------------+-------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+
5 rows in set (0.00 sec)

mysql> show index from hotfolder_filelist;
+--------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table              | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+--------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| hotfolder_filelist |          1 | basename |            1 | basename    | A         |      158377 |     NULL | NULL   | YES  | BTREE      |         |
| hotfolder_filelist |          1 | barename |            1 | barename    | A         |      158377 |     NULL | NULL   | YES  | BTREE      |         |
+--------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
2 rows in set (0.00 sec)