MariaDB [teeworlds]> show index from record_race; +-------------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-------------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | record_race | 0 | Map | 1 | Map | A | 138377 | NULL | NULL | | BTREE | | | | record_race | 0 | Map | 2 | Name | A | 6503764 | NULL | NULL | | BTREE | | | | record_race | 0 | Map | 3 | Time | A | 6503764 | NULL | NULL | | BTREE | | | | record_race | 0 | Map | 4 | Timestamp | A | 6503764 | NULL | NULL | | BTREE | | | | record_race | 0 | Map | 5 | Server | A | 6503764 | NULL | NULL | | BTREE | | | | record_race | 1 | Map_2 | 1 | Map | A | 38483 | NULL | NULL | | BTREE | | | | record_race | 1 | Map_2 | 2 | Name | A | 6503764 | NULL | NULL | | BTREE | | | | record_race | 1 | Name | 1 | Name | A | 650376 | NULL | NULL | | BTREE | | | | record_race | 1 | Name | 2 | Timestamp | A | 6503764 | NULL | NULL | | BTREE | | | | record_race | 1 | MapTimestamp | 1 | Map | A | 36744 | NULL | NULL | | BTREE | | | | record_race | 1 | MapTimestamp | 2 | Timestamp | A | 6503764 | NULL | NULL | | BTREE | | | | record_race | 1 | Timestamp | 1 | Timestamp | A | 6503764 | NULL | NULL | | BTREE | | | +-------------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 12 rows in set (0.001 sec) MariaDB [teeworlds]> show index from record_teamrace; +-----------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-----------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | record_teamrace | 0 | PRIMARY | 1 | Map | A | 10880 | NULL | NULL | | BTREE | | | | record_teamrace | 0 | PRIMARY | 2 | Name | A | 848687 | NULL | NULL | | BTREE | | | | record_teamrace | 0 | PRIMARY | 3 | Timestamp | A | 848687 | NULL | NULL | | BTREE | | | | record_teamrace | 0 | PRIMARY | 4 | Time | A | 848687 | NULL | NULL | | BTREE | | | | record_teamrace | 0 | PRIMARY | 5 | ID | A | 848687 | NULL | NULL | | BTREE | | | | record_teamrace | 0 | Name | 1 | Name | A | 141447 | NULL | NULL | | BTREE | | | | record_teamrace | 0 | Name | 2 | ID | A | 848687 | NULL | NULL | | BTREE | | | | record_teamrace | 1 | Map | 1 | Map | A | 2782 | NULL | NULL | | BTREE | | | | record_teamrace | 1 | ID | 1 | ID | A | 848687 | NULL | NULL | | BTREE | | | +-----------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 9 rows in set (0.001 sec) MariaDB [teeworlds]> show index from record_saves; +--------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +--------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | record_saves | 0 | Map | 1 | Map | A | 4014 | NULL | NULL | | BTREE | | | | record_saves | 0 | Map | 2 | Code | A | 100356 | NULL | NULL | | BTREE | | | +--------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 2 rows in set (0.001 sec) MariaDB [teeworlds]> show index from record_maps; +-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | record_maps | 0 | PRIMARY | 1 | Map | A | 1679 | NULL | NULL | | BTREE | | | | record_maps | 0 | PRIMARY | 2 | Server | A | 1679 | NULL | NULL | | BTREE | | | | record_maps | 0 | PRIMARY | 3 | Points | A | 1679 | NULL | NULL | | BTREE | | | | record_maps | 0 | PRIMARY | 4 | Stars | A | 1679 | NULL | NULL | | BTREE | | | | record_maps | 0 | PRIMARY | 5 | Mapper | A | 1679 | NULL | NULL | | BTREE | | | | record_maps | 0 | PRIMARY | 6 | Timestamp | A | 1679 | NULL | NULL | | BTREE | | | | record_maps | 0 | Map | 1 | Map | A | 1679 | NULL | NULL | | BTREE | | | +-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 7 rows in set (0.001 sec) MariaDB [teeworlds]> show index from record_points; +---------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +---------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | record_points | 0 | Name | 1 | Name | A | 318467 | NULL | NULL | | BTREE | | | | record_points | 1 | points | 1 | Points | A | 7961 | NULL | NULL | YES | BTREE | | | +---------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 2 rows in set (0.001 sec)