gistfile1.txt

mysql> show indexes from challenges;
+------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table      | Non_unique | Key_name        | Seq_in_index | Column_name     | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| challenges |          0 | PRIMARY         |            1 | id              | A         |          75 |     NULL | NULL   |      | BTREE      |         |               |
| challenges |          1 | authorizationid |            1 | authorizationID | A         |          75 |     NULL | NULL   |      | BTREE      |         |               |
+------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
2 rows in set (0.00 sec)