-- book_keep.book_keep definition

CREATE TABLE `book_keep` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payNo` varchar(64) NOT NULL DEFAULT '',
  `transNumber` varchar(64) NOT NULL DEFAULT '',
  `insertTime` int(11) NOT NULL DEFAULT '0',
  `isUpload` smallint(6) NOT NULL DEFAULT '0',
  `isDelete` smallint(6) NOT NULL DEFAULT '0',
  `insertDate` varchar(32) NOT NULL DEFAULT '',
  `insertHour` smallint(6) NOT NULL DEFAULT '-1',
  `devNumber` varchar(32) NOT NULL DEFAULT '',
  `serviceId` varchar(16) NOT NULL DEFAULT '',
  `requestTime` int(11) NOT NULL DEFAULT '0',
  `realRequestTime` int(11) NOT NULL DEFAULT '0',
  `plate` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=517 DEFAULT CHARSET=gbk;



-- book_keep.callback_res definition

CREATE TABLE `callback_res` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pay_no` varchar(64) DEFAULT '',
  `callback_time` int(11) DEFAULT '0',
  `callback_date` varchar(32) DEFAULT '',
  `callback_status` smallint(6) DEFAULT '-1',
  `callback_err` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=538 DEFAULT CHARSET=gbk;


-- book_keep.fail_event definition

CREATE TABLE `fail_event` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;


-- book_keep.res_query definition

CREATE TABLE `res_query` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payNo` varchar(64) NOT NULL DEFAULT '',
  `transNumber` varchar(64) NOT NULL DEFAULT '',
  `res` varchar(64) NOT NULL DEFAULT '',
  `plate` varchar(32) NOT NULL DEFAULT '',
  `_date` varchar(46) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1280 DEFAULT CHARSET=gbk;



-- book_keep.trade_revoke definition

CREATE TABLE `trade_revoke` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payNo` varchar(64) NOT NULL DEFAULT '',
  `revokeTime` int(11) NOT NULL DEFAULT '0',
  `res` varchar(32) NOT NULL DEFAULT '-1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=gbk;



-- book_keep.trans_failed definition

CREATE TABLE `trans_failed` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payNo` varchar(64) NOT NULL DEFAULT '',
  `transNumber` varchar(64) NOT NULL DEFAULT '',
  `insertDate` varchar(16) NOT NULL DEFAULT '',
  `insertTime` int(11) NOT NULL DEFAULT '0',
  `isUpload` smallint(6) NOT NULL DEFAULT '0',
  `isDelete` smallint(6) NOT NULL DEFAULT '0',
  `insertHour` smallint(6) NOT NULL DEFAULT '-1',
  `devNumber` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=gbk;
