SET @@sql_mode= '';
alter table `xxb_user` add index idx_deleted_id(deleted,id);
alter table `xxb_category` add index idx_dele_type_id(deleted,type,id);
alter table `xxb_im_message` add index idx_date(date);
alter table `xxb_im_conference` add index idx_cgid(cgid);
alter table `xxb_im_conferenceaction` add index idx_rid_date(rid,date);
alter table `xxb_im_client` add index idx_strategy_status_id(strategy,status,id);
alter table xxb_action              ENGINE=INNODB;
alter table xxb_block               ENGINE=INNODB;
alter table xxb_category            ENGINE=INNODB;
alter table xxb_config              ENGINE=INNODB;
alter table xxb_cron                ENGINE=INNODB;
alter table xxb_entry               ENGINE=INNODB;
alter table xxb_file                ENGINE=INNODB;
alter table xxb_group               ENGINE=INNODB;
alter table xxb_grouppriv           ENGINE=INNODB;
alter table xxb_history             ENGINE=INNODB;
alter table xxb_im_chat             ENGINE=INNODB;
alter table xxb_im_chatuser         ENGINE=INNODB;
alter table xxb_im_client           ENGINE=INNODB;
alter table xxb_im_conference       ENGINE=INNODB;
alter table xxb_im_conferenceaction ENGINE=INNODB;
alter table xxb_im_message          ENGINE=INNODB;
alter table xxb_im_messagestatus    ENGINE=INNODB;
alter table xxb_im_queue            ENGINE=INNODB;
alter table xxb_lang                ENGINE=INNODB;
alter table xxb_sso                 ENGINE=INNODB;
alter table xxb_user                ENGINE=INNODB;
alter table xxb_usergroup           ENGINE=INNODB;
