SET @@sql_mode= '';
alter table `sys_user` add index idx_deleted_id(deleted,id);
alter table `sys_category` add index idx_dele_type_id(deleted,type,id);
alter table `sys_im_message` add index idx_date(date);
alter table `sys_im_conference` add index idx_cgid(cgid);
alter table `sys_im_conferenceaction` add index idx_rid_date(rid,date);
alter table `sys_im_client` add index idx_strategy_status_id(strategy,status,id);
alter table sys_action              ENGINE=INNODB;
alter table sys_block               ENGINE=INNODB;
alter table sys_category            ENGINE=INNODB;
alter table sys_config              ENGINE=INNODB;
alter table sys_cron                ENGINE=INNODB;
alter table sys_entry               ENGINE=INNODB;
alter table sys_file                ENGINE=INNODB;
alter table sys_group               ENGINE=INNODB;
alter table sys_grouppriv           ENGINE=INNODB;
alter table sys_history             ENGINE=INNODB;
alter table sys_im_chat             ENGINE=INNODB;
alter table sys_im_chatuser         ENGINE=INNODB;
alter table sys_im_client           ENGINE=INNODB;
alter table sys_im_conference       ENGINE=INNODB;
alter table sys_im_conferenceaction ENGINE=INNODB;
alter table sys_im_message          ENGINE=INNODB;
alter table sys_im_messagestatus    ENGINE=INNODB;
alter table sys_im_queue            ENGINE=INNODB;
alter table sys_lang                ENGINE=INNODB;
alter table sys_sso                 ENGINE=INNODB;
alter table sys_user                ENGINE=INNODB;
alter table sys_usergroup           ENGINE=INNODB;