start transaction;

alter table `sign` add index accountid (`accountid`);
alter table `quest` add index accountid (`accountid`);
alter table `share_achievement` add index accountid (`accountid`);
alter table `equip` add index accountid (`accountid`);

commit;