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';
