-- ------------------------------------------------
-- Add indexes to speed up UM report role selection 
-- Created 20150227
-- ------------------------------------------------

ALTER TABLE `um_user_role` 
ADD INDEX `role_del` (`um_delete` ASC, `role_id` ASC);

ALTER TABLE `um_role_tcode` 
ADD INDEX `role_del` (`role_id` ASC, `um_delete` ASC);
