--------------
ALTER TABLE best_record 
ADD INDEX IF NOT EXISTS idx_maestro_app_dt (MaestroID, AppID, RecordDateTime),
ALGORITHM=INPLACE, LOCK=NONE
--------------

Query OK, 0 rows affected (4.803 sec)
Records: 0  Duplicates: 0  Warnings: 0

--------------
ALTER TABLE best_record 
ADD INDEX IF NOT EXISTS idx_maestro_player_app_dt (MaestroID, PlayerID, AppID, RecordDateTime),
ALGORITHM=INPLACE, LOCK=NONE
--------------

Query OK, 0 rows affected (4.832 sec)
Records: 0  Duplicates: 0  Warnings: 0

--------------
ALTER TABLE typing_exam_record 
ADD INDEX IF NOT EXISTS idx_maestro_writing_dt (MaestroID, WritingID, RecordDateTime),
ALGORITHM=INPLACE, LOCK=NONE
--------------

Query OK, 0 rows affected (0.735 sec)
Records: 0  Duplicates: 0  Warnings: 0

--------------
ALTER TABLE typing_exam_record 
ADD INDEX IF NOT EXISTS idx_maestro_player_writing_dt (MaestroID, PlayerID, WritingID, RecordDateTime),
ALGORITHM=INPLACE, LOCK=NONE
--------------

Query OK, 0 rows affected (0.370 sec)
Records: 0  Duplicates: 0  Warnings: 0

--------------
ALTER TABLE license_score 
ADD INDEX IF NOT EXISTS idx_maestro_player_dt (MaestroID, PlayerID, ScoreDateTime),
ALGORITHM=INPLACE, LOCK=NONE
--------------

Query OK, 0 rows affected (0.042 sec)
Records: 0  Duplicates: 0  Warnings: 0

--------------
ALTER TABLE app_highest_record 
ADD UNIQUE KEY IF NOT EXISTS uk_maestro_player_app (MaestroID, PlayerID, AppID),
ALGORITHM=INPLACE, LOCK=NONE
--------------

Query OK, 0 rows affected (1.076 sec)
Records: 0  Duplicates: 0  Warnings: 0

--------------
ALTER TABLE typing_exam_highest_record 
ADD UNIQUE KEY IF NOT EXISTS uk_maestro_player_writing (MaestroID, PlayerID, WritingID),
ALGORITHM=INPLACE, LOCK=NONE
--------------

Query OK, 0 rows affected (0.156 sec)
Records: 0  Duplicates: 0  Warnings: 0

Bye
