OMDSCloud/dictation_server/db/migrations/048-add-index-licenses.sql

-- +migrate Up
ALTER TABLE `licenses` ADD INDEX `idx_allocated_user_id` (allocated_user_id);
ALTER TABLE `user_group_member` ADD INDEX `idx_user_id` (user_id);
ALTER TABLE `user_group_member` ADD INDEX `idx_user_group_id` (user_group_id);
ALTER TABLE `users` ADD INDEX `idx_account_id` (account_id);

-- +migrate Down
ALTER TABLE `licenses` DROP INDEX `idx_allocated_user_id`;
ALTER TABLE `user_group_member` DROP INDEX `idx_user_id`;
ALTER TABLE `user_group_member` DROP INDEX `idx_user_group_id`;
ALTER TABLE `users`  DROP INDEX `idx_account_id`;