ALTER TABLE  `cp_txnlog` ADD INDEX (  `account_id` ) ;