CREATE TABLE IF NOT EXISTS `sys_actionreader` ( `action` mediumint(8) unsigned NOT NULL, `account` varchar(30) NOT NULL, UNIQUE KEY `reader` (`action`, `account`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ALTER TABLE `cash_trade` ADD `transferID` mediumint(8) unsigned NOT NULL AFTER `loanID`; ALTER TABLE `oa_refund` ADD `trip` mediumint(8) unsigned NOT NULL AFTER `project`; UPDATE `sys_cron` SET `type` = 'zdoo' WHERE `type` = 'ranzhi';