ALTER TABLE `{$prefix}predictions` DROP INDEX `ixUserMatch`;
ALTER TABLE `{$prefix}predictions` ADD PRIMARY KEY (`user_id`, `match_id`) USING BTREE;
ALTER TABLE `{$prefix}predictions` DROP INDEX `ixUser`;
ALTER TABLE `{$prefix}predictions` ADD INDEX `ix_user` (`user_id`) USING BTREE;
ALTER TABLE `{$prefix}predictions` DROP INDEX `ixMatch`;
ALTER TABLE `{$prefix}predictions` ADD INDEX `ix_match` (`match_id`) USING BTREE;
ALTER TABLE `{$prefix}bonusquestions_useranswers` DROP INDEX `ixQuestionId`;
ALTER TABLE `{$prefix}bonusquestions_useranswers` ADD INDEX `ix_question_id` (`question_id`) USING BTREE;
ALTER TABLE `{$prefix}bonusquestions_useranswers` DROP INDEX `ixUserId`;
ALTER TABLE `{$prefix}bonusquestions_useranswers` ADD INDEX `ix_user_id` (`user_id`) USING BTREE;
ALTER TABLE `{$prefix}league_users` DROP INDEX `ixUserLeague`;
ALTER TABLE `{$prefix}league_users` ADD INDEX `ix_user_league` (`user_id`, `league_id`) USING BTREE;
ALTER TABLE `{$prefix}matches` DROP INDEX `ixAwayTeam`;
ALTER TABLE `{$prefix}matches` ADD INDEX `ix_away_team` (`away_team_id`) USING BTREE;
ALTER TABLE `{$prefix}matches` DROP INDEX `ixHomeTeam`;
ALTER TABLE `{$prefix}matches` ADD INDEX `ix_home_team` (`home_team_id`) USING BTREE;
ALTER TABLE `{$prefix}matches` DROP INDEX `ixStadium`;
ALTER TABLE `{$prefix}matches` ADD INDEX `ix_stadium` (`stadium_id`) USING BTREE;
ALTER TABLE `{$prefix}matches` DROP INDEX `ixMatchtype`;
ALTER TABLE `{$prefix}matches` ADD INDEX `ix_matchtype` (`matchtype_id`) USING BTREE;
ALTER TABLE `{$prefix}scorehistory_s1_t1` DROP INDEX `ranking_id`;
ALTER TABLE `{$prefix}scorehistory_s1_t1` ADD INDEX `ix_ranking_score_order_user` (`ranking_id`, `score_order`, `user_id`) USING BTREE;
ALTER TABLE `{$prefix}scorehistory_s1_t2` DROP INDEX `ranking_id`;
ALTER TABLE `{$prefix}scorehistory_s1_t2` ADD INDEX `ix_ranking_score_order_user` (`ranking_id`, `score_order`, `user_id`) USING BTREE;
ALTER TABLE `{$prefix}shoutbox` DROP INDEX `ixDateEntered`;
ALTER TABLE `{$prefix}shoutbox` ADD INDEX `ix_date_entered` (`date_entered`) USING BTREE;
ALTER TABLE `{$prefix}teams` DROP INDEX `ixGroup`;
ALTER TABLE `{$prefix}teams` ADD INDEX `ix_group` (`group_id`) USING BTREE;
ALTER TABLE `{$prefix}teams` DROP INDEX `ixGroupOrder`;
ALTER TABLE `{$prefix}teams` ADD INDEX `ix_group_order` (`group_order`) USING BTREE;
ALTER TABLE `{$prefix}groups` CHANGE `name` `name` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '';
ALTER TABLE `{$prefix}leagues` CHANGE `name` `name` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', CHANGE `image` `image` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE `{$prefix}matchtypes` CHANGE `name` `name` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '';
ALTER TABLE `{$prefix}rankings` CHANGE `name` `name` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '';
ALTER TABLE `{$prefix}stadiums` CHANGE `name` `name` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '';
ALTER TABLE `{$prefix}scorehistory_s1_t1` ADD INDEX(`user_id`) USING BTREE;
ALTER TABLE `{$prefix}scorehistory_s1_t2` ADD INDEX(`user_id`) USING BTREE;
ALTER TABLE `{$prefix}scorehistory_s1_t1` ADD INDEX(`ranking_id`) USING BTREE;
ALTER TABLE `{$prefix}scorehistory_s1_t2` ADD INDEX(`ranking_id`) USING BTREE;
ALTER TABLE `{$prefix}scorehistory_s1_t1` ADD INDEX(`ranking`) USING BTREE;
ALTER TABLE `{$prefix}scorehistory_s1_t2` ADD INDEX(`ranking`) USING BTREE;
ALTER TABLE `{$prefix}scorehistory_s1_t1` ADD INDEX(`score_order`) USING BTREE;
ALTER TABLE `{$prefix}scorehistory_s1_t2` ADD INDEX(`score_order`) USING BTREE;
ALTER TABLE `{$prefix}league_users` ADD INDEX(`league_id`) USING BTREE;
