代码拉取完成，页面将自动刷新
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50547
Source Host : localhost:3306
Source Database : huaer
Target Server Type : MYSQL
Target Server Version : 50547
File Encoding : 65001
Date: 2018-05-10 09:11:29
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `tp_admin_access`
-- ----------------------------
DROP TABLE IF EXISTS `tp_admin_access`;
CREATE TABLE `tp_admin_access` (
`role_id` smallint(6) unsigned NOT NULL DEFAULT '0',
`node_id` smallint(6) unsigned NOT NULL DEFAULT '0',
`level` tinyint(1) unsigned NOT NULL DEFAULT '0',
`pid` smallint(6) unsigned NOT NULL DEFAULT '0',
KEY `groupId` (`role_id`),
KEY `nodeId` (`node_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of tp_admin_access
-- ----------------------------
-- ----------------------------
-- Table structure for `tp_admin_group`
-- ----------------------------
DROP TABLE IF EXISTS `tp_admin_group`;
CREATE TABLE `tp_admin_group` (
`id` smallint(3) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
`icon` varchar(255) NOT NULL DEFAULT '' COMMENT 'icon小图标',
`sort` int(11) unsigned NOT NULL DEFAULT '50',
`status` tinyint(1) unsigned NOT NULL DEFAULT '1',
`remark` varchar(255) NOT NULL DEFAULT '',
`isdelete` tinyint(1) unsigned NOT NULL DEFAULT '0',
`create_time` int(11) unsigned NOT NULL DEFAULT '0',
`update_time` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `sort` (`sort`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of tp_admin_group
-- ----------------------------
INSERT INTO `tp_admin_group` VALUES ('1', '系统管理', '', '2', '1', '', '0', '1450752856', '1481180175');
INSERT INTO `tp_admin_group` VALUES ('2', '工具', '', '3', '1', '', '0', '1476016712', '1481180175');
-- ----------------------------
-- Table structure for `tp_admin_node`
-- ----------------------------
DROP TABLE IF EXISTS `tp_admin_node`;
CREATE TABLE `tp_admin_node` (
`id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`pid` smallint(6) unsigned NOT NULL DEFAULT '0',
`group_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL DEFAULT '',
`title` varchar(50) NOT NULL DEFAULT '',
`remark` varchar(255) NOT NULL DEFAULT '',
`level` tinyint(1) unsigned NOT NULL DEFAULT '0',
`type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '节点类型，1-控制器 | 0-方法',
`sort` smallint(6) unsigned NOT NULL DEFAULT '50',
`status` tinyint(1) NOT NULL DEFAULT '0',
`isdelete` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `level` (`level`),
KEY `pid` (`pid`),
KEY `status` (`status`),
KEY `name` (`name`),
KEY `isdelete` (`isdelete`),
KEY `sort` (`sort`),
KEY `group_id` (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of tp_admin_node
-- ----------------------------
INSERT INTO `tp_admin_node` VALUES ('1', '0', '1', 'Admin', '后台管理', '后台管理，不可更改', '1', '1', '1', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('2', '1', '1', 'AdminGroup', '分组管理', ' ', '2', '1', '1', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('3', '1', '1', 'AdminNode', '节点管理', ' ', '2', '1', '2', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('4', '1', '1', 'AdminRole', '角色管理', ' ', '2', '1', '3', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('5', '1', '1', 'AdminUser', '用户管理', '', '2', '1', '4', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('6', '1', '0', 'Index', '首页', '', '2', '1', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('7', '6', '0', 'welcome', '欢迎页', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('8', '6', '0', 'index', '未定义', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('9', '1', '2', 'Generate', '代码自动生成', '', '2', '1', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('10', '1', '2', 'Demo/excel', 'Excel一键导出', '', '2', '0', '2', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('11', '1', '2', 'Demo/download', '下载', '', '2', '0', '3', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('12', '1', '2', 'Demo/downloadImage', '远程图片下载', '', '2', '0', '4', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('13', '1', '2', 'Demo/mail', '邮件发送', '', '2', '0', '5', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('14', '1', '2', 'Demo/qiniu', '七牛上传', '', '2', '0', '6', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('15', '1', '2', 'Demo/hashids', 'ID加密', '', '2', '0', '7', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('16', '1', '2', 'Demo/layer', '丰富弹层', '', '2', '0', '8', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('17', '1', '2', 'Demo/tableFixed', '表格溢出', '', '2', '0', '9', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('18', '1', '2', 'Demo/ueditor', '百度编辑器', '', '2', '0', '10', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('19', '1', '2', 'Demo/imageUpload', '图片上传', '', '2', '0', '11', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('20', '1', '2', 'Demo/qrcode', '二维码生成', '', '2', '0', '12', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('21', '1', '1', 'NodeMap', '节点图', '', '2', '1', '5', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('22', '1', '1', 'WebLog', '操作日志', '', '2', '1', '6', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('23', '1', '1', 'LoginLog', '登录日志', '', '2', '1', '7', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('59', '1', '2', 'one.two.three.Four/index', '多级节点', '', '2', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('24', '23', '0', 'index', '首页', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('25', '22', '0', 'index', '列表', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('26', '22', '0', 'detail', '详情', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('27', '21', '0', 'load', '自动导入', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('28', '21', '0', 'index', '首页', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('29', '5', '0', 'add', '添加', '', '3', '0', '51', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('30', '21', '0', 'edit', '编辑', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('31', '21', '0', 'deleteForever', '永久删除', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('32', '9', '0', 'index', '首页', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('33', '9', '0', 'generate', '生成方法', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('34', '5', '0', 'password', '修改密码', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('35', '5', '0', 'index', '首页', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('36', '5', '0', 'add', '添加', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('37', '5', '0', 'edit', '编辑', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('38', '4', '0', 'user', '用户列表', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('39', '4', '0', 'access', '授权', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('40', '4', '0', 'index', '首页', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('41', '4', '0', 'add', '添加', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('42', '4', '0', 'edit', '编辑', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('43', '4', '0', 'forbid', '默认禁用操作', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('44', '4', '0', 'resume', '默认恢复操作', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('45', '3', '0', 'load', '节点快速导入测试', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('46', '3', '0', 'index', '首页', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('47', '3', '0', 'add', '添加', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('48', '3', '0', 'edit', '编辑', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('49', '3', '0', 'forbid', '默认禁用操作', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('50', '3', '0', 'resume', '默认恢复操作', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('51', '2', '0', 'index', '首页', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('52', '2', '0', 'add', '添加', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('53', '2', '0', 'edit', '编辑', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('54', '2', '0', 'forbid', '默认禁用操作', '', '3', '0', '51', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('55', '2', '0', 'resume', '默认恢复操作', '', '3', '0', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('56', '1', '2', 'one', '一级菜单', '', '2', '1', '13', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('60', '56', '2', 'two', '二级', '', '3', '1', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('61', '60', '2', 'three', '三级菜单', '', '4', '1', '50', '1', '0');
INSERT INTO `tp_admin_node` VALUES ('62', '61', '2', 'Four', '四级菜单', '', '5', '1', '50', '1', '0');
-- ----------------------------
-- Table structure for `tp_admin_node_load`
-- ----------------------------
DROP TABLE IF EXISTS `tp_admin_node_load`;
CREATE TABLE `tp_admin_node_load` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
`name` varchar(255) NOT NULL DEFAULT '' COMMENT '名称',
`status` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '状态',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='节点快速导入';
-- ----------------------------
-- Records of tp_admin_node_load
-- ----------------------------
INSERT INTO `tp_admin_node_load` VALUES ('4', '编辑', 'edit', '1');
INSERT INTO `tp_admin_node_load` VALUES ('5', '添加', 'add', '1');
INSERT INTO `tp_admin_node_load` VALUES ('6', '首页', 'index', '1');
INSERT INTO `tp_admin_node_load` VALUES ('7', '删除', 'delete', '1');
-- ----------------------------
-- Table structure for `tp_admin_role`
-- ----------------------------
DROP TABLE IF EXISTS `tp_admin_role`;
CREATE TABLE `tp_admin_role` (
`id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`pid` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '父级id',
`name` varchar(20) NOT NULL DEFAULT '' COMMENT '名称',
`remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
`status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态',
`isdelete` tinyint(1) unsigned NOT NULL DEFAULT '0',
`create_time` int(11) unsigned NOT NULL DEFAULT '0',
`update_time` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `parentId` (`pid`),
KEY `status` (`status`),
KEY `isdelete` (`isdelete`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of tp_admin_role
-- ----------------------------
INSERT INTO `tp_admin_role` VALUES ('1', '0', '领导组', ' ', '1', '0', '1208784792', '1254325558');
INSERT INTO `tp_admin_role` VALUES ('2', '0', '网编组', ' ', '0', '0', '1215496283', '1454049929');
-- ----------------------------
-- Table structure for `tp_admin_role_user`
-- ----------------------------
DROP TABLE IF EXISTS `tp_admin_role_user`;
CREATE TABLE `tp_admin_role_user` (
`role_id` mediumint(9) unsigned DEFAULT NULL,
`user_id` char(32) DEFAULT NULL,
KEY `group_id` (`role_id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;
-- ----------------------------
-- Records of tp_admin_role_user
-- ----------------------------
-- ----------------------------
-- Table structure for `tp_admin_user`
-- ----------------------------
DROP TABLE IF EXISTS `tp_admin_user`;
CREATE TABLE `tp_admin_user` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`account` char(32) NOT NULL DEFAULT '',
`realname` varchar(255) NOT NULL DEFAULT '',
`password` char(32) NOT NULL DEFAULT '',
`last_login_time` int(11) unsigned NOT NULL DEFAULT '0',
`last_login_ip` char(15) NOT NULL DEFAULT '',
`login_count` mediumint(8) unsigned NOT NULL DEFAULT '0',
`email` varchar(50) NOT NULL DEFAULT '',
`mobile` char(11) NOT NULL DEFAULT '',
`remark` varchar(255) NOT NULL DEFAULT '',
`status` tinyint(1) unsigned NOT NULL DEFAULT '50',
`isdelete` tinyint(1) unsigned NOT NULL DEFAULT '0',
`create_time` int(11) unsigned NOT NULL DEFAULT '0',
`update_time` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `account` (`account`),
KEY `accountpassword` (`account`,`password`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of tp_admin_user
-- ----------------------------
INSERT INTO `tp_admin_user` VALUES ('1', 'admin', '超级管理员', 'e10adc3949ba59abbe56e057f20f883e', '1525879042', '192.168.1.213', '389', 'tianpian0805@gmail.com', '13121126169', '我是超级管理员', '1', '0', '1222907803', '1451033528');
INSERT INTO `tp_admin_user` VALUES ('2', 'demo', '测试', 'e10adc3949ba59abbe56e057f20f883e', '1481206367', '127.0.0.1', '5', '', '', '', '1', '0', '1476777133', '1477399793');
INSERT INTO `tp_admin_user` VALUES ('8', 'sdsssds', 'aasdsa', '4ab47e54c2f73ad4c0eb3974709721cd', '0', '', '0', '', '', '', '50', '0', '0', '0');
INSERT INTO `tp_admin_user` VALUES ('9', 'sdssssds', 'aasdsa', 'd2c6856311a4fab3a33809053aba5096', '0', '', '0', '', '', '', '50', '0', '0', '0');
-- ----------------------------
-- Table structure for `tp_file`
-- ----------------------------
DROP TABLE IF EXISTS `tp_file`;
CREATE TABLE `tp_file` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cate` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '文件类型，1-image | 2-file',
`name` varchar(255) NOT NULL DEFAULT '' COMMENT '文件名',
`original` varchar(255) NOT NULL DEFAULT '' COMMENT '原文件名',
`domain` varchar(255) NOT NULL DEFAULT '',
`type` varchar(255) NOT NULL DEFAULT '',
`size` int(10) unsigned NOT NULL DEFAULT '0',
`mtime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tp_file
-- ----------------------------
-- ----------------------------
-- Table structure for `tp_login_log`
-- ----------------------------
DROP TABLE IF EXISTS `tp_login_log`;
CREATE TABLE `tp_login_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`login_ip` char(15) NOT NULL DEFAULT '',
`login_location` varchar(255) NOT NULL DEFAULT '',
`login_browser` varchar(255) NOT NULL DEFAULT '',
`login_os` varchar(255) NOT NULL DEFAULT '',
`login_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tp_login_log
-- ----------------------------
INSERT INTO `tp_login_log` VALUES ('1', '1', '183.11.68.171', '中国 广东 深圳 ', 'Chrome(64.0.3282.186)', 'Windows 7', '2018-03-22 18:25:15');
INSERT INTO `tp_login_log` VALUES ('2', '1', '192.168.1.213', '局域网 局域网 ', 'Chrome(64.0.3282.186)', 'Windows 7', '2018-05-07 15:23:06');
INSERT INTO `tp_login_log` VALUES ('3', '1', '192.168.1.213', '局域网 局域网 ', 'Chrome(64.0.3282.186)', 'Windows 7', '2018-05-09 23:16:51');
INSERT INTO `tp_login_log` VALUES ('4', '1', '192.168.1.213', '局域网 局域网 ', 'Chrome(64.0.3282.186)', 'Windows 7', '2018-05-09 23:17:22');
-- ----------------------------
-- Table structure for `tp_node_map`
-- ----------------------------
DROP TABLE IF EXISTS `tp_node_map`;
CREATE TABLE `tp_node_map` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`module` varchar(255) NOT NULL DEFAULT '' COMMENT '模块',
`controller` varchar(255) NOT NULL DEFAULT '' COMMENT '控制器',
`action` varchar(255) NOT NULL DEFAULT '' COMMENT '方法',
`method` char(6) NOT NULL DEFAULT '' COMMENT '请求方式',
`comment` varchar(255) NOT NULL DEFAULT '' COMMENT '节点图描述',
PRIMARY KEY (`id`),
KEY `map` (`method`,`module`,`controller`,`action`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='节点图';
-- ----------------------------
-- Records of tp_node_map
-- ----------------------------
-- ----------------------------
-- Table structure for `tp_one_two_three_four`
-- ----------------------------
DROP TABLE IF EXISTS `tp_one_two_three_four`;
CREATE TABLE `tp_one_two_three_four` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '四级控制器主键',
`field1` varchar(255) DEFAULT NULL COMMENT '字段一',
`option` varchar(255) DEFAULT NULL COMMENT '选填',
`select` varchar(255) DEFAULT NULL COMMENT '下拉框',
`radio` varchar(255) DEFAULT NULL COMMENT '单选',
`checkbox` varchar(255) DEFAULT NULL COMMENT '复选框',
`password` varchar(255) DEFAULT NULL COMMENT '密码',
`textarea` varchar(255) DEFAULT NULL COMMENT '文本域',
`date` varchar(255) DEFAULT NULL COMMENT '日期',
`mobile` varchar(255) DEFAULT NULL COMMENT '手机号',
`email` varchar(255) DEFAULT NULL COMMENT '邮箱',
`sort` smallint(5) DEFAULT '50' COMMENT '排序',
`status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态，1-正常 | 0-禁用',
`isdelete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '删除状态，1-删除 | 0-正常',
`create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
`update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`),
KEY `sort` (`sort`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='四级控制器';
-- ----------------------------
-- Records of tp_one_two_three_four
-- ----------------------------
INSERT INTO `tp_one_two_three_four` VALUES ('1', 'yuan1994', 'tpadmin', '2', '1', null, '2222', 'https://github.com/yuan1994/tpadmin', '2016-12-07', '13012345678', 'tianpian0805@gmail.com', '50', '1', '0', '1481947278', '1481947353');
-- ----------------------------
-- Table structure for `tp_pay_record`
-- ----------------------------
DROP TABLE IF EXISTS `tp_pay_record`;
CREATE TABLE `tp_pay_record` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`money` double NOT NULL COMMENT '金额',
`user_id` int(11) NOT NULL COMMENT '用户',
`to_user` int(11) NOT NULL COMMENT '赞赏给谁',
`pay_type` varchar(255) DEFAULT NULL,
`order_type` varchar(255) DEFAULT NULL,
`pay_time` int(11) DEFAULT NULL,
`pay_status` varchar(255) DEFAULT NULL,
`ispaid` tinyint(4) DEFAULT '0',
`out_trade_no` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tp_pay_record
-- ----------------------------
INSERT INTO `tp_pay_record` VALUES ('1', null, '100', '4', '0', 'wx_pay_unifiedorder', 'developer', '1523720395', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('2', null, '100', '4', '0', 'wx_pay_unifiedorder', 'developer', '1523720521', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('3', null, '100', '4', '0', 'wx_pay_unifiedorder', 'developer', '1523720570', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('4', null, '100', '4', '0', 'wx_pay_unifiedorder', 'developer', '1523720597', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('5', null, '100', '4', '0', 'wx_pay_unifiedorder', 'developer', '1523720623', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('6', null, '100', '4', '0', 'wx_pay_unifiedorder', 'developer', '1523720659', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('7', null, '100', '4', '0', 'wx_pay_unifiedorder', 'developer', '1523720693', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('8', null, '100', '4', '0', 'wx_pay_unifiedorder', 'developer', '1523720754', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('9', null, '100', '4', '0', 'wx_pay_unifiedorder', 'developer', '1523720842', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('10', null, '100', '4', '0', 'wx_pay_unifiedorder', 'developer', '1523720884', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('11', null, '100', '4', '0', 'wx_pay_unifiedorder', 'developer', '1523720907', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('12', null, '100', '4', '0', 'wx_pay_unifiedorder', 'developer', '1523721006', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('13', null, '100', '4', '0', 'wx_pay_unifiedorder', 'developer', '1523722974', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('14', null, '100', '4', '0', 'wx_pay_unifiedorder', 'developer', '1523723103', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('15', null, '100', '4', '0', 'wx_pay_unifiedorder', 'developer', '1523723688', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('16', null, '100', '4', '0', 'wx_pay_unifiedorder', 'developer', '1523723797', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('17', null, '100', '4', '0', 'wx_pay_unifiedorder', 'developer', '1523724043', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('18', null, '100', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523726836', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('19', null, '100', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523727386', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('20', null, '100', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523727467', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('21', null, '100', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523727499', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('22', null, '100', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523727604', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('23', null, '100', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523756822', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('24', null, '100', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523756848', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('25', null, '100', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523756965', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('26', null, '100', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523757080', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('27', null, '100', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523757105', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('28', null, '100', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523757183', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('29', null, '100', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523758889', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('30', null, '100', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523758910', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('31', null, '100', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523758953', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('32', null, '100', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523758983', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('33', null, '100', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523759096', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('34', null, '100', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523759553', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('35', null, '100', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523759908', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('36', null, '100', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523759931', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('37', null, '100', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523759956', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('38', null, '100', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523760050', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('39', null, '100', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523760093', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('40', null, '0.01', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523760113', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('41', null, '0.01', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523760159', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('42', null, '0.01', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523760268', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('43', null, '0.01', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523760293', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('44', null, '0.01', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523760574', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('45', null, '0.01', '8', '1', 'wx_pay_unifiedorder', 'developer', '1523760997', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('46', null, '0.01', '8', '1', 'wx_pay_unifiedorder', 'developer', '1523761062', 'paid', '1', '1523761137309001526');
INSERT INTO `tp_pay_record` VALUES ('47', null, '0.01', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523761137', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('48', null, '0.01', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523761490', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('49', null, '0.01', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523796176', 'paying', '0', null);
INSERT INTO `tp_pay_record` VALUES ('50', null, '0.01', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523799194', 'paid', '1', '1523799194163001540');
INSERT INTO `tp_pay_record` VALUES ('51', null, '0.01', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523799927', 'paid', '1', '1523799927245001541');
INSERT INTO `tp_pay_record` VALUES ('52', null, '0.01', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523800137', 'paid', '1', '1523800137452001542');
INSERT INTO `tp_pay_record` VALUES ('53', null, '0.01', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523802684', 'paid', '1', '1523802683981001543');
INSERT INTO `tp_pay_record` VALUES ('54', null, '0.01', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523802916', 'paid', '1', '1523802916302001544');
INSERT INTO `tp_pay_record` VALUES ('55', null, '0.01', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523803134', 'paid', '1', '1523803134003001545');
INSERT INTO `tp_pay_record` VALUES ('56', null, '0.01', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523804948', 'paid', '1', '1523804948704001546');
INSERT INTO `tp_pay_record` VALUES ('57', null, '0.01', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523805073', 'paid', '1', '1523805073733001547');
INSERT INTO `tp_pay_record` VALUES ('58', null, '0.01', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523889996', 'paid', '1', '1523889995958001548');
INSERT INTO `tp_pay_record` VALUES ('59', null, '0.01', '8', '4', 'wx_pay_unifiedorder', 'developer', '1523890288', 'paid', '1', '1523890288918001549');
INSERT INTO `tp_pay_record` VALUES ('60', null, '0.01', '8', '4', 'wx_pay_unifiedorder', 'developer', '1523890642', 'paid', '1', '1523890642399001550');
INSERT INTO `tp_pay_record` VALUES ('61', null, '0.01', '8', '4', 'wx_pay_unifiedorder', 'developer', '1523890992', 'paid', '1', '1523890992932001551');
INSERT INTO `tp_pay_record` VALUES ('62', null, '0.01', '8', '4', 'wx_pay_unifiedorder', 'developer', '1523891132', 'paid', '1', '1523891132638001552');
INSERT INTO `tp_pay_record` VALUES ('63', null, '0.01', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523891237', 'paid', '1', '1523891237761001553');
INSERT INTO `tp_pay_record` VALUES ('64', null, '0.01', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523949655', 'paid', '1', '1523949655839001554');
INSERT INTO `tp_pay_record` VALUES ('65', null, '0.01', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523949735', 'paying', '0', '1523949735945001555');
INSERT INTO `tp_pay_record` VALUES ('66', null, '0.01', '8', '0', 'wx_pay_unifiedorder', 'developer', '1523951121', 'paying', '0', '1523951121102001556');
INSERT INTO `tp_pay_record` VALUES ('67', null, '0.01', '9', '0', 'wx_pay_unifiedorder', 'developer', '1524669993', 'paid', '1', '1524669993817001557');
INSERT INTO `tp_pay_record` VALUES ('68', null, '0.01', '9', '0', 'wx_pay_unifiedorder', 'developer', '1524670189', 'paid', '1', '1524670189578001558');
-- ----------------------------
-- Table structure for `tp_web_log_001`
-- ----------------------------
DROP TABLE IF EXISTS `tp_web_log_001`;
CREATE TABLE `tp_web_log_001` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '日志主键',
`uid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
`ip` char(15) NOT NULL DEFAULT '' COMMENT '访客ip',
`location` varchar(255) NOT NULL DEFAULT '' COMMENT '访客地址',
`os` varchar(255) NOT NULL DEFAULT '' COMMENT '操作系统',
`browser` varchar(255) NOT NULL DEFAULT '' COMMENT '浏览器',
`url` varchar(255) NOT NULL DEFAULT '' COMMENT 'url',
`module` varchar(255) NOT NULL DEFAULT '' COMMENT '模块',
`controller` varchar(255) NOT NULL DEFAULT '' COMMENT '控制器',
`action` varchar(255) NOT NULL DEFAULT '' COMMENT '方法',
`method` char(6) NOT NULL DEFAULT '' COMMENT '请求方式',
`data` text COMMENT '请求的param数据，serialize后的',
`create_at` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作时间',
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `ip` (`ip`),
KEY `create_at` (`create_at`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='网站日志';
-- ----------------------------
-- Records of tp_web_log_001
-- ----------------------------
-- ----------------------------
-- Table structure for `tp_web_log_all`
-- ----------------------------
DROP TABLE IF EXISTS `tp_web_log_all`;
CREATE TABLE `tp_web_log_all` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '日志主键',
`uid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
`ip` char(15) NOT NULL DEFAULT '' COMMENT '访客ip',
`location` varchar(255) NOT NULL DEFAULT '' COMMENT '访客地址',
`os` varchar(255) NOT NULL DEFAULT '' COMMENT '操作系统',
`browser` varchar(255) NOT NULL DEFAULT '' COMMENT '浏览器',
`url` varchar(255) NOT NULL DEFAULT '' COMMENT 'url',
`module` varchar(255) NOT NULL DEFAULT '' COMMENT '模块',
`controller` varchar(255) NOT NULL DEFAULT '' COMMENT '控制器',
`action` varchar(255) NOT NULL DEFAULT '' COMMENT '方法',
`method` char(6) NOT NULL DEFAULT '' COMMENT '请求方式',
`data` text COMMENT '请求的param数据，serialize后的',
`create_at` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作时间',
PRIMARY KEY (`id`),
KEY `uid` (`uid`) USING BTREE,
KEY `ip` (`ip`) USING BTREE,
KEY `create_at` (`create_at`) USING BTREE
) ENGINE=MRG_MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC INSERT_METHOD=LAST UNION=(`tp_web_log_001`) COMMENT='网站日志';
-- ----------------------------
-- Records of tp_web_log_all
-- ----------------------------
-- ----------------------------
-- Table structure for `tp_wechat_config`
-- ----------------------------
DROP TABLE IF EXISTS `tp_wechat_config`;
CREATE TABLE `tp_wechat_config` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`qrc_img` varchar(100) DEFAULT NULL COMMENT '公众号二维码',
`token` varchar(100) DEFAULT NULL COMMENT '接口token',
`appid` varchar(100) DEFAULT NULL COMMENT '公众号 app id',
`encodingaeskey` varchar(100) DEFAULT NULL COMMENT '加密key',
`appsecret` varchar(100) DEFAULT NULL COMMENT '公众号 密钥',
`mch_id` varchar(100) DEFAULT NULL COMMENT '商户身份标识',
`partnerkey` varchar(100) DEFAULT NULL COMMENT '商户权限密钥',
`ssl_cer` text COMMENT '商户证书CER',
`ssl_key` text COMMENT '商户证书KEY',
`create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`config_key` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of tp_wechat_config
-- ----------------------------
INSERT INTO `tp_wechat_config` VALUES ('1', null, 'eefc2d798cf6b881cd5a54c1778fceea', 'wxd5e091c4ca70db43', 'khOVrDfmYiWSVTyDJ6aKvOUWbPf58cwq3FA03L43God', '398f14eac49c4e1b7cbffc1f197d8a58', '1485057832', '65464654654654654564564564986465', '../extend/Wechat/cert/apiclient_cert.pem', '../extend/Wechat/cert/apiclient_key.pem', '2017-08-15 10:48:38', 'qianmeizhixun.520haikushilan.com');
INSERT INTO `tp_wechat_config` VALUES ('2', '', 'reward', 'wx49dd14031d11fc64', 'CJhS7l89OBxco6Qn4zUorisLdflSse0GpLf0UajYb9B', '410bcd4f54ab55ee09bda0a5ffb5956a', '35369995', '65464654654654654564564564986465', '../extend/Wechat/cert/apiclient_cert.pem', '../extend/Wechat/cert/apiclient_key.pem', '2017-08-15 10:48:38', 'reward.520haikushilan.com1');
INSERT INTO `tp_wechat_config` VALUES ('3', null, null, 'wx09e40d493c6a499e', null, '6a8a30d8366d99888ba77bf141daf14b', '1485057832', '65464654654654654564564564986465', '../extend/Wechat/cert/apiclient_cert.pem', '../extend/Wechat/cert/apiclient_key.pem', '2018-04-15 00:57:35', 'reward.520haikushilan.com');
-- ----------------------------
-- Table structure for `tp_weixin_user`
-- ----------------------------
DROP TABLE IF EXISTS `tp_weixin_user`;
CREATE TABLE `tp_weixin_user` (
`openid` varchar(64) NOT NULL DEFAULT '' COMMENT 'open_id各个公众号都会不一样',
`subscribe` tinyint(1) DEFAULT '1' COMMENT '用户是否订阅该公众号标识，值为0时，代表此用户没有关注该公众号，拉取不到其余信息。',
`nickname` varchar(64) DEFAULT '' COMMENT '用户的昵称',
`sex` tinyint(1) DEFAULT '0' COMMENT '用户的性别，值为1时是男性，值为2时是女性，值为0时是未知 ',
`country` varchar(32) DEFAULT '' COMMENT '国家，如中国为CN',
`province` varchar(32) DEFAULT '' COMMENT '用户个人资料填写的省份',
`city` varchar(32) DEFAULT '' COMMENT '普通用户个人资料填写的城市',
`headimgurl` varchar(256) DEFAULT '' COMMENT '用户头像，最后一个数值代表正方形头像大小（有0、46、64、96、132数值可选，0代表640*640正方形头像',
`subscribe_time` datetime DEFAULT '0000-00-00 00:00:00' COMMENT '用户关注时间,如果用户曾多次关注，则取最后关注时间',
`privilege` varchar(256) DEFAULT '' COMMENT '用户特权信息，json 数组，如微信沃卡用户为（chinaunicom）',
`location` varchar(255) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`avatar` varchar(255) DEFAULT NULL,
`create_time` int(11) DEFAULT NULL,
`update_time` int(11) DEFAULT NULL,
`student_user` int(11) DEFAULT NULL COMMENT '微信端学员user_id',
PRIMARY KEY (`openid`),
KEY `openid` (`openid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of tp_weixin_user
-- ----------------------------
-- ----------------------------
-- Table structure for `tp_wx_pay_notify`
-- ----------------------------
DROP TABLE IF EXISTS `tp_wx_pay_notify`;
CREATE TABLE `tp_wx_pay_notify` (
`pay_record_id` int(11) DEFAULT NULL,
`appid` varchar(50) DEFAULT NULL,
`mch_id` varchar(50) DEFAULT NULL,
`transaction_id` varchar(50) DEFAULT NULL,
`out_trade_no` varchar(50) DEFAULT NULL,
`nonce_str` varchar(50) DEFAULT NULL,
`sign` varchar(50) DEFAULT NULL,
`sign_type` varchar(50) DEFAULT NULL,
`id` int(50) NOT NULL AUTO_INCREMENT,
`create_time` int(11) DEFAULT NULL,
`result` text,
`result_code` varchar(50) DEFAULT NULL,
`err_code` varchar(50) DEFAULT NULL,
`err_code_des` varchar(50) DEFAULT NULL,
`bank_type` varchar(255) DEFAULT NULL,
`cash_fee` varchar(255) DEFAULT NULL,
`fee_type` varchar(255) DEFAULT NULL,
`is_subscribe` varchar(255) DEFAULT NULL,
`openid` varchar(255) DEFAULT NULL,
`return_code` varchar(255) DEFAULT NULL,
`time_end` varchar(255) DEFAULT NULL,
`total_fee` varchar(255) DEFAULT NULL,
`trade_type` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=131 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tp_wx_pay_notify
-- ----------------------------
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000075201804159439206694', '1523803134003001545', 'hupytn460sfd6hywfoc2ym8eaqejs60g', 'F81AE4DBC83F6BB41D3D9C904020944C', null, '1', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415223901', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000075201804159439206694', '1523803134003001545', 'hupytn460sfd6hywfoc2ym8eaqejs60g', 'F81AE4DBC83F6BB41D3D9C904020944C', null, '2', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415223901', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000066201804159258785240', '1523802683981001543', 'o110ekkyihv1vnq5k8anzhe8w5254h06', 'F9263EF6F58F501E91B7AAEE36D443E8', null, '3', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415223142', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000057201804159442437098', '1523799194163001540', '7dx2349h844vruukps8kyzs0cwcutcv4', '6C5C25E0494A974E3062A646C5F7B445', null, '4', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415213335', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000077201804159407493098', '1523805073733001547', 'tcm1tumngb4uwyb6jrtvj67van5k03yv', '16D5069F0CF581FF96B74D547E534545', null, '5', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415231128', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000077201804159407493098', '1523805073733001547', 'tcm1tumngb4uwyb6jrtvj67van5k03yv', '16D5069F0CF581FF96B74D547E534545', null, '6', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415231128', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000077201804159407493098', '1523805073733001547', 'tcm1tumngb4uwyb6jrtvj67van5k03yv', '16D5069F0CF581FF96B74D547E534545', null, '7', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415231128', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000077201804159407493098', '1523805073733001547', 'tcm1tumngb4uwyb6jrtvj67van5k03yv', '16D5069F0CF581FF96B74D547E534545', null, '8', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415231128', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000075201804159439206694', '1523803134003001545', 'hupytn460sfd6hywfoc2ym8eaqejs60g', 'F81AE4DBC83F6BB41D3D9C904020944C', null, '9', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415223901', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804159503580086', '1523804948704001546', 'dsr6g6xyffenwg4d2w4i8mu0x8v705yz', '95D30C1D30D2E8CF77B92D04A21C52BB', null, '10', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415230924', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000077201804159407493098', '1523805073733001547', 'tcm1tumngb4uwyb6jrtvj67van5k03yv', '16D5069F0CF581FF96B74D547E534545', null, '11', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415231128', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000067201804159422552375', '1523799927245001541', 'gnpfy6h0do7qqml22tkzwkqe5baq0t54', '8D10EA20DC25E169F9E1375570FB494F', null, '12', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415214550', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804159326756877', '1523800137452001542', '3p3i7k62mmlau8w5m1yzsrndzrcz3dw1', 'A402E88B7C66D780FFC5A5A5D0DE3139', null, '13', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415214913', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000066201804159258785240', '1523802683981001543', 'o110ekkyihv1vnq5k8anzhe8w5254h06', 'F9263EF6F58F501E91B7AAEE36D443E8', null, '14', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415223142', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000057201804159442437098', '1523799194163001540', '7dx2349h844vruukps8kyzs0cwcutcv4', '6C5C25E0494A974E3062A646C5F7B445', null, '15', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415213335', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000079201804159505608939', '1523802916302001544', 'msrcmckysk9mutz3ey8orip19y4r5un1', 'D68E772EFEFF0C872D2C4F29A9E02482', null, '16', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415223526', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000075201804159439206694', '1523803134003001545', 'hupytn460sfd6hywfoc2ym8eaqejs60g', 'F81AE4DBC83F6BB41D3D9C904020944C', null, '17', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415223901', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804159503580086', '1523804948704001546', 'dsr6g6xyffenwg4d2w4i8mu0x8v705yz', '95D30C1D30D2E8CF77B92D04A21C52BB', null, '18', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415230924', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000077201804159407493098', '1523805073733001547', 'tcm1tumngb4uwyb6jrtvj67van5k03yv', '16D5069F0CF581FF96B74D547E534545', null, '19', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415231128', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000067201804159422552375', '1523799927245001541', 'gnpfy6h0do7qqml22tkzwkqe5baq0t54', '8D10EA20DC25E169F9E1375570FB494F', null, '20', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415214550', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804159326756877', '1523800137452001542', '3p3i7k62mmlau8w5m1yzsrndzrcz3dw1', 'A402E88B7C66D780FFC5A5A5D0DE3139', null, '21', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415214913', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000066201804159258785240', '1523802683981001543', 'o110ekkyihv1vnq5k8anzhe8w5254h06', 'F9263EF6F58F501E91B7AAEE36D443E8', null, '22', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415223142', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000079201804159505608939', '1523802916302001544', 'msrcmckysk9mutz3ey8orip19y4r5un1', 'D68E772EFEFF0C872D2C4F29A9E02482', null, '23', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415223526', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000075201804159439206694', '1523803134003001545', 'hupytn460sfd6hywfoc2ym8eaqejs60g', 'F81AE4DBC83F6BB41D3D9C904020944C', null, '24', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415223901', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804159503580086', '1523804948704001546', 'dsr6g6xyffenwg4d2w4i8mu0x8v705yz', '95D30C1D30D2E8CF77B92D04A21C52BB', null, '25', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415230924', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000077201804159407493098', '1523805073733001547', 'tcm1tumngb4uwyb6jrtvj67van5k03yv', '16D5069F0CF581FF96B74D547E534545', null, '26', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415231128', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000066201804159258785240', '1523802683981001543', 'o110ekkyihv1vnq5k8anzhe8w5254h06', 'F9263EF6F58F501E91B7AAEE36D443E8', null, '27', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415223142', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000057201804159442437098', '1523799194163001540', '7dx2349h844vruukps8kyzs0cwcutcv4', '6C5C25E0494A974E3062A646C5F7B445', null, '28', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415213335', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000079201804159505608939', '1523802916302001544', 'msrcmckysk9mutz3ey8orip19y4r5un1', 'D68E772EFEFF0C872D2C4F29A9E02482', null, '29', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415223526', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000075201804159439206694', '1523803134003001545', 'hupytn460sfd6hywfoc2ym8eaqejs60g', 'F81AE4DBC83F6BB41D3D9C904020944C', null, '30', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415223901', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804159503580086', '1523804948704001546', 'dsr6g6xyffenwg4d2w4i8mu0x8v705yz', '95D30C1D30D2E8CF77B92D04A21C52BB', null, '31', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415230924', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000077201804159407493098', '1523805073733001547', 'tcm1tumngb4uwyb6jrtvj67van5k03yv', '16D5069F0CF581FF96B74D547E534545', null, '32', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415231128', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000067201804159422552375', '1523799927245001541', 'gnpfy6h0do7qqml22tkzwkqe5baq0t54', '8D10EA20DC25E169F9E1375570FB494F', null, '33', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415214550', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804159326756877', '1523800137452001542', '3p3i7k62mmlau8w5m1yzsrndzrcz3dw1', 'A402E88B7C66D780FFC5A5A5D0DE3139', null, '34', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415214913', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804159503580086', '1523804948704001546', 'dsr6g6xyffenwg4d2w4i8mu0x8v705yz', '95D30C1D30D2E8CF77B92D04A21C52BB', null, '35', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415230924', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000077201804159407493098', '1523805073733001547', 'tcm1tumngb4uwyb6jrtvj67van5k03yv', '16D5069F0CF581FF96B74D547E534545', null, '36', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415231128', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000066201804159258785240', '1523802683981001543', 'o110ekkyihv1vnq5k8anzhe8w5254h06', 'F9263EF6F58F501E91B7AAEE36D443E8', null, '37', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415223142', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000079201804159505608939', '1523802916302001544', 'msrcmckysk9mutz3ey8orip19y4r5un1', 'D68E772EFEFF0C872D2C4F29A9E02482', null, '38', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415223526', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000075201804159439206694', '1523803134003001545', 'hupytn460sfd6hywfoc2ym8eaqejs60g', 'F81AE4DBC83F6BB41D3D9C904020944C', null, '39', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415223901', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804159503580086', '1523804948704001546', 'dsr6g6xyffenwg4d2w4i8mu0x8v705yz', '95D30C1D30D2E8CF77B92D04A21C52BB', null, '40', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415230924', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000077201804159407493098', '1523805073733001547', 'tcm1tumngb4uwyb6jrtvj67van5k03yv', '16D5069F0CF581FF96B74D547E534545', null, '41', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180415231128', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000076201804160190485379', '1523889995958001548', 'rk4tenrz21m4xb31930at52g7beb30na', 'F135CD5D4DBFD0064ADE7910972DFC76', null, '42', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416224655', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000076201804160190485379', '1523889995958001548', 'rk4tenrz21m4xb31930at52g7beb30na', 'F135CD5D4DBFD0064ADE7910972DFC76', null, '43', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416224655', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000076201804160190485379', '1523889995958001548', 'rk4tenrz21m4xb31930at52g7beb30na', 'F135CD5D4DBFD0064ADE7910972DFC76', null, '44', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416224655', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000076201804160190485379', '1523889995958001548', 'rk4tenrz21m4xb31930at52g7beb30na', 'F135CD5D4DBFD0064ADE7910972DFC76', null, '45', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416224655', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000076201804160190485379', '1523889995958001548', 'rk4tenrz21m4xb31930at52g7beb30na', 'F135CD5D4DBFD0064ADE7910972DFC76', null, '46', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416224655', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804169981263385', '1523890288918001549', '8vyk8naag1gamzs2d6ok3locuplvgbqf', '1F653223F0BD2DBEA551134C7F2575B3', null, '47', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416225155', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804169981263385', '1523890288918001549', '8vyk8naag1gamzs2d6ok3locuplvgbqf', '1F653223F0BD2DBEA551134C7F2575B3', null, '48', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416225155', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804169981263385', '1523890288918001549', '8vyk8naag1gamzs2d6ok3locuplvgbqf', '1F653223F0BD2DBEA551134C7F2575B3', null, '49', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416225155', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804169981263385', '1523890288918001549', '8vyk8naag1gamzs2d6ok3locuplvgbqf', '1F653223F0BD2DBEA551134C7F2575B3', null, '50', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416225155', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804169981263385', '1523890288918001549', '8vyk8naag1gamzs2d6ok3locuplvgbqf', '1F653223F0BD2DBEA551134C7F2575B3', null, '51', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416225155', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000079201804160126386227', '1523890642399001550', 'utszke2dojpp593drsk5dn6lo01a9v9x', '9573A3429BB38AA8F027F2B944ED42A2', null, '52', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416225748', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000079201804160126386227', '1523890642399001550', 'utszke2dojpp593drsk5dn6lo01a9v9x', '9573A3429BB38AA8F027F2B944ED42A2', null, '53', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416225748', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000079201804160126386227', '1523890642399001550', 'utszke2dojpp593drsk5dn6lo01a9v9x', '9573A3429BB38AA8F027F2B944ED42A2', null, '54', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416225748', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000079201804160126386227', '1523890642399001550', 'utszke2dojpp593drsk5dn6lo01a9v9x', '9573A3429BB38AA8F027F2B944ED42A2', null, '55', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416225748', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000079201804160126386227', '1523890642399001550', 'utszke2dojpp593drsk5dn6lo01a9v9x', '9573A3429BB38AA8F027F2B944ED42A2', null, '56', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416225748', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000076201804160080753894', '1523890992932001551', 'p6t362uyogvkav4uba13gz5119297f29', '079AA5B4614590DAED28B360C06D7442', null, '57', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230327', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000076201804160080753894', '1523890992932001551', 'p6t362uyogvkav4uba13gz5119297f29', '079AA5B4614590DAED28B360C06D7442', null, '58', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230327', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000076201804160080753894', '1523890992932001551', 'p6t362uyogvkav4uba13gz5119297f29', '079AA5B4614590DAED28B360C06D7442', null, '59', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230327', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000076201804160080753894', '1523890992932001551', 'p6t362uyogvkav4uba13gz5119297f29', '079AA5B4614590DAED28B360C06D7442', null, '60', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230327', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000062201804160161769669', '1523891132638001552', 'shv3iw4g43a1j831ydyt1ug783uxjw0o', '65B8BE2A1679C1E09C527E3C383E72E6', null, '61', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230545', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000062201804160161769669', '1523891132638001552', 'shv3iw4g43a1j831ydyt1ug783uxjw0o', '65B8BE2A1679C1E09C527E3C383E72E6', null, '62', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230545', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000062201804160161769669', '1523891132638001552', 'shv3iw4g43a1j831ydyt1ug783uxjw0o', '65B8BE2A1679C1E09C527E3C383E72E6', null, '63', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230545', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000062201804160161769669', '1523891132638001552', 'shv3iw4g43a1j831ydyt1ug783uxjw0o', '65B8BE2A1679C1E09C527E3C383E72E6', null, '64', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230545', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000065201804169671660312', '1523891237761001553', 'ldk9gfjrywtin91ee3yg5a86mnlydgrj', '023EA012CF2BC791B035356B8A11B676', null, '65', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230732', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000076201804160080753894', '1523890992932001551', 'p6t362uyogvkav4uba13gz5119297f29', '079AA5B4614590DAED28B360C06D7442', null, '66', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230327', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000065201804169671660312', '1523891237761001553', 'ldk9gfjrywtin91ee3yg5a86mnlydgrj', '023EA012CF2BC791B035356B8A11B676', null, '67', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230732', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000065201804169671660312', '1523891237761001553', 'ldk9gfjrywtin91ee3yg5a86mnlydgrj', '023EA012CF2BC791B035356B8A11B676', null, '68', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230732', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000065201804169671660312', '1523891237761001553', 'ldk9gfjrywtin91ee3yg5a86mnlydgrj', '023EA012CF2BC791B035356B8A11B676', null, '69', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230732', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000062201804160161769669', '1523891132638001552', 'shv3iw4g43a1j831ydyt1ug783uxjw0o', '65B8BE2A1679C1E09C527E3C383E72E6', null, '70', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230545', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000065201804169671660312', '1523891237761001553', 'ldk9gfjrywtin91ee3yg5a86mnlydgrj', '023EA012CF2BC791B035356B8A11B676', null, '71', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230732', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000076201804160190485379', '1523889995958001548', 'rk4tenrz21m4xb31930at52g7beb30na', 'F135CD5D4DBFD0064ADE7910972DFC76', null, '72', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416224655', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804169981263385', '1523890288918001549', '8vyk8naag1gamzs2d6ok3locuplvgbqf', '1F653223F0BD2DBEA551134C7F2575B3', null, '73', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416225155', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000079201804160126386227', '1523890642399001550', 'utszke2dojpp593drsk5dn6lo01a9v9x', '9573A3429BB38AA8F027F2B944ED42A2', null, '74', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416225748', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000076201804160080753894', '1523890992932001551', 'p6t362uyogvkav4uba13gz5119297f29', '079AA5B4614590DAED28B360C06D7442', null, '75', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230327', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000062201804160161769669', '1523891132638001552', 'shv3iw4g43a1j831ydyt1ug783uxjw0o', '65B8BE2A1679C1E09C527E3C383E72E6', null, '76', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230545', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000065201804169671660312', '1523891237761001553', 'ldk9gfjrywtin91ee3yg5a86mnlydgrj', '023EA012CF2BC791B035356B8A11B676', null, '77', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230732', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000076201804160190485379', '1523889995958001548', 'rk4tenrz21m4xb31930at52g7beb30na', 'F135CD5D4DBFD0064ADE7910972DFC76', null, '78', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416224655', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804169981263385', '1523890288918001549', '8vyk8naag1gamzs2d6ok3locuplvgbqf', '1F653223F0BD2DBEA551134C7F2575B3', null, '79', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416225155', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000079201804160126386227', '1523890642399001550', 'utszke2dojpp593drsk5dn6lo01a9v9x', '9573A3429BB38AA8F027F2B944ED42A2', null, '80', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416225748', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000076201804160080753894', '1523890992932001551', 'p6t362uyogvkav4uba13gz5119297f29', '079AA5B4614590DAED28B360C06D7442', null, '81', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230327', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000062201804160161769669', '1523891132638001552', 'shv3iw4g43a1j831ydyt1ug783uxjw0o', '65B8BE2A1679C1E09C527E3C383E72E6', null, '82', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230545', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000065201804169671660312', '1523891237761001553', 'ldk9gfjrywtin91ee3yg5a86mnlydgrj', '023EA012CF2BC791B035356B8A11B676', null, '83', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230732', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804169981263385', '1523890288918001549', '8vyk8naag1gamzs2d6ok3locuplvgbqf', '1F653223F0BD2DBEA551134C7F2575B3', null, '84', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416225155', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000079201804160126386227', '1523890642399001550', 'utszke2dojpp593drsk5dn6lo01a9v9x', '9573A3429BB38AA8F027F2B944ED42A2', null, '85', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416225748', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000076201804160080753894', '1523890992932001551', 'p6t362uyogvkav4uba13gz5119297f29', '079AA5B4614590DAED28B360C06D7442', null, '86', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230327', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000062201804160161769669', '1523891132638001552', 'shv3iw4g43a1j831ydyt1ug783uxjw0o', '65B8BE2A1679C1E09C527E3C383E72E6', null, '87', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230545', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000065201804169671660312', '1523891237761001553', 'ldk9gfjrywtin91ee3yg5a86mnlydgrj', '023EA012CF2BC791B035356B8A11B676', null, '88', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230732', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000076201804160190485379', '1523889995958001548', 'rk4tenrz21m4xb31930at52g7beb30na', 'F135CD5D4DBFD0064ADE7910972DFC76', null, '89', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416224655', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804169981263385', '1523890288918001549', '8vyk8naag1gamzs2d6ok3locuplvgbqf', '1F653223F0BD2DBEA551134C7F2575B3', null, '90', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416225155', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000079201804160126386227', '1523890642399001550', 'utszke2dojpp593drsk5dn6lo01a9v9x', '9573A3429BB38AA8F027F2B944ED42A2', null, '91', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416225748', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000076201804160080753894', '1523890992932001551', 'p6t362uyogvkav4uba13gz5119297f29', '079AA5B4614590DAED28B360C06D7442', null, '92', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230327', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000062201804160161769669', '1523891132638001552', 'shv3iw4g43a1j831ydyt1ug783uxjw0o', '65B8BE2A1679C1E09C527E3C383E72E6', null, '93', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230545', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000065201804169671660312', '1523891237761001553', 'ldk9gfjrywtin91ee3yg5a86mnlydgrj', '023EA012CF2BC791B035356B8A11B676', null, '94', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230732', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000076201804160190485379', '1523889995958001548', 'rk4tenrz21m4xb31930at52g7beb30na', 'F135CD5D4DBFD0064ADE7910972DFC76', null, '95', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416224655', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804169981263385', '1523890288918001549', '8vyk8naag1gamzs2d6ok3locuplvgbqf', '1F653223F0BD2DBEA551134C7F2575B3', null, '96', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416225155', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000079201804160126386227', '1523890642399001550', 'utszke2dojpp593drsk5dn6lo01a9v9x', '9573A3429BB38AA8F027F2B944ED42A2', null, '97', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416225748', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000076201804160080753894', '1523890992932001551', 'p6t362uyogvkav4uba13gz5119297f29', '079AA5B4614590DAED28B360C06D7442', null, '98', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230327', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000062201804160161769669', '1523891132638001552', 'shv3iw4g43a1j831ydyt1ug783uxjw0o', '65B8BE2A1679C1E09C527E3C383E72E6', null, '99', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230545', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000065201804169671660312', '1523891237761001553', 'ldk9gfjrywtin91ee3yg5a86mnlydgrj', '023EA012CF2BC791B035356B8A11B676', null, '100', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180416230732', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804170514147522', '1523949655839001554', 'fhtepeuf4obwstshpc9sxjxxbcbahyh5', '6AD2882E47AAF226AE6C13B0E0CB7281', null, '101', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180417152135', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804170514147522', '1523949655839001554', 'fhtepeuf4obwstshpc9sxjxxbcbahyh5', '6AD2882E47AAF226AE6C13B0E0CB7281', null, '102', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180417152135', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804170514147522', '1523949655839001554', 'fhtepeuf4obwstshpc9sxjxxbcbahyh5', '6AD2882E47AAF226AE6C13B0E0CB7281', null, '103', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180417152135', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804170514147522', '1523949655839001554', 'fhtepeuf4obwstshpc9sxjxxbcbahyh5', '6AD2882E47AAF226AE6C13B0E0CB7281', null, '104', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180417152135', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804170514147522', '1523949655839001554', 'fhtepeuf4obwstshpc9sxjxxbcbahyh5', '6AD2882E47AAF226AE6C13B0E0CB7281', null, '105', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180417152135', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804170514147522', '1523949655839001554', 'fhtepeuf4obwstshpc9sxjxxbcbahyh5', '6AD2882E47AAF226AE6C13B0E0CB7281', null, '106', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180417152135', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804170514147522', '1523949655839001554', 'fhtepeuf4obwstshpc9sxjxxbcbahyh5', '6AD2882E47AAF226AE6C13B0E0CB7281', null, '107', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180417152135', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804170514147522', '1523949655839001554', 'fhtepeuf4obwstshpc9sxjxxbcbahyh5', '6AD2882E47AAF226AE6C13B0E0CB7281', null, '108', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180417152135', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804170514147522', '1523949655839001554', 'fhtepeuf4obwstshpc9sxjxxbcbahyh5', '6AD2882E47AAF226AE6C13B0E0CB7281', null, '109', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180417152135', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000074201804170514147522', '1523949655839001554', 'fhtepeuf4obwstshpc9sxjxxbcbahyh5', '6AD2882E47AAF226AE6C13B0E0CB7281', null, '110', null, null, 'SUCCESS', null, null, 'CMB_DEBIT', '1', 'CNY', 'N', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'SUCCESS', '20180417152135', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000066201804256276126442', '1524669993817001557', '2sr5qh2lcfw0jnn4kqr7il4w1iey4zu9', '154B5CB8B3ABC8FC789E830C9843A00F', null, '111', null, null, 'SUCCESS', null, null, 'CFT', '1', 'CNY', 'N', 'owPge0Qh_5D4owMeRzOLad5TnAPM', 'SUCCESS', '20180425232702', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000066201804256276126442', '1524669993817001557', '2sr5qh2lcfw0jnn4kqr7il4w1iey4zu9', '154B5CB8B3ABC8FC789E830C9843A00F', null, '112', null, null, 'SUCCESS', null, null, 'CFT', '1', 'CNY', 'N', 'owPge0Qh_5D4owMeRzOLad5TnAPM', 'SUCCESS', '20180425232702', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000066201804256276126442', '1524669993817001557', '2sr5qh2lcfw0jnn4kqr7il4w1iey4zu9', '154B5CB8B3ABC8FC789E830C9843A00F', null, '113', null, null, 'SUCCESS', null, null, 'CFT', '1', 'CNY', 'N', 'owPge0Qh_5D4owMeRzOLad5TnAPM', 'SUCCESS', '20180425232702', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000066201804256276126442', '1524669993817001557', '2sr5qh2lcfw0jnn4kqr7il4w1iey4zu9', '154B5CB8B3ABC8FC789E830C9843A00F', null, '114', null, null, 'SUCCESS', null, null, 'CFT', '1', 'CNY', 'N', 'owPge0Qh_5D4owMeRzOLad5TnAPM', 'SUCCESS', '20180425232702', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000059201804256221655969', '1524670189578001558', 'rzqk87h00w64dpagxjzx9lt3g23hjk42', '61747E591F73B09D755C669DA367831E', null, '115', null, null, 'SUCCESS', null, null, 'CFT', '1', 'CNY', 'N', 'owPge0Qh_5D4owMeRzOLad5TnAPM', 'SUCCESS', '20180425232955', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000059201804256221655969', '1524670189578001558', 'rzqk87h00w64dpagxjzx9lt3g23hjk42', '61747E591F73B09D755C669DA367831E', null, '116', null, null, 'SUCCESS', null, null, 'CFT', '1', 'CNY', 'N', 'owPge0Qh_5D4owMeRzOLad5TnAPM', 'SUCCESS', '20180425232955', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000059201804256221655969', '1524670189578001558', 'rzqk87h00w64dpagxjzx9lt3g23hjk42', '61747E591F73B09D755C669DA367831E', null, '117', null, null, 'SUCCESS', null, null, 'CFT', '1', 'CNY', 'N', 'owPge0Qh_5D4owMeRzOLad5TnAPM', 'SUCCESS', '20180425232955', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000059201804256221655969', '1524670189578001558', 'rzqk87h00w64dpagxjzx9lt3g23hjk42', '61747E591F73B09D755C669DA367831E', null, '118', null, null, 'SUCCESS', null, null, 'CFT', '1', 'CNY', 'N', 'owPge0Qh_5D4owMeRzOLad5TnAPM', 'SUCCESS', '20180425232955', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000066201804256276126442', '1524669993817001557', '2sr5qh2lcfw0jnn4kqr7il4w1iey4zu9', '154B5CB8B3ABC8FC789E830C9843A00F', null, '119', null, null, 'SUCCESS', null, null, 'CFT', '1', 'CNY', 'N', 'owPge0Qh_5D4owMeRzOLad5TnAPM', 'SUCCESS', '20180425232702', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000059201804256221655969', '1524670189578001558', 'rzqk87h00w64dpagxjzx9lt3g23hjk42', '61747E591F73B09D755C669DA367831E', null, '120', null, null, 'SUCCESS', null, null, 'CFT', '1', 'CNY', 'N', 'owPge0Qh_5D4owMeRzOLad5TnAPM', 'SUCCESS', '20180425232955', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000066201804256276126442', '1524669993817001557', '2sr5qh2lcfw0jnn4kqr7il4w1iey4zu9', '154B5CB8B3ABC8FC789E830C9843A00F', null, '121', null, null, 'SUCCESS', null, null, 'CFT', '1', 'CNY', 'N', 'owPge0Qh_5D4owMeRzOLad5TnAPM', 'SUCCESS', '20180425232702', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000059201804256221655969', '1524670189578001558', 'rzqk87h00w64dpagxjzx9lt3g23hjk42', '61747E591F73B09D755C669DA367831E', null, '122', null, null, 'SUCCESS', null, null, 'CFT', '1', 'CNY', 'N', 'owPge0Qh_5D4owMeRzOLad5TnAPM', 'SUCCESS', '20180425232955', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000066201804256276126442', '1524669993817001557', '2sr5qh2lcfw0jnn4kqr7il4w1iey4zu9', '154B5CB8B3ABC8FC789E830C9843A00F', null, '123', null, null, 'SUCCESS', null, null, 'CFT', '1', 'CNY', 'N', 'owPge0Qh_5D4owMeRzOLad5TnAPM', 'SUCCESS', '20180425232702', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000059201804256221655969', '1524670189578001558', 'rzqk87h00w64dpagxjzx9lt3g23hjk42', '61747E591F73B09D755C669DA367831E', null, '124', null, null, 'SUCCESS', null, null, 'CFT', '1', 'CNY', 'N', 'owPge0Qh_5D4owMeRzOLad5TnAPM', 'SUCCESS', '20180425232955', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000066201804256276126442', '1524669993817001557', '2sr5qh2lcfw0jnn4kqr7il4w1iey4zu9', '154B5CB8B3ABC8FC789E830C9843A00F', null, '125', null, null, 'SUCCESS', null, null, 'CFT', '1', 'CNY', 'N', 'owPge0Qh_5D4owMeRzOLad5TnAPM', 'SUCCESS', '20180425232702', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000059201804256221655969', '1524670189578001558', 'rzqk87h00w64dpagxjzx9lt3g23hjk42', '61747E591F73B09D755C669DA367831E', null, '126', null, null, 'SUCCESS', null, null, 'CFT', '1', 'CNY', 'N', 'owPge0Qh_5D4owMeRzOLad5TnAPM', 'SUCCESS', '20180425232955', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000066201804256276126442', '1524669993817001557', '2sr5qh2lcfw0jnn4kqr7il4w1iey4zu9', '154B5CB8B3ABC8FC789E830C9843A00F', null, '127', null, null, 'SUCCESS', null, null, 'CFT', '1', 'CNY', 'N', 'owPge0Qh_5D4owMeRzOLad5TnAPM', 'SUCCESS', '20180425232702', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000059201804256221655969', '1524670189578001558', 'rzqk87h00w64dpagxjzx9lt3g23hjk42', '61747E591F73B09D755C669DA367831E', null, '128', null, null, 'SUCCESS', null, null, 'CFT', '1', 'CNY', 'N', 'owPge0Qh_5D4owMeRzOLad5TnAPM', 'SUCCESS', '20180425232955', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000066201804256276126442', '1524669993817001557', '2sr5qh2lcfw0jnn4kqr7il4w1iey4zu9', '154B5CB8B3ABC8FC789E830C9843A00F', null, '129', null, null, 'SUCCESS', null, null, 'CFT', '1', 'CNY', 'N', 'owPge0Qh_5D4owMeRzOLad5TnAPM', 'SUCCESS', '20180425232702', '1', 'JSAPI');
INSERT INTO `tp_wx_pay_notify` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000059201804256221655969', '1524670189578001558', 'rzqk87h00w64dpagxjzx9lt3g23hjk42', '61747E591F73B09D755C669DA367831E', null, '130', null, null, 'SUCCESS', null, null, 'CFT', '1', 'CNY', 'N', 'owPge0Qh_5D4owMeRzOLad5TnAPM', 'SUCCESS', '20180425232955', '1', 'JSAPI');
-- ----------------------------
-- Table structure for `tp_wx_pay_orderquery`
-- ----------------------------
DROP TABLE IF EXISTS `tp_wx_pay_orderquery`;
CREATE TABLE `tp_wx_pay_orderquery` (
`pay_record_id` int(11) DEFAULT NULL,
`appid` varchar(50) DEFAULT NULL,
`mch_id` varchar(50) DEFAULT NULL,
`transaction_id` varchar(50) DEFAULT NULL,
`out_trade_no` varchar(50) DEFAULT NULL,
`nonce_str` varchar(50) DEFAULT NULL,
`sign` varchar(50) DEFAULT NULL,
`sign_type` varchar(50) DEFAULT NULL,
`id` int(50) NOT NULL AUTO_INCREMENT,
`create_time` int(11) DEFAULT NULL,
`result_code` varchar(50) DEFAULT NULL,
`err_code` varchar(50) DEFAULT NULL,
`err_code_des` varchar(50) DEFAULT NULL,
`result` text,
`trade_state` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tp_wx_pay_orderquery
-- ----------------------------
-- ----------------------------
-- Table structure for `tp_wx_pay_query`
-- ----------------------------
DROP TABLE IF EXISTS `tp_wx_pay_query`;
CREATE TABLE `tp_wx_pay_query` (
`pay_record_id` int(11) DEFAULT NULL,
`appid` varchar(50) DEFAULT NULL,
`mch_id` varchar(50) DEFAULT NULL,
`transaction_id` varchar(50) DEFAULT NULL,
`out_trade_no` varchar(50) DEFAULT NULL,
`nonce_str` varchar(50) DEFAULT NULL,
`sign` varchar(50) DEFAULT NULL,
`sign_type` varchar(50) DEFAULT NULL,
`id` int(50) NOT NULL AUTO_INCREMENT,
`create_time` int(11) DEFAULT NULL,
`result_code` varchar(50) DEFAULT NULL,
`err_code` varchar(50) DEFAULT NULL,
`err_code_des` varchar(50) DEFAULT NULL,
`result` text,
`trade_state` varchar(255) DEFAULT NULL,
`return_code` varchar(255) DEFAULT NULL,
`return_msg` varchar(255) DEFAULT NULL,
`openid` varchar(255) DEFAULT NULL,
`is_subscribe` varchar(255) DEFAULT NULL,
`trade_type` varchar(255) DEFAULT NULL,
`bank_type` varchar(255) DEFAULT NULL,
`total_fee` varchar(255) DEFAULT NULL,
`fee_type` varchar(255) DEFAULT NULL,
`attach` varchar(255) DEFAULT NULL,
`time_end` varchar(255) DEFAULT NULL,
`cash_fee` varchar(255) DEFAULT NULL,
`trade_state_desc` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tp_wx_pay_query
-- ----------------------------
INSERT INTO `tp_wx_pay_query` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000073201804158985312440', '1523761137309001526', 'HqF5wkHxHbWU40dn', 'D2E3500290609C511A0A49EEC825ED1B', null, '7', null, 'SUCCESS', null, null, null, 'SUCCESS', 'SUCCESS', 'OK', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'N', 'JSAPI', 'CMB_DEBIT', '1', 'CNY', null, '20180415105911', '1', '支付成功');
INSERT INTO `tp_wx_pay_query` VALUES (null, 'wx09e40d493c6a499e', '1485057832', '4200000073201804158985312440', '1523761137309001526', 'k4ntfaIbyijnyDLs', '83E73B73524CA080A25796378D3E761A', null, '8', null, 'SUCCESS', null, null, null, 'SUCCESS', 'SUCCESS', 'OK', 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', 'N', 'JSAPI', 'CMB_DEBIT', '1', 'CNY', null, '20180415105911', '1', '支付成功');
-- ----------------------------
-- Table structure for `tp_wx_pay_refund`
-- ----------------------------
DROP TABLE IF EXISTS `tp_wx_pay_refund`;
CREATE TABLE `tp_wx_pay_refund` (
`pay_record_id` int(11) NOT NULL,
`user_id` int(11) DEFAULT NULL,
`appid` varchar(50) DEFAULT NULL,
`mch_id` varchar(50) DEFAULT NULL,
`nonce_str` varchar(50) DEFAULT NULL,
`sign` varchar(50) DEFAULT NULL,
`sign_type` varchar(50) DEFAULT NULL,
`transaction_id` varchar(50) DEFAULT NULL,
`out_trade_no` varchar(50) DEFAULT NULL,
`out_refund_no` varchar(50) DEFAULT NULL,
`total_fee` varchar(50) DEFAULT NULL,
`refund_fee` varchar(50) DEFAULT NULL,
`refund_fee_type` varchar(50) DEFAULT NULL,
`refund_desc` varchar(50) DEFAULT NULL,
`refund_account` varchar(50) DEFAULT NULL,
`return_code` varchar(50) DEFAULT NULL,
`return_msg` varchar(50) DEFAULT NULL,
`return_result` text,
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tp_wx_pay_refund
-- ----------------------------
-- ----------------------------
-- Table structure for `tp_wx_pay_transfer`
-- ----------------------------
DROP TABLE IF EXISTS `tp_wx_pay_transfer`;
CREATE TABLE `tp_wx_pay_transfer` (
`mch_appid` varchar(255) DEFAULT NULL COMMENT '申请商户号的appid或商户号绑定的appid（企业号corpid即为此appId）',
`mchid` varchar(255) DEFAULT NULL COMMENT '微信支付分配的商户号',
`device_info` varchar(255) DEFAULT NULL COMMENT '微信支付分配的终端设备号',
`nonce_str` varchar(255) DEFAULT NULL COMMENT '随机字符串，不长于32位',
`sign` varchar(255) DEFAULT NULL COMMENT '签名，详见签名算法',
`partner_trade_no` varchar(255) NOT NULL DEFAULT '0' COMMENT '商户订单号，需保持唯一性',
`openid` varchar(255) DEFAULT NULL COMMENT '商户appid下，某用户的openid',
`check_name` varchar(255) DEFAULT NULL COMMENT 'NO_CHECK：不校验真实姓名 \r\nFORCE_CHECK：强校验真实姓名',
`re_user_name` varchar(255) DEFAULT NULL COMMENT '收款用户真实姓名。 \r\n如果check_name设置为FORCE_CHECK，则必填用户真实姓名',
`amount` varchar(255) DEFAULT NULL COMMENT '企业付款金额，单位为分',
`desc` varchar(255) DEFAULT NULL COMMENT '企业付款操作说明信息。必填。',
`spbill_create_ip` varchar(255) DEFAULT NULL COMMENT '调用接口的机器Ip地址',
PRIMARY KEY (`partner_trade_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tp_wx_pay_transfer
-- ----------------------------
-- ----------------------------
-- Table structure for `tp_wx_pay_transfer_info`
-- ----------------------------
DROP TABLE IF EXISTS `tp_wx_pay_transfer_info`;
CREATE TABLE `tp_wx_pay_transfer_info` (
`id` int(11) unsigned zerofill NOT NULL AUTO_INCREMENT,
`mch_appid` varchar(255) DEFAULT NULL COMMENT '申请商户号的appid或商户号绑定的appid（企业号corpid即为此appId）',
`mchid` varchar(255) DEFAULT NULL COMMENT '微信支付分配的商户号',
`device_info` varchar(255) DEFAULT NULL COMMENT '微信支付分配的终端设备号',
`nonce_str` varchar(255) DEFAULT NULL COMMENT '随机字符串，不长于32位',
`sign` varchar(255) DEFAULT NULL COMMENT '签名，详见签名算法',
`partner_trade_no` varchar(255) DEFAULT '0' COMMENT '商户订单号，需保持唯一性',
`openid` varchar(255) DEFAULT NULL COMMENT '商户appid下，某用户的openid',
`check_name` varchar(255) DEFAULT NULL COMMENT 'NO_CHECK：不校验真实姓名 \r\nFORCE_CHECK：强校验真实姓名',
`re_user_name` varchar(255) DEFAULT NULL COMMENT '收款用户真实姓名。 \r\n如果check_name设置为FORCE_CHECK，则必填用户真实姓名',
`amount` varchar(255) DEFAULT NULL COMMENT '企业付款金额，单位为分',
`desc` varchar(255) DEFAULT NULL COMMENT '企业付款操作说明信息。必填。',
`spbill_create_ip` varchar(255) DEFAULT NULL COMMENT '调用接口的机器Ip地址',
`return_code` varchar(255) DEFAULT NULL COMMENT 'SUCCESS/FAIL\r\n此字段是通信标识，非交易标识，交易是否成功需要查看result_code来判断',
`return_msg` varchar(255) DEFAULT NULL COMMENT '返回信息，如非空，为错误原因 \r\n签名失败 \r\n参数格式校验错误',
`err_code` varchar(255) DEFAULT NULL COMMENT 'CA_ERROR 请求未携带证书，或请求携带的证书出错 到商户平台下载证书，请求带上证书后重试。\r\nSIGN_ERROR 商户签名错误 按文档要求重新生成签名后再重试。\r\nNO_AUTH 没有权限 请联系微信支付开通api权限\r\nFREQ_LIMIT 受频率限制 请对请求做频率控制\r\nXML_ERROR 请求的xml格式错误，或者post的数据为空 检查请求串，确认无误后重试\r\nPARAM_ERROR 参数错误 请查看err_code_des，修改设置错误的参数\r\nSYSTEMERROR 系统繁忙，请再试',
`err_code_des` varchar(255) DEFAULT NULL,
`payment_no` varchar(255) DEFAULT NULL COMMENT '企业付款成功，返回的微信订单号',
`payment_time` varchar(255) DEFAULT NULL COMMENT '企业付款成功时间',
`detail_id` varchar(255) DEFAULT NULL COMMENT '调用企业付款API时，微信系统内部产生的单号',
`status` varchar(255) DEFAULT NULL COMMENT 'SUCCESS:转账成功\r\n\r\nFAILED:转账失败\r\n\r\nPROCESSING:处理中',
`reason` varchar(255) DEFAULT NULL COMMENT '失败原因',
`transfer_name` varchar(255) DEFAULT NULL COMMENT '收款用户姓名',
`payment_amount` varchar(255) DEFAULT NULL COMMENT '付款金额单位分',
`transfer_time` varchar(255) DEFAULT NULL COMMENT '发起转账的时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='企业付款查询';
-- ----------------------------
-- Records of tp_wx_pay_transfer_info
-- ----------------------------
-- ----------------------------
-- Table structure for `tp_wx_pay_unifiedorder`
-- ----------------------------
DROP TABLE IF EXISTS `tp_wx_pay_unifiedorder`;
CREATE TABLE `tp_wx_pay_unifiedorder` (
`pay_record_id` int(11) NOT NULL AUTO_INCREMENT,
`money` double(10,2) DEFAULT NULL,
`pay_time` int(10) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`appid` varchar(50) DEFAULT NULL,
`mch_id` varchar(50) DEFAULT NULL,
`device_info` varchar(50) DEFAULT NULL,
`nonce_str` varchar(50) DEFAULT NULL,
`sign` varchar(50) DEFAULT NULL,
`sign_type` varchar(50) DEFAULT NULL,
`body` varchar(50) DEFAULT NULL,
`detail` varchar(50) DEFAULT NULL,
`attach` varchar(50) DEFAULT NULL,
`out_trade_no` varchar(50) DEFAULT NULL,
`fee_type` varchar(50) DEFAULT NULL,
`total_fee` varchar(50) DEFAULT NULL,
`spbill_create_ip` varchar(50) DEFAULT NULL,
`time_start` varchar(50) DEFAULT NULL,
`time_expire` varchar(50) DEFAULT NULL,
`goods_tag` varchar(50) DEFAULT NULL,
`notify_url` varchar(50) DEFAULT NULL,
`trade_type` varchar(50) DEFAULT NULL,
`product_id` varchar(50) DEFAULT NULL,
`limit_pay` varchar(50) DEFAULT NULL,
`openid` varchar(50) DEFAULT NULL,
`scene_info` text,
PRIMARY KEY (`pay_record_id`)
) ENGINE=MyISAM AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tp_wx_pay_unifiedorder
-- ----------------------------
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('10', '100.00', '1523720907', '4', 'wx49dd14031d11fc64', '', null, null, null, null, '梁敏赞赏100元', null, null, '1523720907453001490', null, '10000', null, null, null, null, null, null, null, null, 'oQWyo5cQDLaAGIsFJoa23AcRTIrg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('11', '100.00', '1523721006', '4', 'wx49dd14031d11fc64', '', null, null, null, null, '梁敏赞赏100元', null, null, '1523721006165001491', null, '10000', null, null, null, null, null, null, null, null, 'oQWyo5cQDLaAGIsFJoa23AcRTIrg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('12', '100.00', '1523722974', '4', 'wxd5e091c4ca70db43', '1485057832', null, null, null, null, '梁敏赞赏100元', null, null, '1523722974322001492', null, '10000', null, null, null, null, null, null, null, null, 'oQWyo5cQDLaAGIsFJoa23AcRTIrg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('13', '100.00', '1523723103', '4', 'wxd5e091c4ca70db43', '1485057832', null, null, null, null, '梁敏赞赏100元', null, null, '1523723103818001493', null, '10000', null, null, null, null, null, null, null, null, 'oQWyo5cQDLaAGIsFJoa23AcRTIrg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('14', '100.00', '1523723688', '4', 'wxd5e091c4ca70db43', '1485057832', null, null, null, null, '梁敏赞赏100元', null, null, '1523723688854001494', null, '10000', null, null, null, null, null, null, null, null, 'oQWyo5cQDLaAGIsFJoa23AcRTIrg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('15', '100.00', '1523723797', '4', 'wx49dd14031d11fc64', '1485057832', null, null, null, null, '梁敏赞赏100元', null, null, '1523723797570001495', null, '10000', null, null, null, null, null, null, null, null, 'oQWyo5cQDLaAGIsFJoa23AcRTIrg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('16', '100.00', '1523724043', '4', 'wx49dd14031d11fc64', '1485057832', null, null, null, null, '梁敏赞赏100元', null, null, '1523724043968001496', null, '10000', null, null, null, null, null, null, null, null, 'oQWyo5cQDLaAGIsFJoa23AcRTIrg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('17', '100.00', '1523726836', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, null, '梁敏赞赏100元', null, null, '1523726836306001497', null, '10000', null, null, null, null, null, null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('18', '100.00', '1523727386', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, null, '梁敏赞赏100元', null, null, '1523727386973001498', null, '10000', null, null, null, null, null, null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('19', '100.00', '1523727467', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, null, '梁敏赞赏100元', null, null, '1523727467957001499', null, '10000', null, null, null, null, null, null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('20', '100.00', '1523727499', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, null, '梁敏赞赏100元', null, null, '1523727499063001500', null, '10000', null, null, null, null, null, null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('28', '100.00', '1523759096', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏100元', null, null, '1523759096141001512', null, '10000', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('29', '100.00', '1523759553', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏100元', null, null, '1523759553875001513', null, '10000', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('30', '100.00', '1523759908', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏100元', null, null, '1523759908090001514', null, '10000', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('31', '100.00', '1523759931', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏100元', null, null, '1523759931474001515', null, '10000', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('32', '100.00', '1523759956', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏100元', null, null, '1523759956467001516', null, '10000', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('33', '100.00', '1523760050', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏100元', null, null, '1523760050305001517', null, '10000', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('34', '100.00', '1523760093', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏100元', null, null, '1523760093339001518', null, '10000', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('35', '0.01', '1523760113', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523760113208001519', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('36', '0.01', '1523760159', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523760159057001520', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('37', '0.01', '1523760268', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523760268512001521', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('38', '0.01', '1523760293', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523760293138001522', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('39', '0.01', '1523760574', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523760574586001523', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('40', '0.01', '1523761062', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523761062666001525', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('41', '0.01', '1523761137', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523761137309001526', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('42', '0.01', '1523761490', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523761490836001527', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('43', '0.01', '1523796176', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523796176089001539', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('50', '0.01', '1523799194', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523799194163001540', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('51', '0.01', '1523799927', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523799927245001541', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('52', '0.01', '1523800137', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523800137452001542', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('53', '0.01', '1523802684', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523802683981001543', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('54', '0.01', '1523802916', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523802916302001544', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('55', '0.01', '1523803134', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523803134003001545', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('56', '0.01', '1523804948', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523804948704001546', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('57', '0.01', '1523805073', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523805073733001547', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('58', '0.01', '1523889996', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523889995958001548', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('59', '0.01', '1523890288', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523890288918001549', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('60', '0.01', '1523890642', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523890642399001550', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('61', '0.01', '1523890992', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523890992932001551', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('62', '0.01', '1523891132', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523891132638001552', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('63', '0.01', '1523891237', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523891237761001553', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('64', '0.01', '1523949655', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523949655839001554', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('65', '0.01', '1523949735', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523949735945001555', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('66', '0.01', '1523951121', '8', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '梁敏赞赏0.01元', null, null, '1523951121102001556', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0e9TkZqrs4-1wdpH5ECW9Eg', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('67', '0.01', '1524669993', '9', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '老郭赞赏0.01元', null, null, '1524669993817001557', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0Qh_5D4owMeRzOLad5TnAPM', null);
INSERT INTO `tp_wx_pay_unifiedorder` VALUES ('68', '0.01', '1524670189', '9', 'wx09e40d493c6a499e', '1485057832', null, null, null, 'MD5', '老郭赞赏0.01元', null, null, '1524670189578001558', null, '1', null, null, null, null, 'https://reward.520haikushilan.com/index/Wxpay/noti', null, null, null, 'owPge0Qh_5D4owMeRzOLad5TnAPM', null);
Loading...
举报
请认真填写举报原因，尽可能描述详细。
请选择举报类型
误判申诉
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化