ALTER TABLE `actionlog` ADD INDEX  `idx_userid_condoid` (  `user_id`, `condo_id` ) COMMENT  '';
ALTER TABLE `actionlog` ADD INDEX `idx_action` ( `action` ) COMMENT '';
ALTER TABLE `actionlog` ADD INDEX `idx_category` ( `category` ) COMMENT '';
ALTER TABLE `actionlog` ADD INDEX `idx_status` ( `status` ) COMMENT '';

ALTER TABLE `condo_unit_bill` ADD INDEX  `idx_condoid_condounitid` (  `condo_id`, `condo_unit_id` ) COMMENT  '';
ALTER TABLE `condo_unit_bill` ADD INDEX  `idx_month` (  `month` ) COMMENT  '';
ALTER TABLE `condo_unit_bill` ADD INDEX  `idx_year` (  `year` ) COMMENT  '';

ALTER TABLE `condo_unit` ADD INDEX  `idx_condo_id` (  `condo_id` ) COMMENT  '';
ALTER TABLE `condo_unit` ADD INDEX  `idx_house_no` (  `house_no` ) COMMENT  '';

ALTER TABLE `user_role` ADD INDEX  `idx_user_id` (  `user_id` ) COMMENT  '';

ALTER TABLE `user` ADD INDEX  `idx_email` (  `email` ) COMMENT  '';

ALTER TABLE `user_profile` ADD INDEX  `idx_user_id` (  `user_id` ) COMMENT  '';