ALTER DATABASE CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
DROP INDEX accountNumberAndDateIndex ON asset;
DROP INDEX assetGroupIdIndex ON asset;
DROP INDEX cardNumberIndex ON asset;
DROP INDEX sessionIdIndex ON asset;
DROP INDEX terminalNumberIndex ON asset;
ALTER TABLE asset CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
CREATE INDEX accountNumberAndDateIndex ON asset (accountNumber, date);
CREATE INDEX assetGroupIdIndex ON asset (assetGroupId);
CREATE INDEX cardNumberIndex ON asset (cardNumber);
CREATE INDEX sessionIdIndex ON asset (sessionId);
CREATE INDEX terminalNumberIndex ON asset (terminalNumber);
ALTER TABLE account CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE accountingLock CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE accountingSettings CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE actualBalanceOnCard CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE assetGroup CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE assetGroupTransaction CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE assetTransactionStatus CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE cardAccounting CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE cardAccountingAdditionalInfo CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE cardTransaction CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE ereBalanceOnCard CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE firedBonuses CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE migrate_version CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE nearestExpiredAsset CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE pincode CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE scheduleTask CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE scheduleTaskParam CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE terminalAccounting CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE userAccounting CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;