-- phpMyAdmin SQL Dump
-- version 4.4.15.10
-- https://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: 2020-05-15 18:28:03
-- 服务器版本： 5.6.47-log
-- PHP Version: 5.6.40

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `bbs_taouduo_com`
--

-- --------------------------------------------------------

--
-- 表的结构 `w_admin_group`
--

CREATE TABLE IF NOT EXISTS `w_admin_group` (
  `admin_group_id` int(10) unsigned NOT NULL COMMENT '组id',
  `admin_group_name` varchar(30) NOT NULL DEFAULT '' COMMENT '组名称',
  `menu_id_list` varchar(255) NOT NULL DEFAULT '' COMMENT '权限列表',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '组添加时间',
  `remarks` varchar(30) NOT NULL DEFAULT '' COMMENT '备注',
  `status` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='管理员用户组表';

--
-- 转存表中的数据 `w_admin_group`
--

INSERT INTO `w_admin_group` (`admin_group_id`, `admin_group_name`, `menu_id_list`, `addtime`, `remarks`, `status`) VALUES
(33, '运营', '27,28,29,30,31,32,33,34,36,37', '2019-12-30 03:04:34', '', 0),
(32, '销售', '1,6,7,8,9,11,17,18,19,20,21,22,23,24,25,26,12,13', '2019-11-29 11:45:48', '', 0),
(36, '测试', '1,6,7,8,9,11,17,18,19,20,21,22,23,24,25,26,12,93,141,143,142,144,145,146,147,148,149,150', '2020-03-25 09:33:24', '', 0);

-- --------------------------------------------------------

--
-- 表的结构 `w_admin_menu`
--

CREATE TABLE IF NOT EXISTS `w_admin_menu` (
  `menu_id` smallint(5) unsigned NOT NULL COMMENT '菜单id',
  `menu_name` varchar(30) NOT NULL DEFAULT '' COMMENT '菜单昵称',
  `menu_parent_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '父级菜单',
  `menu_addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '菜单添加时间',
  `method` varchar(30) NOT NULL DEFAULT '' COMMENT '模型',
  `control` varchar(30) NOT NULL DEFAULT '' COMMENT '控制器',
  `icon` varchar(30) NOT NULL DEFAULT '' COMMENT '图标',
  `sort` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '类型',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `attach` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM AUTO_INCREMENT=292 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='后台菜单';

--
-- 转存表中的数据 `w_admin_menu`
--

INSERT INTO `w_admin_menu` (`menu_id`, `menu_name`, `menu_parent_id`, `menu_addtime`, `method`, `control`, `icon`, `sort`, `type`, `status`, `attach`) VALUES
(1, '菜单管理', 0, '2020-03-25 13:43:26', '', '', 'layui-icon-menu-fill', 255, 1, 0, ''),
(6, '后台菜单', 1, '2020-03-07 12:44:33', 'index', 'admin_menu', '', 255, 2, 0, ''),
(7, '更新', 6, '2020-03-07 12:44:33', 'upd', 'admin_menu', 'layui-icon-edit', 0, 3, 0, '{"location":"tool"}'),
(8, '读取', 6, '2020-03-07 12:44:33', 'read', 'admin_menu', 'layui-icon-website', 0, 3, 0, ''),
(9, '删除', 6, '2020-03-07 12:45:00', 'del', 'admin_menu', 'layui-icon-delete', 255, 3, 0, '{"location":"tool"}'),
(11, '添加', 6, '2020-03-07 13:04:38', 'add', 'admin_menu', 'layui-icon-add-1', 0, 3, 0, '{"location":"toolbar"}'),
(12, '主页', 0, '2020-03-07 13:13:03', 'console', 'free', 'layui-icon-home', 1, 2, 0, ''),
(17, '前台栏目', 1, '2020-03-07 13:20:36', 'index', 'column', '', 255, 2, 0, ''),
(18, '添加', 17, '2020-03-07 13:20:36', 'add', 'column', 'layui-icon-add-1', 0, 3, 0, '{"location":"toolbar"}'),
(19, '删除', 17, '2020-03-07 13:20:36', 'del', 'column', 'layui-icon-delete', 0, 3, 0, '{"location":"tool"}'),
(20, '更新', 17, '2020-03-07 13:20:36', 'upd', 'column', 'layui-icon-edit', 0, 3, 0, '{"location":"tool"}'),
(21, '读取', 17, '2020-03-07 13:20:36', 'read', 'column', 'layui-icon-website', 0, 3, 0, ''),
(22, '用户组', 1, '2020-03-07 13:21:57', 'index', 'admin_group', '', 255, 2, 0, '""'),
(23, '添加', 22, '2020-03-07 13:21:57', 'add', 'admin_group', 'layui-icon-add-1', 0, 3, 0, '{"location":"toolbar"}'),
(24, '删除', 22, '2020-03-07 13:21:57', 'del', 'admin_group', 'layui-icon-delete', 0, 3, 0, '{"location":"tool"}'),
(25, '更新', 22, '2020-03-07 13:21:57', 'upd', 'admin_group', 'layui-icon-edit', 0, 3, 0, '{"location":"tool"}'),
(26, '读取', 22, '2020-03-07 13:21:57', 'read', 'admin_group', 'layui-icon-website', 0, 3, 0, ''),
(27, '用户管理', 0, '2020-03-07 13:22:39', '', '', 'layui-icon-username', 255, 1, 0, ''),
(28, '会员管理', 27, '2020-03-07 13:23:10', 'index', 'member', '', 255, 2, 0, ''),
(30, '删除', 28, '2020-03-07 13:23:44', 'del', 'member', 'layui-icon-delete', 0, 3, 0, '{"location":"tool"}'),
(31, '更新', 28, '2020-03-07 13:23:44', 'upd', 'member', 'layui-icon-edit', 0, 3, 0, '{"location":"tool"}'),
(32, '读取', 28, '2020-03-07 13:23:44', 'read', 'member', 'layui-icon-website', 0, 3, 0, ''),
(33, '后台用户', 27, '2020-03-07 13:24:07', 'index', 'admin_user', '', 255, 2, 0, ''),
(34, '添加', 33, '2020-03-07 13:24:07', 'add', 'admin_user', 'layui-icon-add-1', 0, 3, 0, '{"location":"toolbar"}'),
(35, '删除', 33, '2020-03-07 13:24:07', 'del', 'admin_user', 'layui-icon-delete', 0, 3, 0, '{"location":"tool"}'),
(36, '更新', 33, '2020-03-07 13:24:07', 'upd', 'admin_user', 'layui-icon-edit', 0, 3, 0, '{"location":"tool"}'),
(37, '读取', 33, '2020-03-07 13:24:07', 'read', 'admin_user', 'layui-icon-website', 0, 3, 0, ''),
(38, '会员等级', 27, '2020-03-08 07:45:08', 'index', 'member_level', '', 255, 2, 0, ''),
(39, '添加', 38, '2020-03-08 07:45:08', 'add', 'member_level', 'layui-icon-add-1', 0, 3, 0, '{"location":"toolbar"}'),
(40, '删除', 38, '2020-03-08 07:45:08', 'del', 'member_level', 'layui-icon-delete', 0, 3, 0, '{"location":"tool"}'),
(41, '更新', 38, '2020-03-08 07:45:08', 'upd', 'member_level', 'layui-icon-edit', 0, 3, 0, '{"location":"tool"}'),
(42, '读取', 38, '2020-03-08 07:45:08', 'read', 'member_level', 'layui-icon-website', 0, 3, 0, ''),
(64, '广告管理', 0, '2020-03-08 08:26:55', 'index', 'advertisement', 'layui-icon-radio', 255, 2, 0, ''),
(65, '添加', 64, '2020-03-08 08:26:55', 'add', 'advertisement', 'layui-icon-add-1', 0, 3, 0, '{"location":"toolbar"}'),
(66, '删除', 64, '2020-03-08 08:26:55', 'del', 'advertisement', 'layui-icon-delete', 0, 3, 0, '{"location":"tool"}'),
(67, '更新', 64, '2020-03-08 08:26:55', 'upd', 'advertisement', 'layui-icon-edit', 0, 3, 0, '{"location":"tool"}'),
(68, '读取', 64, '2020-03-08 08:26:55', 'read', 'advertisement', 'layui-icon-website', 0, 3, 0, ''),
(69, '友情链接', 0, '2020-03-08 08:27:47', 'index', 'friend_link', 'layui-icon-unlink', 255, 2, 0, ''),
(70, '添加', 69, '2020-03-08 08:27:47', 'add', 'friend_link', 'layui-icon-add-1', 0, 3, 0, '{"location":"toolbar"}'),
(71, '删除', 69, '2020-03-08 08:27:47', 'del', 'friend_link', 'layui-icon-delete', 0, 3, 0, '{"location":"tool"}'),
(72, '更新', 69, '2020-03-08 08:27:47', 'upd', 'friend_link', 'layui-icon-edit', 0, 3, 0, '{"location":"tool"}'),
(73, '读取', 69, '2020-03-08 08:27:47', 'read', 'friend_link', 'layui-icon-website', 0, 3, 0, ''),
(77, '文章管理', 0, '2020-03-08 08:33:00', '', '', 'layui-icon-survey', 255, 1, 0, ''),
(78, '文章', 77, '2020-03-08 08:33:48', 'index', 'article', '', 255, 2, 0, ''),
(79, '添加', 78, '2020-03-08 08:33:48', 'add', 'article', 'layui-icon-add-1', 0, 3, 0, '{"location":"toolbar"}'),
(80, '删除', 78, '2020-03-08 08:33:48', 'del', 'article', 'layui-icon-delete', 0, 3, 0, '{"location":"tool"}'),
(81, '更新', 78, '2020-03-08 08:33:48', 'upd', 'article', 'layui-icon-edit', 0, 3, 0, '{"location":"tool"}'),
(82, '读取', 78, '2020-03-08 08:33:48', 'read', 'article', 'layui-icon-website', 0, 3, 0, ''),
(255, '网站设置', 0, '2020-04-09 08:28:21', 'index', 'setting', 'layui-icon-set-sm', 255, 2, 0, ''),
(88, '文章分类', 77, '2020-03-08 08:35:01', 'index', 'article_category', '', 255, 2, 0, ''),
(89, '添加', 88, '2020-03-08 08:35:01', 'add', 'article_category', 'layui-icon-add-1', 0, 3, 0, '{"location":"toolbar"}'),
(90, '删除', 88, '2020-03-08 08:35:01', 'del', 'article_category', 'layui-icon-delete', 0, 3, 0, '{"location":"tool"}'),
(91, '更新', 88, '2020-03-08 08:35:01', 'upd', 'article_category', 'layui-icon-edit', 0, 3, 0, '{"location":"tool"}'),
(92, '读取', 88, '2020-03-08 08:35:01', 'read', 'article_category', 'layui-icon-website', 0, 3, 0, ''),
(110, '接口管理', 0, '2020-03-18 05:14:39', '', '', 'layui-icon-link', 255, 1, 0, ''),
(282, '更新', 274, '2020-03-17 17:04:40', 'upd', 'video_category', 'layui-icon-edit', 0, 3, 0, '{"location":"tool"}'),
(283, '删除', 274, '2020-03-17 17:04:40', 'del', 'video_category', 'layui-icon-delete', 0, 3, 0, '{"location":"tool"}'),
(284, '添加', 274, '2020-03-17 17:04:40', 'add', 'video_category', 'layui-icon-add-1', 0, 3, 0, '{"location":"toolbar"}'),
(135, '接口', 110, '2020-03-20 09:52:03', 'index', 'api', '', 255, 2, 0, ''),
(136, '添加', 135, '2020-03-20 09:52:03', 'add', 'api', 'layui-icon-add-1', 0, 3, 0, '{"location":"toolbar"}'),
(137, '删除', 135, '2020-03-20 09:52:03', 'del', 'api', 'layui-icon-delete', 0, 3, 0, '{"location":"tool"}'),
(138, '更新', 135, '2020-03-20 09:52:03', 'upd', 'api', 'layui-icon-edit', 0, 3, 0, '{"location":"tool"}'),
(139, '读取', 135, '2020-03-20 09:52:03', 'read', 'api', 'layui-icon-website', 0, 3, 0, ''),
(140, '价格', 135, '2020-03-23 07:11:45', 'api_price', 'api', 'layui-icon-website', 255, 3, 0, ''),
(277, '添加', 275, '2020-03-17 17:04:40', 'add', 'video', 'layui-icon-add-1', 0, 3, 0, '{"location":"toolbar"}'),
(278, '删除', 275, '2020-03-17 17:04:40', 'del', 'video', 'layui-icon-delete', 0, 3, 0, '{"location":"tool"}'),
(156, '财务', 0, '2020-03-25 07:59:30', '', '', 'layui-icon-rmb', 3, 1, 0, '""'),
(285, '佣金记录', 156, '2020-05-14 07:31:01', 'index', 'cash_log', '', 255, 2, 0, '"\\"\\""'),
(286, '提现申请', 156, '2020-05-14 07:32:14', 'index', 'cash', '', 255, 2, 0, ''),
(287, '消费记录', 156, '2020-05-14 07:32:45', '', '', '', 255, 2, 0, ''),
(288, '读取', 285, '2020-05-14 07:43:58', 'read', 'cash_log', '', 255, 3, 0, '{"location":"list"}'),
(289, '读取', 286, '2020-05-14 08:38:29', 'read', 'cash', '', 255, 3, 0, '{"location":"list"}'),
(290, '审核', 286, '2020-05-14 08:53:26', 'examine', 'cash', 'layui-icon-auz', 255, 3, 0, '{"location":"tool"}'),
(291, '审核', 286, '2020-05-14 08:54:49', 'examine', 'cash', '', 255, 3, 0, '{"location":"toolbar"}'),
(271, '设置更新', 255, '2020-05-07 05:56:26', 'upd', 'setting', '', 255, 3, 0, ''),
(272, '读取', 255, '2020-05-07 06:18:00', 'read', 'setting', '', 255, 3, 0, ''),
(273, '视频管理', 0, '2020-05-07 13:02:41', 'index', 'video', 'layui-icon-video', 255, 2, 0, ''),
(274, '视频分类', 273, '2020-05-08 07:50:51', 'index', 'video_category', '', 255, 2, 0, ''),
(275, '视频', 273, '2020-05-08 07:51:11', 'index', 'video', '', 255, 2, 0, '""'),
(270, '读取', 269, '2020-04-30 06:16:55', 'read', 'task_record', '', 255, 3, 0, ''),
(280, '读取', 275, '2020-03-17 17:04:40', 'read', 'video', 'layui-icon-website', 0, 3, 0, '{"location":"list"}'),
(281, '读取', 274, '2020-03-17 17:04:40', 'read', 'video_category', 'layui-icon-website', 0, 3, 0, '{"location":"list"}'),
(279, '更新', 275, '2020-03-17 17:04:40', 'upd', 'video', 'layui-icon-edit', 0, 3, 0, '{"location":"tool"}'),
(224, '搜索', 28, '2020-03-30 02:05:10', 'search', 'member', 'layui-icon-search', 255, 3, 0, '{"location":"toolbar"}'),
(241, '文件管理', 0, '2020-03-31 10:37:09', 'index', 'file', 'layui-icon-file', 255, 2, 0, ''),
(242, '读取', 241, '2020-03-31 10:38:46', 'read', 'file', '', 0, 3, 0, ''),
(268, '参数读取', 135, '2020-04-22 07:31:07', 'get_param', 'api', '', 255, 3, 0, ''),
(245, '接口参数', 110, '2020-04-08 07:31:54', 'index', 'api_param', 'layui-icon-rate-half', 255, 2, 0, ''),
(246, '添加', 245, '2020-03-17 17:04:40', 'add', 'api_param', 'layui-icon-add-1', 0, 3, 0, '{"location":"toolbar"}'),
(247, '删除', 245, '2020-03-17 17:04:40', 'del', 'api_param', 'layui-icon-delete', 0, 3, 0, '{"location":"tool"}'),
(248, '更新', 245, '2020-03-17 17:04:40', 'upd', 'api_param', 'layui-icon-edit', 0, 3, 0, '{"location":"tool"}'),
(249, '读取', 245, '2020-03-17 17:04:40', 'read', 'api_param', 'layui-icon-website', 0, 3, 0, '{"location":"tool"}'),
(269, '任务日志', 110, '2020-04-30 02:36:55', 'index', 'task_record', '', 255, 2, 0, '');

-- --------------------------------------------------------

--
-- 表的结构 `w_admin_user`
--

CREATE TABLE IF NOT EXISTS `w_admin_user` (
  `admin_id` int(10) unsigned NOT NULL COMMENT '用户id',
  `admin_nickname` varchar(30) NOT NULL DEFAULT '' COMMENT '用户昵称',
  `admin_passwd` char(32) NOT NULL DEFAULT '' COMMENT '用户密码',
  `admin_account` varchar(30) NOT NULL DEFAULT '' COMMENT '用户账户',
  `admin_group` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '用户所属组',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '用户添加时间',
  `sex` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 男 2女 0 人妖',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 锁定 1 开启',
  `remarks` varchar(30) NOT NULL DEFAULT '' COMMENT '备注'
) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='管理员用户表';

--
-- 转存表中的数据 `w_admin_user`
--

INSERT INTO `w_admin_user` (`admin_id`, `admin_nickname`, `admin_passwd`, `admin_account`, `admin_group`, `addtime`, `sex`, `status`, `remarks`) VALUES
(1, 'admin', '4799fd1a2de8aa6a52b39db3ad77692b', 'admin', 1, '2019-11-28 13:51:56', 1, 0, 'test'),
(48, '小廖', '4799fd1a2de8aa6a52b39db3ad77692b', 'test', 36, '2020-03-25 09:54:37', 1, 0, '333');

-- --------------------------------------------------------

--
-- 表的结构 `w_advertising`
--

CREATE TABLE IF NOT EXISTS `w_advertising` (
  `advertising_id` int(10) unsigned NOT NULL COMMENT '广告id',
  `advertising_img` varchar(100) NOT NULL DEFAULT '' COMMENT '广告图片',
  `advertising_name` varchar(50) NOT NULL DEFAULT '' COMMENT '广告名称',
  `advertising_link` varchar(50) NOT NULL DEFAULT '' COMMENT '广告链接',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1禁用 0 启用',
  `sort` smallint(5) unsigned NOT NULL DEFAULT '0',
  `show_location` tinyint(4) DEFAULT '0',
  `desc` text
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='广告表';

--
-- 转存表中的数据 `w_advertising`
--

INSERT INTO `w_advertising` (`advertising_id`, `advertising_img`, `advertising_name`, `advertising_link`, `status`, `sort`, `show_location`, `desc`) VALUES
(16, '/upload/20200317/a87e4b01ff4c80c9ef480677257eec5c.jpg', '33333', '3333', 1, 0, 2, ''),
(17, '/upload/20200313/3bfa2aee7cbf1652926cdbed381f2c81.jpg', '哈哈哈', 'www.baidu.com', 1, 0, 2, NULL),
(18, '/upload/20200304/33c0c778df5bc1bb74ed6567405858de.jpg', '犯得上发射点', 'www.baidu.com', 1, 0, 2, NULL),
(19, '/upload/wx.png', '33', '333', 1, 0, 0, NULL);

-- --------------------------------------------------------

--
-- 表的结构 `w_api`
--

CREATE TABLE IF NOT EXISTS `w_api` (
  `api_id` int(10) unsigned NOT NULL COMMENT '主键',
  `api_name` varchar(30) NOT NULL DEFAULT '' COMMENT 'api名称',
  `price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `api_type_id` int(10) unsigned NOT NULL DEFAULT '0',
  `sign` char(30) NOT NULL DEFAULT '',
  `api_path` varchar(50) NOT NULL DEFAULT '',
  `api_param_id` varchar(255) NOT NULL DEFAULT '',
  `api_type` int(10) unsigned NOT NULL DEFAULT '0',
  `cost_price` decimal(10,2) NOT NULL DEFAULT '0.00'
) ENGINE=InnoDB AUTO_INCREMENT=247 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `w_api`
--

INSERT INTO `w_api` (`api_id`, `api_name`, `price`, `api_type_id`, `sign`, `api_path`, `api_param_id`, `api_type`, `cost_price`) VALUES
(173, '淘宝App流量', '3.00', 11, '5f95869f9a49414f83626bbccbc9fb', '/ll/task_add', '89,108,85,105,88,87,86,92,93,90,107', 1, '1.50'),
(174, '淘宝PC流量', '4.00', 11, 'a3782dbbc67292c65dc7d9563ff514', '/ll/task_add', '85,92,86,87,88,89,90,93,105,107,108', 1, '0.00'),
(175, '淘宝直访店铺', '9999.00', 11, 'a7c7e78820646c5470eafe12f4f0e3', '/ll/task_add', '89,108,85,105,88,107,86,92,93,87,90', 1, '0.00'),
(176, '淘宝直访商品', '4.00', 11, '119f28954a34c93d0e10fdb3a8ad9b', '/ll/task_add', '85,86,87,88,89,90,92,93,105,107,108', 1, '0.00'),
(187, '淘宝店铺收藏', '14.00', 12, 'c76c12363cbc516a808a28968ff8c3', '/ll/task_add', '89,108,85,88,87,105', 1, '0.00'),
(188, '淘宝商品收藏', '10.00', 12, '3544c8756170690ee5075f39f1aa6d', '/ll/task_add', '89,108,88,87,85,105', 0, '0.00'),
(189, '淘宝商品搜索', '14.00', 15, '1eccaa6ae48563d614353ed33a33f9', '/ll/task_add', '89,108,85,105,88,87,86,92', 0, '0.00'),
(190, '淘宝商品直接加购', '10.00', 16, '7bb0cf37380a95ec406ba6d68d05eb', '/ll/task_add', '89,108,85,105,88,87', 1, '0.00'),
(192, '淘宝直播关注', '20.00', 0, '4172a91dc86b95abc73570a8c82c32', '/ll/task_add', '89,108,85,87,105,88', 0, '0.00'),
(193, '直播观看人数', '2.00', 0, '9f362d02637043d95610178930540c', '/ll/task_add', '89,108,85,105,87', 0, '0.00'),
(194, '淘宝开团提醒', '9999.00', 0, 'd595bc03d51d5bfaabda672d577086', '/ll/task_add', '89,108,85,105,88,87', 0, '0.00'),
(195, '淘宝商品点赞', '4.00', 0, 'b4911d0f0f226da3d9189f848a8eed', '/ll/task_add', '89,108,85,105,114,88', 0, '0.00'),
(196, '淘抢购任务', '8.00', 0, '0f7a4a599483a413fec234aaf15e62', '/ll/task_add', '89,108,85,105,88', 0, '0.00'),
(197, '微淘达人文章阅读任务阅读次数', '4.00', 0, '6134ec6f5068b0015f5a6afd09d9eb', '/ll/task_add', '89,108,105,88,85', 0, '0.00'),
(198, '微淘达人文章阅读任务阅读人数', '6.00', 0, '8607d51f329a20ee90a2d3b987ed9e', '/ll/task_add', '89,108,85,105,88', 0, '0.00'),
(199, '微淘达人文章阅读任务引导进店', '8.00', 0, '53b08254483211c35a027b44e48e48', '/ll/task_add', '89,108,85,88,105', 0, '0.00'),
(200, '淘宝直播热度任务', '9999.00', 0, 'eecdba8ffe2858f65fe29cd57d8c39', '/ll/task_add', '89,108,85,105,111', 0, '0.00'),
(201, '淘宝直播间加购任务', '9999.00', 0, '592b7896da3e2dc6232f1ef3e914c5', '/ll/task_add', '89,108,85,105,111', 0, '0.00'),
(202, '京东流量任务', '6.00', 0, '249ca8fc9c102c14e79fae287fca68', '/ll/task_add', '89,108,85,105,88,87,86,92', 0, '0.00'),
(203, '京东店铺收藏任务', '10.00', 0, 'b9f5d9dad383551817990066a77cd4', '/ll/task_add', '89,108,85,105,88,87', 0, '0.00'),
(204, '京东商品直接收藏任务', '10.00', 0, 'b4b0cf9a00b17c0f432420407a9ea6', '/ll/task_add', '89,108,85,105,88,87', 0, '0.00'),
(205, '京东商品搜索收藏任务', '16.00', 0, '5b2b5a6b42c41385703b8f70d746b8', '/ll/task_add', '89,108,85,105,88,87,86,92', 0, '0.00'),
(206, '京东商品直接加购任务', '10.00', 0, '169093bfaa2ef6726137942d739b8c', '/ll/task_add', '89,108,85,105,88,87', 0, '0.00'),
(207, '京东商品搜索加购任务', '16.00', 0, 'd2ebd2989f7e3f088eb056a48f1717', '/ll/task_add', '89,108,85,105,88,87,86,92', 0, '0.00'),
(208, '京东达人关注任务', '10.00', 0, '5fd15dcedaa002ee20c8efec444da3', '/ll/task_add', '89,108,85,105,112', 0, '0.00'),
(209, '京东预约任务', '14.00', 0, '708664e14b8b466891288ce28c24f3', '/ll/task_add', '89,108,85,105,88', 0, '0.00'),
(210, '京东秒杀提醒任务', '9999.00', 0, 'fc4163702150b0607986dd73b31989', '/ll/task_add', '89,108,85,105,88', 0, '0.00'),
(211, '抖音任务抖音粉丝', '9999.00', 0, 'f3af97aa98d632ce71badf78e668f2', '/ll/task_add', '89,108,85,105', 0, '0.00'),
(212, '抖音任务抖音点赞', '9999.00', 0, '6e231f7fd2455c6d1d74af5524b7d9', '/ll/task_add', '89,85,105,108', 0, '0.00'),
(213, '抖音任务抖音播放', '9999.00', 0, 'bfd7ff2fa6ee607fb1f2db9940266f', '/ll/task_add', '89,85,108,105', 0, '0.00'),
(214, '抖音任务抖音分享', '9999.00', 0, 'ee2d1c84351d941e33772bd2ad3cc5', '/ll/task_add', '85,89,108,105', 0, '0.00'),
(215, '抖音任务抖音评论', '9999.00', 0, '1a674d8f6058720324c5484073c7cd', '/ll/task_add', '85,89,105,108,90', 0, '0.00'),
(216, '拼多多流量任务', '2.00', 0, '76d193885eeb7088e9bd90047fa8c9', '/ll/task_add', '89,108,85,105,88,87,86,92', 0, '0.00'),
(217, '拼多多商品搜索收藏任务', '10.00', 0, '93d8db7ed530bf4a6fa0444dccc415', '/ll/task_add', '89,108,85,105,88,87,86,92', 0, '0.00'),
(218, '拼多多商品直接收藏任务', '8.00', 0, 'b0ad7eeed49577b2e2506742fa6647', '/ll/task_add', '89,108,85,105,88,87', 0, '0.00'),
(219, '拼多多店铺收藏任务', '8.00', 0, '6399343c585f8a23308409d1b0a225', '/ll/task_add', '89,108,85,105,88,87', 0, '0.00'),
(220, '千人千页', '9999.00', 0, '5f6ed2941473376eac046d8b39141a', '/ll/toolbox_add', '113,105,114,87,115', 0, '0.00'),
(221, '卡首屏', '9999.00', 0, '3d9632ced1abb0812ac266f4521e44', '/ll/toolbox_add', '113,105,114,87', 0, '0.00'),
(222, '查旺旺信用和黑号', '9999.00', 0, '060c10ad54d0a948fd4adfa3dfc31a', '/ll/toolbox_add', '113,105,115', 0, '0.00'),
(223, '查淘客订单，检查是不是淘宝客订单', '9999.00', 0, '9a7962661d5f049da4f306ae6898a5', '/ll/toolbox_add', '113,105,116', 0, '0.00'),
(224, '解析淘口令', '9999.00', 0, 'd768e42e763f254392336bedc66c45', '/ll/toolbox_add', '113,105,117', 0, '0.00'),
(225, '生成淘口令', '9999.00', 0, '98bed881a7248e85520011c4ed1639', '/ll/toolbox_add', '113,105,118,119,120,121', 0, '0.00'),
(227, '淘宝商品搜索加购', '14.00', 17, 'ec9935dc2d746c7dd2fa36f48d477b', '/ll/task_add', '105,89,85,86,87,88,92,108', 0, '0.00'),
(245, '任务查询', '0.00', 0, '5c2b5468f0bb90ddb669d05ba64fe7', '/ll/task_cancel', '110,126,125,124,123', 0, '0.00');

-- --------------------------------------------------------

--
-- 表的结构 `w_api_field`
--

CREATE TABLE IF NOT EXISTS `w_api_field` (
  `api_field_id` int(10) unsigned NOT NULL,
  `name` varchar(50) NOT NULL DEFAULT '',
  `default` varchar(255) NOT NULL DEFAULT '',
  `price` varchar(255) NOT NULL DEFAULT '',
  `is_require` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `api_id` int(10) unsigned NOT NULL DEFAULT '0',
  `api_param_id` int(10) unsigned NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=1203 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `w_api_field`
--

INSERT INTO `w_api_field` (`api_field_id`, `name`, `default`, `price`, `is_require`, `api_id`, `api_param_id`) VALUES
(758, 'count', '', '', 0, 173, 89),
(759, 'hour', '', '', 1, 173, 108),
(760, 'begin_time', '', '', 1, 173, 85),
(762, 'target', '', '', 0, 173, 88),
(763, 'keyword', '', '', 1, 173, 87),
(764, 'browse_time', '100-180', '{"100-180":"0","180-280":"0","280-380":"1","380-480":"2"}', 0, 173, 86),
(765, 'depth', '0', '["0","0","0"]', 0, 173, 92),
(766, 'shopVisit', 'sales', '{"sales":"0","favos":"0","cates":"0","no":"0"}', 0, 173, 93),
(768, 'begin_time', '', '', 1, 174, 85),
(769, 'depth', '0', '["","",""]', 1, 174, 92),
(770, 'browse_time', '100-180', '{"100-180":"","180-280":"","280-380":"","380-480":""}', 1, 174, 86),
(771, 'keyword', '', '', 1, 174, 87),
(772, 'target', '', '', 1, 174, 88),
(773, 'count', '', '', 1, 174, 89),
(774, 'show', '', '', 1, 174, 90),
(775, 'shopVisit', 'sales', '{"sales":"","favos":"","cates":"","no":""}', 1, 174, 93),
(777, 'send_day', '', '', 0, 174, 107),
(778, 'hour', '', '', 0, 174, 108),
(780, 'count', '', '', 1, 175, 89),
(781, 'hour', '', '', 1, 175, 108),
(782, 'begin_time', '', '', 1, 175, 85),
(784, 'target', '', '', 1, 175, 88),
(785, 'keyword', '', '', 0, 175, 107),
(786, 'browse_time', '100-180', '{"100-180":"","180-280":"","280-380":"","380-480":""}', 1, 175, 86),
(787, 'depth', '0', '["","",""]', 1, 175, 92),
(788, 'shopVisit', 'sales', '{"sales":"","favos":"","cates":"","no":""}', 1, 175, 93),
(789, 'keyword', '', '', 1, 175, 87),
(790, 'show', '', '', 1, 175, 90),
(793, 'begin_time', '', '', 1, 176, 85),
(794, 'browse_time', '100-180', '{"100-180":"","180-280":"","280-380":"","380-480":""}', 1, 176, 86),
(795, 'keyword', '', '', 1, 176, 87),
(796, 'target', '', '', 1, 176, 88),
(797, 'count', '', '', 1, 176, 89),
(798, 'show', '', '', 1, 176, 90),
(799, 'depth', '0', '["","",""]', 1, 176, 92),
(800, 'shopVisit', 'sales', '{"sales":"","favos":"","cates":"","no":""}', 1, 176, 93),
(802, 'send_day', '', '', 0, 176, 107),
(803, 'hour', '', '', 1, 176, 108),
(804, 'count', '', '', 1, 187, 89),
(805, 'hour', '', '', 1, 187, 108),
(806, 'begin_time', '', '', 1, 187, 85),
(807, 'target', '', '', 1, 187, 88),
(808, 'keyword', '', '', 0, 187, 87),
(811, 'count', '', '', 1, 188, 89),
(812, 'hour', '', '', 1, 188, 108),
(813, 'target', '', '', 1, 188, 88),
(814, 'keyword', '', '', 1, 188, 87),
(815, 'begin_time', '', '', 1, 188, 85),
(817, 'count', '', '', 1, 189, 89),
(818, 'hour', '', '', 1, 189, 108),
(819, 'begin_time', '', '', 1, 189, 85),
(821, 'target', '', '', 1, 189, 88),
(822, 'keyword', '', '', 1, 189, 87),
(823, 'browse_time', '100-180', '{"100-180":"","180-280":"","280-380":"","380-480":""}', 0, 189, 86),
(824, 'depth', '0', '["","",""]', 0, 189, 92),
(828, 'count', '', '', 1, 190, 89),
(829, 'hour', '', '', 1, 190, 108),
(830, 'begin_time', '', '', 1, 190, 85),
(832, 'target', '', '', 1, 190, 88),
(833, 'keyword', '', '', 1, 190, 87),
(836, 'count', '', '', 1, 192, 89),
(837, 'hour', '', '', 1, 192, 108),
(838, 'begin_time', '', '', 1, 192, 85),
(839, 'keyword', '', '', 1, 192, 87),
(841, 'count', '', '', 1, 193, 89),
(842, 'hour', '', '', 1, 193, 108),
(843, 'begin_time', '', '', 1, 193, 85),
(845, 'keyword', '', '', 1, 193, 87),
(846, 'count', '', '', 1, 194, 89),
(847, 'hour', '', '', 1, 194, 108),
(848, 'begin_time', '', '', 1, 194, 85),
(850, 'target', '', '', 1, 194, 88),
(851, 'keyword', '', '', 1, 194, 87),
(853, 'count', '', '', 1, 195, 89),
(854, 'hour', '', '', 1, 195, 108),
(855, 'begin_time', '', '', 1, 195, 85),
(857, 'count', '', '', 1, 196, 89),
(858, 'hour', '', '', 1, 196, 108),
(859, 'begin_time', '', '', 1, 196, 85),
(861, 'target', '', '', 1, 196, 88),
(862, 'count', '', '', 0, 197, 89),
(863, 'hour', '', '', 0, 197, 108),
(865, 'begin_time', '', '', 0, 197, 88),
(866, 'count', '', '', 1, 198, 89),
(867, 'hour', '', '', 1, 198, 108),
(868, 'begin_time', '', '', 1, 198, 85),
(870, 'target', '', '', 1, 198, 88),
(871, 'count', '', '', 1, 197, 89),
(872, 'hour', '', '', 1, 197, 108),
(874, 'target', '', '', 1, 197, 88),
(875, 'begin_time', '', '', 1, 197, 85),
(878, 'count', '', '', 1, 199, 89),
(879, 'hour', '', '', 1, 199, 108),
(880, 'begin_time', '', '', 1, 199, 85),
(881, 'target', '', '', 1, 199, 88),
(883, 'count', '', '', 0, 200, 89),
(884, 'hour', '', '', 0, 200, 108),
(885, 'begin_time', '', '', 0, 200, 85),
(887, 'target', '', '', 0, 200, 88),
(893, 'count', '', '', 1, 201, 89),
(894, 'hour', '', '', 1, 201, 108),
(895, 'begin_time', '', '', 1, 201, 85),
(897, 'target', '', '', 1, 201, 111),
(903, 'count', '', '', 1, 202, 89),
(904, 'hour', '', '', 1, 202, 108),
(905, 'begin_time', '', '', 1, 202, 85),
(907, 'target', '', '', 0, 202, 88),
(908, 'keyword', '', '', 1, 202, 87),
(909, 'browse_time', '100-180', '{"100-180":"","180-280":"","280-380":"","380-480":""}', 1, 202, 86),
(910, 'depth', '0', '["","",""]', 1, 202, 92),
(915, 'count', '', '', 1, 203, 89),
(916, 'hour', '', '', 1, 203, 108),
(917, 'begin_time', '', '', 1, 203, 85),
(919, 'target', '', '', 1, 203, 88),
(920, 'keyword', '', '', 1, 203, 87),
(923, 'count', '', '', 1, 204, 89),
(924, 'hour', '', '', 1, 204, 108),
(925, 'begin_time', '', '', 1, 204, 85),
(927, 'target', '', '', 1, 204, 88),
(928, 'keyword', '', '', 1, 204, 87),
(935, 'count', '', '', 1, 205, 89),
(936, 'hour', '', '', 1, 205, 108),
(937, 'begin_time', '', '', 1, 205, 85),
(939, 'target', '', '', 1, 205, 88),
(940, 'keyword', '', '', 1, 205, 87),
(941, 'browse_time', '100-180', '{"100-180":"","180-280":"","280-380":"","380-480":""}', 1, 205, 86),
(942, 'depth', '0', '["","",""]', 1, 205, 92),
(945, 'count', '', '', 1, 206, 89),
(946, 'hour', '', '', 1, 206, 108),
(947, 'begin_time', '', '', 1, 206, 85),
(949, 'target', '', '', 1, 206, 88),
(950, 'keyword', '', '', 1, 206, 87),
(954, 'count', '', '', 1, 200, 89),
(955, 'hour', '', '', 1, 200, 108),
(956, 'begin_time', '', '', 1, 200, 85),
(958, 'target', '', '', 1, 200, 111),
(960, 'count', '', '', 1, 208, 89),
(961, 'hour', '', '', 1, 208, 108),
(962, 'begin_time', '', '', 1, 208, 85),
(964, 'target', '', '', 1, 208, 112),
(965, 'count', '', '', 1, 207, 89),
(966, 'hour', '', '', 1, 207, 108),
(967, 'begin_time', '', '', 1, 207, 85),
(969, 'target', '', '', 1, 207, 88),
(970, 'keyword', '', '', 1, 207, 87),
(971, 'browse_time', '100-180', '{"100-180":"","180-280":"","280-380":"","380-480":""}', 1, 207, 86),
(972, 'depth', '0', '["","",""]', 1, 207, 92),
(973, 'count', '', '', 1, 209, 89),
(974, 'hour', '', '', 1, 209, 108),
(975, 'begin_time', '', '', 1, 209, 85),
(977, 'begin_time', '', '', 1, 209, 88),
(978, 'count', '', '', 1, 210, 89),
(979, 'hour', '', '', 1, 210, 108),
(980, 'begin_time', '', '', 1, 210, 85),
(982, 'target', '', '', 1, 210, 88),
(983, 'count', '', '', 1, 211, 89),
(984, 'hour', '', '', 1, 211, 108),
(985, 'begin_time', '', '', 1, 211, 85),
(987, 'count', '', '', 1, 212, 89),
(988, 'begin_time', '', '', 1, 212, 85),
(990, 'hour', '', '', 1, 212, 108),
(991, 'count', '', '', 1, 213, 89),
(992, 'begin_time', '', '', 1, 213, 85),
(993, 'hour', '', '', 1, 213, 108),
(995, 'begin_time', '', '', 1, 214, 85),
(996, 'count', '', '', 1, 214, 89),
(997, 'hour', '', '', 1, 214, 108),
(999, 'begin_time', '', '', 1, 215, 85),
(1000, 'count', '', '', 1, 215, 89),
(1002, 'hour', '', '', 1, 215, 108),
(1003, 'send-day', '', '', 1, 215, 90),
(1004, 'count', '', '', 1, 216, 89),
(1005, 'hour', '', '', 1, 216, 108),
(1006, 'begin_time', '', '', 1, 216, 85),
(1008, 'target', '', '', 1, 216, 88),
(1009, 'keyword', '', '', 1, 216, 87),
(1010, 'browse_time', '100-180', '{"100-180":"","180-280":"","280-380":"","380-480":""}', 1, 216, 86),
(1011, 'depth', '0', '["","",""]', 1, 216, 92),
(1012, 'count', '', '', 1, 217, 89),
(1013, 'hour', '', '', 1, 217, 108),
(1014, 'begin_time', '', '', 1, 217, 85),
(1016, 'target', '', '', 1, 217, 88),
(1017, 'keyword', '', '', 1, 217, 87),
(1018, 'browse_time', '100-180', '{"100-180":"","180-280":"","280-380":"","380-480":""}', 1, 217, 86),
(1019, 'depth', '0', '["","",""]', 1, 217, 92),
(1020, 'count', '', '', 1, 218, 89),
(1021, 'hour', '', '', 1, 218, 108),
(1022, 'begin_time', '', '', 1, 218, 85),
(1024, 'target', '', '', 1, 218, 88),
(1025, 'keyword', '', '', 1, 218, 87),
(1026, 'send_day', '1', '', 0, 173, 107),
(1027, 'send_day', '1', '', 0, 174, 107),
(1028, 'send_day', '1', '', 0, 175, 107),
(1029, 'send_day', '1', '', 0, 176, 107),
(1030, 'send_day', '', '', 0, 187, 107),
(1031, 'send_day', '', '', 0, 188, 107),
(1032, 'send_day', '', '', 0, 189, 107),
(1033, 'send_day', '', '', 0, 190, 107),
(1034, 'send_day', '', '', 0, 192, 107),
(1035, 'send_day', '', '', 0, 193, 107),
(1036, 'send_day', '', '', 0, 194, 107),
(1037, 'send_day', '', '', 0, 195, 107),
(1038, 'send_day', '', '', 0, 196, 107),
(1039, 'send_day', '', '', 0, 197, 107),
(1040, 'send_day', '', '', 0, 198, 107),
(1041, 'send_day', '', '', 0, 199, 107),
(1042, 'send_day', '', '', 0, 200, 107),
(1043, 'send_day', '', '', 0, 201, 107),
(1044, 'send_day', '', '', 0, 202, 107),
(1045, 'send_day', '', '', 0, 203, 107),
(1046, 'send_day', '', '', 0, 204, 107),
(1047, 'send_day', '', '', 0, 205, 107),
(1048, 'send_day', '', '', 0, 206, 107),
(1049, 'send_day', '', '', 0, 207, 107),
(1050, 'send_day', '', '', 0, 208, 107),
(1051, 'send_day', '', '', 0, 209, 107),
(1052, 'send_day', '', '', 0, 210, 107),
(1053, 'send_day', '', '', 0, 211, 107),
(1054, 'send_day', '', '', 0, 212, 107),
(1055, 'send_day', '', '', 0, 213, 107),
(1056, 'send_day', '', '', 0, 214, 107),
(1057, 'send_day', '', '', 0, 215, 107),
(1058, 'send_day', '', '', 0, 216, 107),
(1059, 'send_day', '', '', 0, 217, 107),
(1060, 'send_day', '', '', 0, 218, 107),
(1061, 'send_day', '', '', 0, 219, 107),
(1062, 'send_day', '', '', 0, 220, 107),
(1063, 'send_day', '', '', 0, 221, 107),
(1064, 'send_day', '', '', 0, 222, 107),
(1065, 'send_day', '', '', 0, 223, 107),
(1066, 'send_day', '', '', 0, 224, 107),
(1067, 'send_day', '', '', 0, 225, 107),
(1068, 'send_day', '', '', 0, 227, 107),
(1069, 'count', '', '', 1, 219, 89),
(1070, 'hour', '', '', 1, 219, 108),
(1071, 'begin_time', '', '', 1, 219, 85),
(1073, 'target', '', '', 1, 219, 88),
(1074, 'keyword', '', '', 1, 219, 87),
(1075, 'id', '', '', 1, 220, 113),
(1077, 'itemid', '', '', 1, 220, 114),
(1078, 'keyword', '', '', 1, 220, 87),
(1079, 'nick', '', '', 1, 220, 115),
(1080, 'id', '', '', 1, 221, 113),
(1082, 'itemid', '', '', 1, 221, 114),
(1083, 'keyword', '', '', 1, 221, 87),
(1084, 'id', '', '', 0, 222, 113),
(1086, 'nick', '', '', 0, 222, 115),
(1087, 'id', '', '', 1, 223, 113),
(1089, 'tk_orderid', '', '', 1, 223, 116),
(1090, 'id', '', '', 1, 224, 113),
(1092, 'tb_pwd', '', '', 1, 224, 117),
(1093, 'id', '', '', 1, 225, 113),
(1095, 'item_url', '', '', 1, 225, 118),
(1096, 'title', '', '', 1, 225, 119),
(1097, 'pic_url', '', '', 1, 225, 120),
(1098, 'price', '', '', 1, 225, 121),
(1100, 'count', '', '', 1, 227, 89),
(1101, 'begin_time', '', '', 1, 227, 85),
(1102, 'browse_time', '100-180', '{"1":"","2":"","3":""}', 1, 227, 86),
(1103, 'keyword', '', '', 1, 227, 87),
(1104, 'target', '', '', 1, 227, 88),
(1105, 'depth', '0', '["","",""]', 1, 227, 92),
(1106, 'hour', '', '', 1, 227, 108),
(1107, 'eee', '', '', 0, 244, 85),
(1108, '333', '', '', 0, 244, 85),
(1112, '', '1', '', 0, 244, 105),
(1113, '', '0', '', 0, 173, 105),
(1114, '', '0', '', 0, 173, 0),
(1115, '', '1', '', 0, 174, 0),
(1116, '', '1', '', 0, 174, 0),
(1117, '', '2', '', 0, 175, 0),
(1118, '', '3', '', 0, 176, 0),
(1119, '', '6', '', 0, 187, 0),
(1120, '', '3', '', 0, 176, 0),
(1121, '', '6', '', 0, 187, 0),
(1122, '', '7', '', 0, 188, 0),
(1123, '', '9', '', 0, 189, 0),
(1124, '', '10', '', 0, 190, 0),
(1125, '', '12', '', 0, 192, 0),
(1126, '', '14', '', 0, 193, 0),
(1127, '', '15', '', 0, 194, 0),
(1128, '', '17', '', 0, 195, 0),
(1129, '', '20', '', 0, 196, 0),
(1130, '', '21', '', 0, 197, 0),
(1131, '', '22', '', 0, 198, 0),
(1132, '', '23', '', 0, 199, 0),
(1133, '', '24', '', 0, 200, 0),
(1134, '', '18', '', 0, 201, 0),
(1135, '', '70', '', 0, 202, 0),
(1136, '', '18', '', 0, 201, 0),
(1137, '', '70', '', 0, 202, 0),
(1138, '', '72', '', 0, 203, 0),
(1139, '', '72', '', 0, 203, 0),
(1140, '', '71', '', 0, 204, 0),
(1141, '', '77', '', 0, 205, 0),
(1142, '', '77', '', 0, 205, 0),
(1143, '', '73', '', 0, 206, 0),
(1144, '', '78', '', 0, 207, 0),
(1145, '', '74', '', 0, 208, 0),
(1146, '', '75', '', 0, 209, 0),
(1147, '', '76', '', 0, 210, 0),
(1148, '', '31', '', 0, 211, 0),
(1149, '', '32', '', 0, 212, 0),
(1150, '', '33', '', 0, 213, 0),
(1151, '', '34', '', 0, 214, 0),
(1152, '', '35', '', 0, 215, 0),
(1153, '', '90', '', 0, 216, 0),
(1154, '', '91', '', 0, 217, 0),
(1155, '', '92', '', 0, 218, 0),
(1156, '', '93', '', 0, 219, 0),
(1157, '', '702', '', 0, 221, 0),
(1158, '', '701', '', 0, 220, 0),
(1159, '', '703', '', 0, 222, 0),
(1160, '', '704', '', 0, 223, 0),
(1161, '', '705', '', 0, 224, 0),
(1162, '', '706', '', 0, 225, 0),
(1163, '', '11', '', 0, 227, 0),
(1164, '', '6', '', 0, 187, 105),
(1165, '', '9', '', 0, 189, 105),
(1166, '', '10', '', 0, 190, 105),
(1167, '', '3', '', 0, 176, 105),
(1168, '', '7', '', 0, 188, 105),
(1169, '', '1', '', 0, 174, 105),
(1170, 'order_id', '', '', 1, 245, 110),
(1171, 'order_id', '', '', 1, 246, 110),
(1172, 'order_id', '', '', 0, 245, 110),
(1173, 'page', '', '', 0, 245, 126),
(1174, 'start_time', '', '', 0, 245, 125),
(1175, 'end_time', '', '', 0, 245, 124),
(1176, 'order_status', '', '', 0, 245, 123),
(1177, 'count', '', '', 0, 195, 89),
(1178, 'hour', '', '', 0, 195, 108),
(1179, 'begin_time', '', '', 0, 195, 85),
(1180, '', '17', '', 0, 195, 105),
(1181, 'itemid', '', '', 0, 195, 114),
(1182, '', '17', '', 0, 192, 105),
(1183, 'target', '', '', 0, 192, 88),
(1184, 'show', '1', '8', 0, 173, 90),
(1185, '', '90', '', 0, 216, 105),
(1186, '', '91', '', 0, 217, 105),
(1187, '', '2', '', 0, 175, 105),
(1188, '', '14', '', 0, 193, 105),
(1189, '', '15', '', 0, 194, 105),
(1190, '', '20', '', 0, 196, 105),
(1191, '', '21', '', 0, 197, 105),
(1192, '', '22', '', 0, 198, 105),
(1193, '', '23', '', 0, 199, 105),
(1194, '', '70', '', 0, 202, 105),
(1195, '', '71', '', 0, 204, 105),
(1196, '', '72', '', 0, 203, 105),
(1197, '', '77', '', 0, 205, 105),
(1198, '', '73', '', 0, 206, 105),
(1199, '', '78', '', 0, 207, 105),
(1200, '', '92', '', 0, 218, 105),
(1201, '', '93', '', 0, 219, 105),
(1202, 'target', '', '', 0, 195, 88);

-- --------------------------------------------------------

--
-- 表的结构 `w_api_param`
--

CREATE TABLE IF NOT EXISTS `w_api_param` (
  `api_param_id` int(10) unsigned NOT NULL,
  `field_alias` varchar(255) NOT NULL DEFAULT '',
  `field_name` varchar(50) NOT NULL DEFAULT '',
  `api_param_desc` varchar(255) NOT NULL DEFAULT '',
  `value` text NOT NULL,
  `api_param_type` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `field_type` tinyint(1) NOT NULL DEFAULT '0',
  `input_type` tinyint(1) unsigned NOT NULL,
  `is_param` tinyint(1) unsigned NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `w_api_param`
--

INSERT INTO `w_api_param` (`api_param_id`, `field_alias`, `field_name`, `api_param_desc`, `value`, `api_param_type`, `field_type`, `input_type`, `is_param`) VALUES
(85, '开始时间', 'begin_time', '', '', 0, 0, 1, 1),
(86, '浏览时间', 'browse_time', '', '100-180=100秒-180秒\n180-280=180秒-1280秒\n280-380=280秒-380秒\n380-480=380秒-480秒', 0, 0, 2, 1),
(87, '商品关键字', 'keyword', '', '', 0, 0, 1, 1),
(88, '商品链接', 'target', '', '', 0, 0, 1, 1),
(89, '发布量', 'count', '', '', 0, 0, 1, 1),
(90, '展现', 'show', '', '', 0, 0, 1, 1),
(92, '浏览其他宝贝', 'depth', '', '0=不浏览\n1=随机浏览\n2=深度浏览', 0, 0, 2, 1),
(93, '店铺访问模式', 'shopVisit', '', 'sales=按销量\nfavos=按收藏\ncates=按全部品类\nno=不访问', 0, 0, 2, 1),
(105, '任务类型', 'type', '', '0=淘宝流量任务APP搜索\n1=淘宝流量任务PC搜索\n2=淘宝流量任务直访店铺\n3=淘宝流量任务直访商品\n6=淘宝店铺收藏\n7=淘宝商品收藏\n9=淘宝商品搜索\n10=淘宝商品直接加购\n11=商品搜索加购\n12=淘宝直播关注\n14=直播观看人数\n15=淘宝开团提醒\n17=淘宝商品点赞\n20=淘抢购任务\n21=微淘达人文章阅读任务阅读次数\n22=微淘达人文章阅读任务阅读人数\n23=微淘达人文章阅读任务引导进店\n24=淘宝直播热度\n18=淘宝直播间加购任务\n70=京东流量任务\n72=京东店铺收藏任务\n71=京东商品直接收藏任务\n77=京东商品搜索收藏任务\n73=京东商品直接加购任务\n78=京东商品搜索加购任务\n74=京东达人关注任务\n75=京东预约任务\n76=京东秒杀提醒任务\n31=抖音任务抖音粉丝\n32=抖音任务抖音点赞\n33=抖音任务抖音播放\n34=抖音任务抖音分享\n35=抖音任务抖音评论\n90=拼多多流量任务\n91=拼多多商品搜索收藏任务\n92=拼多多商品直接收藏任务\n93=拼多多店铺收藏任务\n701=千人千页\n702=卡首屏\n703=查旺旺信用和黑号\n704=查淘客订单，检查是不是淘宝客订单\n705=解析淘口令\n706=生成淘口令\n', 0, 0, 2, 0),
(107, '发布天数', 'send_day', '', '', 0, 0, 1, 1),
(108, '时间段细分', 'hour', '', '', 0, 0, 1, 1),
(110, '订单号', 'order_id', '', '', 0, 0, 1, 1),
(111, '直播淘口令', 'target', '', '', 0, 0, 1, 1),
(112, '达人链接', 'target', '', '', 0, 0, 1, 1),
(113, '任务id', 'id', '', '', 0, 0, 1, 1),
(114, '宝贝id', '任务id', '', '', 0, 0, 1, 1),
(115, '旺旺', 'nick', '', '', 0, 0, 1, 1),
(116, '淘宝客订单号', 'tk_orderid', '', '', 0, 0, 1, 1),
(117, '淘口令', 'tb_pwd', '', '', 0, 0, 1, 1),
(118, '商品链接', 'item_url', '', '', 0, 0, 1, 1),
(119, '显示标题', 'title', '', '', 0, 0, 1, 1),
(120, '显示的图片', 'pic_url', '', '', 0, 0, 1, 1),
(121, '商品价格', 'price', '', '', 0, 0, 1, 1),
(122, '达人id', 'useid', '', '', 0, 0, 1, 1),
(123, '任务状态', 'status', '', '', 0, 0, 1, 1),
(124, '起始日期', 'date1', '起始日期 如：2016-01-01', '', 0, 0, 1, 1),
(125, '结束日期', 'date2', '结束日期 如：\n2016-01-02', '', 0, 0, 1, 1),
(126, '第几页', 'page', '', '', 0, 0, 1, 1);

-- --------------------------------------------------------

--
-- 表的结构 `w_api_price`
--

CREATE TABLE IF NOT EXISTS `w_api_price` (
  `price_id` int(10) unsigned NOT NULL,
  `level_id` int(10) unsigned NOT NULL DEFAULT '0',
  `api_id` int(10) unsigned NOT NULL DEFAULT '0',
  `price` decimal(10,2) DEFAULT NULL COMMENT 'decimal(10,2)'
) ENGINE=InnoDB AUTO_INCREMENT=388 DEFAULT CHARSET=latin1;

--
-- 转存表中的数据 `w_api_price`
--

INSERT INTO `w_api_price` (`price_id`, `level_id`, `api_id`, `price`) VALUES
(178, 1, 173, '8.00'),
(179, 22, 173, '8.00'),
(180, 23, 173, '8.00'),
(181, 1, 174, '333.00'),
(182, 22, 174, '4.00'),
(183, 23, 174, '4.00'),
(184, 1, 175, '7.00'),
(185, 22, 175, '9999.00'),
(186, 23, 175, '9999.00'),
(187, 1, 176, '0.00'),
(188, 22, 176, '4.00'),
(189, 23, 176, '4.00'),
(205, 1, 187, '33.00'),
(206, 22, 187, '14.00'),
(207, 23, 187, '14.00'),
(208, 1, 188, '0.00'),
(209, 22, 188, '10.00'),
(210, 23, 188, '10.00'),
(211, 1, 189, '0.00'),
(212, 22, 189, '14.00'),
(213, 23, 189, '14.00'),
(214, 1, 190, '0.00'),
(215, 22, 190, '10.00'),
(216, 23, 190, '10.00'),
(220, 1, 227, '0.00'),
(221, 22, 227, '14.00'),
(222, 23, 227, '14.00'),
(223, 1, 231, '0.00'),
(224, 22, 231, '0.00'),
(225, 23, 231, '0.00'),
(226, 1, 232, '0.00'),
(227, 22, 232, '0.00'),
(228, 23, 232, '0.00'),
(229, 1, 233, '0.00'),
(230, 22, 233, '0.00'),
(231, 23, 233, '0.00'),
(232, 1, 234, '0.00'),
(233, 22, 234, '0.00'),
(234, 23, 234, '0.00'),
(235, 1, 235, '0.00'),
(236, 22, 235, '0.00'),
(237, 23, 235, '0.00'),
(238, 1, 236, '0.00'),
(239, 22, 236, '0.00'),
(240, 23, 236, '0.00'),
(241, 1, 237, '0.00'),
(242, 22, 237, '0.00'),
(243, 23, 237, '0.00'),
(244, 1, 238, '0.00'),
(245, 22, 238, '0.00'),
(246, 23, 238, '0.00'),
(247, 1, 239, '0.00'),
(248, 22, 239, '0.00'),
(249, 23, 239, '0.00'),
(250, 1, 240, '0.00'),
(251, 22, 240, '0.00'),
(252, 23, 240, '0.00'),
(253, 1, 241, '0.00'),
(254, 22, 241, '0.00'),
(255, 23, 241, '0.00'),
(256, 1, 242, '0.00'),
(257, 22, 242, '0.00'),
(258, 23, 242, '0.00'),
(259, 1, 173, '0.00'),
(260, 22, 173, '3.00'),
(261, 23, 173, '3.00'),
(262, 22, 209, '14.00'),
(263, 23, 209, '14.00'),
(264, 22, 194, '9999.00'),
(265, 23, 194, '9999.00'),
(266, 22, 193, '2.00'),
(267, 23, 193, '2.00'),
(268, 24, 173, '3.00'),
(269, 24, 174, '4.00'),
(270, 24, 176, '4.00'),
(271, 22, 192, '20.00'),
(272, 23, 192, '20.00'),
(273, 22, 195, '4.00'),
(274, 23, 195, '4.00'),
(275, 22, 196, '8.00'),
(276, 23, 196, '8.00'),
(277, 22, 197, '4.00'),
(278, 23, 197, '4.00'),
(279, 22, 198, '6.00'),
(280, 23, 198, '6.00'),
(281, 22, 199, '8.00'),
(282, 23, 199, '8.00'),
(283, 22, 200, '9999.00'),
(284, 23, 200, '9999.00'),
(285, 24, 175, '9999.00'),
(286, 24, 187, '14.00'),
(287, 24, 188, '10.00'),
(288, 24, 201, '9999.00'),
(289, 22, 201, '9999.00'),
(290, 23, 201, '9999.00'),
(291, 24, 202, '6.00'),
(292, 22, 202, '6.00'),
(293, 23, 202, '6.00'),
(294, 24, 189, '14.00'),
(295, 24, 190, '10.00'),
(296, 24, 192, '20.00'),
(297, 24, 203, '10.00'),
(298, 22, 203, '10.00'),
(299, 23, 203, '10.00'),
(300, 24, 193, '2.00'),
(301, 24, 194, '9999.00'),
(302, 24, 204, '10.00'),
(303, 22, 204, '10.00'),
(304, 23, 204, '10.00'),
(305, 24, 195, '4.00'),
(306, 24, 196, '8.00'),
(307, 24, 197, '4.00'),
(308, 24, 198, '6.00'),
(309, 24, 199, '8.00'),
(310, 24, 200, '9999.00'),
(311, 24, 205, '16.00'),
(312, 22, 205, '16.00'),
(313, 23, 205, '16.00'),
(314, 24, 200, '9999.00'),
(315, 22, 200, '9999.00'),
(316, 23, 200, '9999.00'),
(317, 24, 206, '10.00'),
(318, 22, 206, '10.00'),
(319, 23, 206, '10.00'),
(320, 24, 207, '16.00'),
(321, 22, 207, '16.00'),
(322, 23, 207, '16.00'),
(323, 24, 208, '10.00'),
(324, 22, 208, '10.00'),
(325, 23, 208, '10.00'),
(326, 24, 209, '14.00'),
(327, 24, 210, '9999.00'),
(328, 22, 210, '9999.00'),
(329, 23, 210, '9999.00'),
(330, 24, 211, '9999.00'),
(331, 22, 211, '9999.00'),
(332, 23, 211, '9999.00'),
(333, 24, 212, '9999.00'),
(334, 22, 212, '9999.00'),
(335, 23, 212, '9999.00'),
(336, 24, 213, '9999.00'),
(337, 22, 213, '9999.00'),
(338, 23, 213, '9998.00'),
(339, 24, 214, '9999.00'),
(340, 22, 214, '9999.00'),
(341, 23, 214, '9999.00'),
(342, 24, 215, '9999.00'),
(343, 22, 215, '9999.00'),
(344, 23, 215, '9999.00'),
(345, 24, 216, '2.00'),
(346, 22, 216, '2.00'),
(347, 23, 216, '2.00'),
(348, 24, 217, '10.00'),
(349, 22, 217, '10.00'),
(350, 23, 217, '10.00'),
(351, 24, 218, '8.00'),
(352, 22, 218, '8.00'),
(353, 23, 218, '8.00'),
(354, 24, 219, '8.00'),
(355, 22, 219, '8.00'),
(356, 23, 219, '8.00'),
(357, 24, 220, '9999.00'),
(358, 22, 220, '9999.00'),
(359, 23, 220, '9999.00'),
(360, 24, 221, '9999.00'),
(361, 22, 221, '9999.00'),
(362, 23, 221, '9998.00'),
(363, 24, 222, '9999.00'),
(364, 22, 222, '9999.00'),
(365, 23, 222, '9999.00'),
(366, 24, 223, '9999.00'),
(367, 22, 223, '9999.00'),
(368, 23, 223, '9998.00'),
(369, 24, 224, '9999.00'),
(370, 22, 224, '9999.00'),
(371, 23, 224, '9998.00'),
(372, 24, 225, '9999.00'),
(373, 22, 225, '9999.00'),
(374, 23, 225, '9999.00'),
(375, 24, 227, '14.00'),
(376, 24, 244, '0.00'),
(377, 22, 244, '0.00'),
(378, 23, 244, '0.00'),
(379, 24, 245, '0.00'),
(380, 22, 245, '0.00'),
(381, 23, 245, '0.00'),
(382, 24, 246, '0.00'),
(383, 22, 246, '0.00'),
(384, 23, 246, '0.00'),
(385, 25, 173, '0.00'),
(386, 1, 195, '0.00'),
(387, 1, 202, '0.00');

-- --------------------------------------------------------

--
-- 表的结构 `w_api_type`
--

CREATE TABLE IF NOT EXISTS `w_api_type` (
  `api_type_id` int(10) unsigned NOT NULL,
  `api_type_name` varchar(50) NOT NULL DEFAULT '',
  `api_path` varchar(50) NOT NULL DEFAULT '',
  `api_param_id` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `w_api_type`
--

INSERT INTO `w_api_type` (`api_type_id`, `api_type_name`, `api_path`, `api_param_id`) VALUES
(11, '淘宝流量任务', '/ll/task_add', '85,86,87,88,89,90,92,93,105,107,108'),
(12, '淘宝收藏任务', '/ll/task_add', '85,87,88,89,105,107,108'),
(13, '取消任务', ' /ll/task_cancel', '110'),
(14, '任务查询', ' /ll/task_add', '110'),
(15, '淘宝搜索收藏', '/ll/task_add', '85,86,87,88,89,93,105,108'),
(16, '淘宝加购任务', '/ll/task_add', '85,87,88,89,105,108'),
(17, '搜索加购', '/ll/task_add', '85,86,87,88,89,92,105,108');

-- --------------------------------------------------------

--
-- 表的结构 `w_article`
--

CREATE TABLE IF NOT EXISTS `w_article` (
  `article_id` int(10) unsigned NOT NULL COMMENT '文章id',
  `article_title` varchar(255) NOT NULL DEFAULT '' COMMENT '文章标题',
  `article_author` varchar(30) NOT NULL DEFAULT '' COMMENT '文章作者',
  `article_desc` varchar(255) NOT NULL DEFAULT '' COMMENT '文章简短描述',
  `member_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员id',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态',
  `admin_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '审核管理员id',
  `release_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '发布时间',
  `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '文章添加时间',
  `like_people_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点赞人数',
  `seo_title` varchar(100) NOT NULL DEFAULT '' COMMENT 'seo标题',
  `seo_desc` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo描述',
  `seo_keywords` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo_关键字',
  `article_img` varchar(100) NOT NULL DEFAULT '',
  `item` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `category_id` int(10) unsigned NOT NULL DEFAULT '0',
  `content_id` int(10) unsigned NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COMMENT='文章表';

--
-- 转存表中的数据 `w_article`
--

INSERT INTO `w_article` (`article_id`, `article_title`, `article_author`, `article_desc`, `member_id`, `status`, `admin_id`, `release_time`, `add_time`, `like_people_num`, `seo_title`, `seo_desc`, `seo_keywords`, `article_img`, `item`, `category_id`, `content_id`) VALUES
(24, ' 新开淘宝店这四大淘宝流量你一定要知道', '张三', '淘宝是拥有亿万流量的电商大平台，但是对于众多的中小卖家来说，引流都是一个不小的难题。尤其是在经验和知识上都比较欠缺的新手卖家，引流更是难上加难。今天猎流网店优化.', 0, 0, 0, '2020-04-10 07:49:06', '2020-04-10 07:49:06', 1, 'rere', '\nddd', 'ddd', '/upload/20200318/fcb392664e2fa81fed8eed1b7e500a70.jpg', 1, 4, 1),
(25, ' 新开淘宝店这四大淘宝流量你一定要知道', '张三', '淘宝是拥有亿万流量的电商大平台，但是对于众多的中小卖家来说，引流都是一个不小的难题。尤其是在经验和知识上都比较欠缺的新手卖家，引流更是难上加难。今天猎流网店优化.', 0, 0, 0, '2020-04-10 07:49:21', '2020-04-10 07:49:21', 0, '', '', '', '/upload/20200318/fcb392664e2fa81fed8eed1b7e500a70.jpg', 1, 4, 1),
(26, ' 新开淘宝店这四大淘宝流量你一定要知道', '张三', '淘宝是拥有亿万流量的电商大平台，但是对于众多的中小卖家来说，引流都是一个不小的难题。尤其是在经验和知识上都比较欠缺的新手卖家，引流更是难上加难。今天猎流网店优化.', 0, 0, 0, '2020-04-10 07:49:22', '2020-04-10 07:49:22', 0, '', '', '', '/upload/20200318/fcb392664e2fa81fed8eed1b7e500a70.jpg', 1, 4, 1),
(27, ' 新开淘宝店这四大淘宝流量你一定要知道', '张三', '淘宝是拥有亿万流量的电商大平台，但是对于众多的中小卖家来说，引流都是一个不小的难题。尤其是在经验和知识上都比较欠缺的新手卖家，引流更是难上加难。今天猎流网店优化.', 0, 0, 0, '2020-04-10 07:50:36', '2020-04-10 07:50:36', 0, '', '', '', '/upload/20200318/fcb392664e2fa81fed8eed1b7e500a70.jpg', 1, 4, 0),
(33, ' 新开淘宝店这四大淘宝流量你一定要知道', '张三', '淘宝是拥有亿万流量的电商大平台，但是对于众多的中小卖家来说，引流都是一个不小的难题。尤其是在经验和知识上都比较欠缺的新手卖家，引流更是难上加难。今天猎流网店优化.', 0, 0, 0, '2020-04-10 07:50:36', '2020-04-10 07:50:36', 0, '', '', '', '/upload/20200318/fcb392664e2fa81fed8eed1b7e500a70.jpg', 1, 4, 0);

-- --------------------------------------------------------

--
-- 表的结构 `w_article_category`
--

CREATE TABLE IF NOT EXISTS `w_article_category` (
  `category_id` int(10) unsigned NOT NULL COMMENT '文章分类id',
  `category_title` varchar(255) NOT NULL DEFAULT '' COMMENT '分类id',
  `category_parent` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '分类父级id',
  `category_parent_path` varchar(10) NOT NULL DEFAULT '' COMMENT '分类父节点路径',
  `seo_title` varchar(50) NOT NULL DEFAULT '' COMMENT 'seo标题',
  `seo_keywords` varchar(100) NOT NULL DEFAULT '' COMMENT 'seo 关键字',
  `seo_desc` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo描述',
  `sort` tinyint(255) unsigned NOT NULL DEFAULT '255'
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='文章分类';

--
-- 转存表中的数据 `w_article_category`
--

INSERT INTO `w_article_category` (`category_id`, `category_title`, `category_parent`, `category_parent_path`, `seo_title`, `seo_keywords`, `seo_desc`, `sort`) VALUES
(2, '网站公告', 0, '', '网站公告', '网站公告', '网站公告', 255),
(3, '常见问题', 0, '', '常见问题', '常见问题', '', 255),
(4, '资讯干货', 0, '', '资讯干货', '资讯干货', '', 255);

-- --------------------------------------------------------

--
-- 表的结构 `w_article_comment`
--

CREATE TABLE IF NOT EXISTS `w_article_comment` (
  `comment_id` int(10) unsigned NOT NULL COMMENT '评论id',
  `comment_content` varchar(255) NOT NULL DEFAULT '' COMMENT '评论内容'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章评论表';

-- --------------------------------------------------------

--
-- 表的结构 `w_article_like`
--

CREATE TABLE IF NOT EXISTS `w_article_like` (
  `member_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员id',
  `article_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文章id'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='文章喜欢人数';

-- --------------------------------------------------------

--
-- 表的结构 `w_cash`
--

CREATE TABLE IF NOT EXISTS `w_cash` (
  `cash_id` int(10) unsigned NOT NULL,
  `cash_money` decimal(10,2) NOT NULL DEFAULT '0.00',
  `account` varchar(50) DEFAULT NULL,
  `cash_state` tinyint(4) NOT NULL DEFAULT '0',
  `member_id` int(10) unsigned DEFAULT NULL,
  `account_type` tinyint(4) NOT NULL DEFAULT '1',
  `add_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `name` varchar(50) NOT NULL DEFAULT '',
  `remark` varchar(100) NOT NULL DEFAULT '',
  `admin_id` int(10) unsigned NOT NULL DEFAULT '0',
  `examine_time` varchar(50) NOT NULL DEFAULT ''
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `w_cash`
--

INSERT INTO `w_cash` (`cash_id`, `cash_money`, `account`, `cash_state`, `member_id`, `account_type`, `add_time`, `name`, `remark`, `admin_id`, `examine_time`) VALUES
(1, '123.00', '13710309387', 1, 4, 1, '2020-05-12 06:15:12', '', '', 0, ''),
(2, '123.00', '13710309387', 1, 4, 1, '2020-05-12 06:17:31', '', '', 0, ''),
(3, '111.00', '13710309387', 1, 4, 1, '2020-05-12 07:23:53', '', '', 0, ''),
(4, '111.00', '13710309387', 1, 4, 1, '2020-05-12 07:24:05', '', '', 0, ''),
(5, '111.00', '13710309387', 1, 4, 1, '2020-05-12 07:24:06', '', '', 0, ''),
(6, '111.00', '13710309387', 1, 4, 1, '2020-05-12 07:28:39', '', '', 0, ''),
(7, '111.00', '13710309387', 1, 4, 1, '2020-05-12 07:28:39', '', '', 0, ''),
(8, '111.00', '13710309387', 1, 4, 1, '2020-05-12 07:28:39', '', '', 0, ''),
(9, '111.00', '13710309387', 1, 4, 1, '2020-05-12 07:28:40', '', '', 0, ''),
(10, '111.00', '13710309387', 1, 4, 1, '2020-05-12 07:28:40', '', '', 0, ''),
(11, '111.00', '13710309387', 1, 4, 1, '2020-05-12 07:28:40', '', '', 0, ''),
(12, '111.00', '13710309387', 1, 4, 1, '2020-05-12 07:28:40', '', '', 0, ''),
(13, '111.00', '13710309387', 1, 4, 1, '2020-05-12 07:28:40', '', '', 0, ''),
(14, '111.00', '13710309387', 1, 4, 1, '2020-05-12 07:28:41', '', '', 0, ''),
(15, '111.00', '13710309387', 1, 4, 1, '2020-05-12 07:28:41', '', '', 0, ''),
(16, '111.00', '13710309387', 1, 4, 1, '2020-05-12 07:28:41', '', '', 0, ''),
(17, '111.00', '13710309387', 1, 4, 1, '2020-05-12 07:28:41', '', '', 0, ''),
(18, '111.00', '13710309387', 1, 4, 1, '2020-05-12 07:28:42', '', '', 0, ''),
(19, '111.00', '13710309387', 1, 4, 1, '2020-05-12 07:28:42', '', '', 0, ''),
(20, '111.00', '13710309387', 1, 4, 1, '2020-05-12 07:28:43', '', '', 0, ''),
(21, '111.00', '13710309387', 1, 4, 1, '2020-05-13 07:28:49', '', '', 0, ''),
(22, '211011.00', '22', 1, 4, 1, '2020-05-14 05:20:52', '', '', 0, ''),
(23, '2.00', '18716798410', 1, 4, 1, '2020-05-14 05:23:32', '', '', 0, ''),
(24, '2.00', '18716798410', 1, 4, 1, '2020-05-14 05:24:12', '', '', 0, ''),
(25, '2.00', '18716798410', 1, 4, 1, '2020-05-14 05:24:27', '', '', 0, ''),
(26, '2.00', '18716798410', 1, 4, 1, '2020-05-14 05:25:01', '', '', 0, ''),
(27, '0.00', '18716798410', 1, 4, 1, '2020-05-14 05:27:49', '', '', 0, ''),
(28, '0.00', '18716798410', 1, 4, 1, '2020-05-14 05:29:59', '', '', 0, ''),
(29, '1.00', '18716798410', 1, 4, 1, '2020-05-14 05:31:05', '', '', 0, ''),
(30, '10.00', 'fuwmwf2495@sandbox.com', 1, 3, 1, '2020-05-14 10:06:38', '', '', 0, ''),
(31, '1000.00', 'fuwmwf2495@sandbox.com', 1, 3, 1, '2020-05-14 10:06:48', '', '', 0, ''),
(32, '1000.00', 'fuwmwf2495@sandbox.com', 1, 3, 1, '2020-05-14 10:06:51', '', '', 0, ''),
(33, '1000.00', 'fuwmwf2495@sandbox.com', 1, 3, 1, '2020-05-14 10:06:51', '', '', 0, ''),
(34, '1000.00', 'fuwmwf2495@sandbox.com', 1, 3, 1, '2020-05-14 10:06:52', '', '', 0, ''),
(35, '1000.00', 'fuwmwf2495@sandbox.com', 1, 3, 1, '2020-05-14 10:06:52', '', '', 0, ''),
(36, '1000.00', 'fuwmwf2495@sandbox.com', 1, 3, 1, '2020-05-14 10:06:52', '', '', 0, ''),
(37, '1000.00', 'fuwmwf2495@sandbox.com', 1, 3, 1, '2020-05-14 10:06:53', '', '', 0, ''),
(38, '1000.00', 'fuwmwf2495@sandbox.com', 1, 3, 1, '2020-05-14 10:06:53', '', '', 0, ''),
(39, '1000.00', '18716798410', 1, 3, 1, '2020-05-14 10:16:40', '', '', 0, ''),
(40, '1000.00', '18716798410', 1, 3, 1, '2020-05-14 10:16:51', '', '', 0, ''),
(41, '100.00', 'fuwmwf2495@sandbox.com', 1, 4, 1, '2020-05-14 11:09:49', '沙箱', '', 0, ''),
(42, '1000.00', 'fuwmwf2495@sandbox.com', 3, 4, 1, '2020-05-14 11:11:10', '沙箱', '333333', 0, ''),
(43, '1000.00', 'fuwmwf2495@sandbox.com', 3, 4, 1, '2020-05-14 11:11:10', '沙箱', '3333', 0, ''),
(44, '1000.00', 'fuwmwf2495@sandbox.com', 3, 4, 1, '2020-05-14 11:11:10', '沙箱', '', 0, ''),
(45, '1000.00', 'fuwmwf2495@sandbox.com', 3, 4, 1, '2020-05-14 11:11:11', '沙箱', '333', 0, ''),
(46, '1000.00', 'fuwmwf2495@sandbox.com', 3, 4, 1, '2020-05-14 11:11:11', '沙箱', '3333', 0, ''),
(47, '1000.00', 'fuwmwf2495@sandbox.com', 1, 4, 1, '2020-05-14 11:11:11', '沙箱', '', 0, ''),
(48, '1000.00', 'fuwmwf2495@sandbox.com', 3, 4, 1, '2020-05-14 11:11:11', '沙箱', '', 0, ''),
(49, '1000.00', 'fuwmwf2495@sandbox.com', 1, 4, 1, '2020-05-14 11:11:11', '沙箱', '', 0, ''),
(50, '1000.00', 'fuwmwf2495@sandbox.com', 1, 4, 1, '2020-05-14 11:11:11', '沙箱', '', 0, ''),
(51, '100000.00', 'fuwmwf2495@sandbox.com', 3, 4, 1, '2020-05-14 11:18:38', '沙箱环境', '', 0, ''),
(52, '1000.00', 'fuwmwf2495@sandbox.com', 3, 4, 1, '2020-05-14 11:19:43', '沙箱环境', '333333', 0, ''),
(53, '1000.00', 'fuwmwf2495@sandbox.com', 0, 4, 1, '2020-05-14 11:58:13', '沙箱环境', '', 0, ''),
(54, '1000.00', 'fuwmwf2495@sandbox.com', 0, 4, 1, '2020-05-14 11:58:13', '沙箱环境', '', 0, ''),
(55, '1000.00', 'fuwmwf2495@sandbox.com', 0, 4, 1, '2020-05-14 11:58:13', '沙箱环境', '', 0, ''),
(56, '1000.00', 'fuwmwf2495@sandbox.com', 0, 4, 1, '2020-05-14 11:58:13', '沙箱环境', '', 0, ''),
(57, '1000.00', 'fuwmwf2495@sandbox.com', 0, 4, 1, '2020-05-14 11:58:14', '沙箱环境', '', 0, ''),
(58, '1000.00', 'fuwmwf2495@sandbox.com', 0, 4, 1, '2020-05-14 11:58:14', '沙箱环境', '', 0, ''),
(59, '1000.00', 'fuwmwf2495@sandbox.com', 0, 4, 1, '2020-05-14 11:58:14', '沙箱环境', '', 0, ''),
(60, '1000.00', 'fuwmwf2495@sandbox.com', 0, 4, 1, '2020-05-14 11:58:14', '沙箱环境', '', 0, ''),
(61, '1000.00', 'fuwmwf2495@sandbox.com', 0, 4, 1, '2020-05-14 11:58:14', '沙箱环境', '', 0, ''),
(62, '1000.00', 'fuwmwf2495@sandbox.com', 0, 4, 1, '2020-05-14 11:58:14', '沙箱环境', '', 0, ''),
(63, '1000.00', 'fuwmwf2495@sandbox.com', 0, 4, 1, '2020-05-14 11:58:15', '沙箱环境', '', 0, ''),
(64, '1000.00', 'fuwmwf2495@sandbox.com', 1, 4, 1, '2020-05-14 11:58:15', '沙箱环境', '', 1, '1589458481'),
(65, '1000.00', 'fuwmwf2495@sandbox.com', 0, 4, 1, '2020-05-14 11:58:15', '沙箱环境', '', 0, ''),
(66, '1000.00', 'fuwmwf2495@sandbox.com', 0, 4, 1, '2020-05-14 11:58:15', '沙箱环境', '', 0, ''),
(67, '1000.00', 'fuwmwf2495@sandbox.com', 0, 4, 1, '2020-05-14 11:58:15', '沙箱环境', '', 0, ''),
(68, '1000.00', 'fuwmwf2495@sandbox.com', 0, 4, 1, '2020-05-14 11:58:16', '沙箱环境', '', 0, ''),
(69, '1000.00', 'fuwmwf2495@sandbox.com', 0, 4, 1, '2020-05-14 11:58:16', '沙箱环境', '', 0, ''),
(70, '1000.00', 'fuwmwf2495@sandbox.com', 1, 4, 1, '2020-05-14 11:58:16', '沙箱环境', '', 1, '1589458501'),
(71, '1000.00', 'fuwmwf2495@sandbox.com', 1, 4, 1, '2020-05-14 11:58:16', '沙箱环境', '', 1, '1589458497'),
(72, '1000.00', 'fuwmwf2495@sandbox.com', 1, 4, 1, '2020-05-14 11:58:16', '沙箱环境', '', 1, '1589458492'),
(73, '1000.00', 'fuwmwf2495@sandbox.com', 3, 4, 1, '2020-05-14 11:58:16', '沙箱环境', '3333', 1, '1589458399'),
(74, '1000.00', 'fuwmwf2495@sandbox.com', 3, 4, 1, '2020-05-14 11:58:17', '沙箱环境', '3333', 1, '1589458337'),
(75, '1000.00', 'fuwmwf2495@sandbox.com', 3, 4, 1, '2020-05-14 11:58:17', '沙箱环境', '3333', 1, ''),
(76, '1000.00', 'fuwmwf2495@sandbox.com', 3, 4, 1, '2020-05-14 11:58:17', '沙箱环境', '34343', 0, ''),
(77, '1000.00', 'fuwmwf2495@sandbox.com', 3, 4, 1, '2020-05-14 11:58:17', '沙箱环境', '3334343', 0, ''),
(78, '1000.00', 'fuwmwf2495@sandbox.com', 3, 4, 1, '2020-05-14 11:58:17', '沙箱环境', '323432423', 1, ''),
(79, '5.00', '13710309387', 1, 4, 1, '2020-05-15 06:33:08', '廖桂钦', 'ggfdc\n', 1, '1589524659');

-- --------------------------------------------------------

--
-- 表的结构 `w_cash_back_log`
--

CREATE TABLE IF NOT EXISTS `w_cash_back_log` (
  `id` int(11) NOT NULL,
  `cash_back` decimal(11,2) DEFAULT NULL COMMENT '返现金额',
  `source_member_id` int(11) DEFAULT NULL COMMENT '来源用户id',
  `member_id` int(11) DEFAULT NULL COMMENT '用户id',
  `recharge_order_id` int(11) DEFAULT '0' COMMENT '充值订单id'
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `w_cash_back_log`
--

INSERT INTO `w_cash_back_log` (`id`, `cash_back`, `source_member_id`, `member_id`, `recharge_order_id`) VALUES
(1, '99900.00', 3, 4, 198),
(2, '10010.01', 3, 4, 219),
(3, '199.80', 3, 4, 230),
(4, '27.00', 3, 4, 231);

-- --------------------------------------------------------

--
-- 表的结构 `w_column`
--

CREATE TABLE IF NOT EXISTS `w_column` (
  `column_id` smallint(5) unsigned NOT NULL COMMENT '菜单id',
  `column_name` varchar(30) NOT NULL DEFAULT '' COMMENT '菜单昵称',
  `column_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '父级菜单',
  `column_parent_path` varchar(100) NOT NULL DEFAULT '',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '栏目添加时间',
  `sort` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `keywords` varchar(50) NOT NULL DEFAULT '' COMMENT 'seo关键字',
  `description` varchar(100) NOT NULL DEFAULT '' COMMENT 'seo描述',
  `show_location` tinyint(4) NOT NULL DEFAULT '0',
  `control` varchar(50) NOT NULL DEFAULT '',
  `method` varchar(50) NOT NULL DEFAULT ''
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='前台导航';

--
-- 转存表中的数据 `w_column`
--

INSERT INTO `w_column` (`column_id`, `column_name`, `column_parent`, `column_parent_path`, `addtime`, `sort`, `keywords`, `description`, `show_location`, `control`, `method`) VALUES
(51, '资讯', 0, '', '2020-04-10 01:24:49', 255, '', '', 0, 'article_cat', 'index'),
(49, '价格表', 0, '', '2020-04-10 01:22:34', 2, '', '', 0, 'price', 'index'),
(50, '下载软件', 0, '', '2020-04-10 01:22:47', 3, '', '', 0, 'app', 'download'),
(52, '发布任务', 0, '', '2020-04-10 01:26:16', 255, '', '', 0, '', ''),
(47, '主页', 0, '', '2020-04-10 01:21:25', 1, '', '', 0, '', '');

-- --------------------------------------------------------

--
-- 表的结构 `w_comment_article`
--

CREATE TABLE IF NOT EXISTS `w_comment_article` (
  `article_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文章id',
  `comment_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评论id',
  `member_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员id'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='评论，文章 中间表';

-- --------------------------------------------------------

--
-- 表的结构 `w_content`
--

CREATE TABLE IF NOT EXISTS `w_content` (
  `content_id` int(10) unsigned NOT NULL,
  `content` text COMMENT '内容',
  `column_id` int(10) unsigned NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `w_content`
--

INSERT INTO `w_content` (`content_id`, `content`, `column_id`) VALUES
(1, '332323', 0),
(15, '<!DOCTYPE html>\n<html>\n<head>\n</head>\n<body>\n<p>fsdfsdfs</p>\n</body>\n</html>', 0),
(16, '<!DOCTYPE html>\n<html>\n<head>\n</head>\n<body>\n\n</body>\n</html>', 0),
(17, '&lt;!DOCTYPE html&gt;\n&lt;html&gt;\n&lt;head&gt;\n&lt;/head&gt;\n&lt;body&gt;\n\n&lt;/body&gt;\n&lt;/html&gt;', 0),
(18, '&lt;!DOCTYPE html&gt;\n&lt;html&gt;\n&lt;head&gt;\n&lt;/head&gt;\n&lt;body&gt;\n\n&lt;/body&gt;\n&lt;/html&gt;', 0),
(19, '', 0),
(20, '', 0),
(21, '', 0),
(22, '&lt;!DOCTYPE html&gt;\n&lt;html&gt;\n&lt;head&gt;\n&lt;/head&gt;\n&lt;body&gt;\n&lt;p&gt;sdfdsf&lt;/p&gt;\n&lt;/body&gt;\n&lt;/html&gt;', 0),
(23, '&lt;p&gt;fsdfsdfsd&lt;/p&gt;', 0),
(24, '', 0),
(25, '', 0);

-- --------------------------------------------------------

--
-- 表的结构 `w_friend_link`
--

CREATE TABLE IF NOT EXISTS `w_friend_link` (
  `link_id` smallint(5) unsigned NOT NULL COMMENT '主键id',
  `link_name` varchar(30) NOT NULL DEFAULT '' COMMENT '链接名称',
  `link_desc` varchar(255) NOT NULL DEFAULT '' COMMENT '链接描述',
  `link_logo` varchar(50) NOT NULL DEFAULT '' COMMENT '商标',
  `link_address` varchar(50) NOT NULL DEFAULT '' COMMENT '链接地址'
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `w_friend_link`
--

INSERT INTO `w_friend_link` (`link_id`, `link_name`, `link_desc`, `link_logo`, `link_address`) VALUES
(19, '333', '333', '', '333'),
(20, '愿望树', 'dfsdfdsf', '', 'www.baidu.com');

-- --------------------------------------------------------

--
-- 表的结构 `w_member`
--

CREATE TABLE IF NOT EXISTS `w_member` (
  `member_id` int(10) unsigned NOT NULL COMMENT '用户id',
  `pwd` varchar(32) NOT NULL COMMENT '用户密码',
  `add_ip` varchar(16) NOT NULL DEFAULT '' COMMENT '添加ip',
  `nickname` varchar(16) NOT NULL COMMENT '用户昵称',
  `phone` char(15) DEFAULT NULL COMMENT '手机号码',
  `email` varchar(50) NOT NULL DEFAULT '',
  `add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
  `last_ip` varchar(16) NOT NULL DEFAULT '' COMMENT '最后一次登录ip',
  `currency` decimal(18,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '用户余额',
  `brokerage_price` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '佣金金额',
  `pay_count` int(11) unsigned DEFAULT '0' COMMENT '用户购买次数',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1为正常，0为禁止',
  `spread_member_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '推广元id',
  `is_promoter` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否为推广员',
  `spread_count` int(11) DEFAULT '0' COMMENT '下级人数',
  `mark` varchar(255) NOT NULL DEFAULT '' COMMENT '用户备注',
  `level_id` int(10) unsigned NOT NULL DEFAULT '1',
  `last_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `subordinate_member_id` int(11) DEFAULT '0' COMMENT '所属上级id',
  `proportion_money` decimal(10,2) DEFAULT '0.00'
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户表';

--
-- 转存表中的数据 `w_member`
--

INSERT INTO `w_member` (`member_id`, `pwd`, `add_ip`, `nickname`, `phone`, `email`, `add_time`, `last_ip`, `currency`, `brokerage_price`, `pay_count`, `status`, `spread_member_id`, `is_promoter`, `spread_count`, `mark`, `level_id`, `last_time`, `subordinate_member_id`, `proportion_money`) VALUES
(3, 'e10adc3949ba59abbe56e057f20f883e', '', '张三', '18716798410', '', 1588906122, '61.140.122.136', '2080300.00', '96875.01', 4, 1, 0, 0, 0, '', 1, '0000-00-00 00:00:00', 4, '300.00'),
(4, 'e10adc3949ba59abbe56e057f20f883e', '', '三毛', '13710309387', '', 1588906447, '61.140.122.136', '14274025.00', '85137.81', 14, 1, 3, 0, 0, '', 1, '0000-00-00 00:00:00', 0, '50.00');

-- --------------------------------------------------------

--
-- 表的结构 `w_member_level`
--

CREATE TABLE IF NOT EXISTS `w_member_level` (
  `level_id` smallint(5) unsigned NOT NULL,
  `level_name` varchar(30) NOT NULL DEFAULT '' COMMENT '等级名称',
  `level_router` tinyint(10) NOT NULL DEFAULT '0' COMMENT '等级规则',
  `brokerage` decimal(3,2) NOT NULL DEFAULT '0.00' COMMENT '佣金比例',
  `api_id` text,
  `min_money` decimal(10,2) NOT NULL DEFAULT '0.00',
  `discount` text,
  `currency_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `withdrawal` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `router_parameter` decimal(10,2) NOT NULL DEFAULT '0.00'
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `w_member_level`
--

INSERT INTO `w_member_level` (`level_id`, `level_name`, `level_router`, `brokerage`, `api_id`, `min_money`, `discount`, `currency_price`, `withdrawal`, `router_parameter`) VALUES
(23, '黄金', 1, '0.00', NULL, '0.00', NULL, '0.00', '0.00', '0.00'),
(22, '代理商', 1, '0.00', NULL, '0.00', '[{"money":"","proportion":""}]', '0.00', '0.00', '200.00'),
(1, '普通会员', 1, '0.90', NULL, '0.00', '[{"money":"200","proportion":"0"},{"money":"500","proportion":"50"},{"money":"1000","proportion":"100"},{"money":"2000","proportion":"200"},{"money":"3000","proportion":"300"}]', '150.00', '0.00', '100.00');

-- --------------------------------------------------------

--
-- 表的结构 `w_recharge_order`
--

CREATE TABLE IF NOT EXISTS `w_recharge_order` (
  `id` int(11) NOT NULL,
  `member_id` int(11) DEFAULT NULL COMMENT '用户id',
  `pay_type` tinyint(2) DEFAULT NULL COMMENT '1=>支付宝,2=>微信',
  `order_sn` varchar(40) DEFAULT NULL COMMENT '订单号',
  `pay_state` tinyint(2) DEFAULT '0' COMMENT '支付状态 -1：取消 0 未完成 1已完成 -2:异常',
  `amount` decimal(11,2) DEFAULT NULL COMMENT '充值金额',
  `pay_source` varchar(255) DEFAULT NULL COMMENT '订单来源',
  `completion_time` int(11) DEFAULT NULL COMMENT '订单完成时间',
  `add_time` int(11) DEFAULT NULL COMMENT '下单时间',
  `describe` text COMMENT '订单描述',
  `pay_trans` varchar(255) DEFAULT NULL COMMENT '支付流水号(第三方订单号)',
  `return_info` text COMMENT '返回信息',
  `is_recharge` tinyint(2) DEFAULT '0' COMMENT '1=>已充值,0=>未充值(流量币)'
) ENGINE=InnoDB AUTO_INCREMENT=264 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='充值订单表\n';

--
-- 转存表中的数据 `w_recharge_order`
--

INSERT INTO `w_recharge_order` (`id`, `member_id`, `pay_type`, `order_sn`, `pay_state`, `amount`, `pay_source`, `completion_time`, `add_time`, `describe`, `pay_trans`, `return_info`, `is_recharge`) VALUES
(153, 2048, 0, '2020050716304463512781', 1, '10000.00', '支付宝网页支付', 1588840257, 1588840244, '商品描述', '2020050722001498330500901263', '{"gmt_create":"2020-05-07 16:30:46","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"bdIoEhPSflkDtGULt6ogT7sH29VXLlf56kT\\/3yaxvUUoxTgVG+5l42+YcWT3DgQfMiOlu6nrn557LXbwyapyK4XujcCjjWg8gLw+2\\/6peOPO+chiKo2vAAyI4lfuc6kEX0HJi3XTNBa76jUPAt38WBP5cjOBA7CDjH1yWxBC0lvHRWTkmCEB5waFYe+gO6Df9KjYfoFtwzqwAkAZs6vkfnuxJSdYF+OlxSEbrgtvyZbzXuGMlmh1boy8xhqmfCMmKPnsf2jba20I6k\\/1xS38ED7qSAqQ7OCztlqqWLBtxCzfYflEDKH1NUzmNtVpQkax8CcRt8ZJ7MAwXxLA8+y6fg==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"10000.00","notify_id":"2020050700222163057098330504670072","fund_bill_list":"[{\\"amount\\":\\"10000.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"10000.00","buyer_pay_amount":"10000.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-07 16:30:57","notify_time":"2020-05-07 16:30:58","version":"1.0","out_trade_no":"2020050716304463512781","total_amount":"10000.00","trade_no":"2020050722001498330500901263","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 1),
(154, 2048, 0, '2020050717193390280266', 1, '10000.00', '支付宝网页支付', 1588843190, 1588843173, '商品描述', '2020050722001498330500901420', '{"gmt_create":"2020-05-07 17:19:40","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"r5w1jyQs3QWg2x9g0MhojSijFFiz47GEcA+kl7RoZ\\/r0zF7UIbYK+1SV25dovv7icj5FgWlwUbvmubpj5YFlrvAD+sllDfSt+CXf7Jbu9XOQQzNH6nVAORru0yiy2R5Yp6wgw\\/WwBFaYu\\/Wz9s\\/HHZKa1nCPxJZaneh\\/6L8L42BIUYTsOOGiVF67u6KApSG\\/BSM22o9k4DzA0XUQaJbcCScg0lSvehtrTVPSVBSXSEVMtv3Oh8JdSMKd0sXvQWnCp3sGbnaYxx5+rB8cr+j8w2SkZ3ThIdqXSYEfbkFWMTn4950f0uiCy2Qbop8fsTqNfzEe2PL7J8fbmjToRrGBbA==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"10000.00","notify_id":"2020050700222171951098330504670073","fund_bill_list":"[{\\"amount\\":\\"10000.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"10000.00","buyer_pay_amount":"10000.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-07 17:19:50","notify_time":"2020-05-07 17:19:51","version":"1.0","out_trade_no":"2020050717193390280266","total_amount":"10000.00","trade_no":"2020050722001498330500901420","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 0),
(155, 2048, 0, '2020050717224679803997', 1, '1000.00', '支付宝网页支付', 1588843382, 1588843366, '商品描述', '2020050722001498330500901265', '{"gmt_create":"2020-05-07 17:22:52","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"AZHblLw4v6YlsR6OwQu79X5Xa55xwEaSAxUiVZdpB6E7hLAJcDz3DGjYm6i43dAJyV7aIraQ68m68u4RrCzbjqtiiXHT3XGB0Nc+xDLVbOcs5zB\\/+yXc8KQxOVUfhLYOWOZ4AHt\\/8Sx7VASlI2\\/xMeDz3+ATP00W\\/f5dTbLnI26UVDktzvveS3PngvHiCvYV6yr1dpr9vgAxPV6tWG3+amPi7xCGsg8dkR8GIXVVAjSTBNlfZeECnY8pTXQQ8FTio\\/zFa9zRPZecpomtOj6LW4z3yYDJJHbNuBd+u6caZlKCn\\/UsONxTHT4XCqfOjCVevbSw0WM2b2dLrQu8Ej7Nvg==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"1000.00","notify_id":"2020050700222172302098330504670074","fund_bill_list":"[{\\"amount\\":\\"1000.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"1000.00","buyer_pay_amount":"1000.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-07 17:23:02","notify_time":"2020-05-07 17:23:02","version":"1.0","out_trade_no":"2020050717224679803997","total_amount":"1000.00","trade_no":"2020050722001498330500901265","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 0),
(156, 2048, 0, '2020050717242041715122', 1, '1000.00', '支付宝网页支付', 1588843472, 1588843460, '商品描述', '2020050722001498330500900802', '{"gmt_create":"2020-05-07 17:24:21","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"FNzNeORl9r0hxr\\/Pj+E6AXx4NiaWJHV3HyJKu7\\/jAwM8y0K3dXKafFLyLhhvthU6L3hlv1g2kGBXb4\\/RjCTWqQSH2uxyE7m9nmI0IfOGQ25f+7ygs8swv85drBVNC3Xmxo\\/lY\\/a5xYnBGGsOXJ3e5syawV29U2Lzl\\/Hb\\/oILMHY2pUUlOYVzmTnXy\\/MSjLTGwlwa0sBJQp+5X9FPT+B38Nswz1THavo3RMZM3TaqGPzmaFw6ltjWOQ8bI6qzxOSTvuyCH\\/w6joR0SJekTimpRi+KPSVaIMoyLtrUyP6CuhsLhKorb+h\\/xR7acHsnMYNr2ktzl5wMTBPVRIYYzOeTTw==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"1000.00","notify_id":"2020050700222172433098330504666283","fund_bill_list":"[{\\"amount\\":\\"1000.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"1000.00","buyer_pay_amount":"1000.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-07 17:24:32","notify_time":"2020-05-07 17:24:33","version":"1.0","out_trade_no":"2020050717242041715122","total_amount":"1000.00","trade_no":"2020050722001498330500900802","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 0),
(157, 2048, 0, '2020050717245777527135', 1, '10000.00', '支付宝网页支付', 1588843515, 1588843497, '商品描述', '2020050722001498330500901421', '{"gmt_create":"2020-05-07 17:25:01","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"XqkJzbQ4H46WiHog29s4FMitQl4IhTtuZgg+U4WfyV2HIDC9Dvinz67mF\\/ePinitjpkj\\/+KbfGpaAfd1uMTflu7Gt5jBTM0zff7IHPGOZQ2zUIwiz+2a9Dsbl7V6SIlhS93RByVNKSbCTna767vsrcqKJc0WIKRkoJrFbf+c5EtZ1Ei1tOIo53nzLMImOd77Pe+4JEQ32RSCQLqmMdpGSeWDjljwWhbohTt3mrUMsaZ727EB5f+1rzfxKwjxIKGoAFOz\\/YI83UxfZ55GJn\\/kJCIFolBhmIDcntFF1TJWgnsXORIXkz5lnJpgZuvjDyvRAnEB8ktKWIDTtSN5NK3mTA==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"10000.00","notify_id":"2020050700222172515098330504668791","fund_bill_list":"[{\\"amount\\":\\"10000.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"10000.00","buyer_pay_amount":"10000.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-07 17:25:15","notify_time":"2020-05-07 17:25:16","version":"1.0","out_trade_no":"2020050717245777527135","total_amount":"10000.00","trade_no":"2020050722001498330500901421","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 0),
(158, 2048, 0, '2020050717252985788035', 0, '10000.00', '支付宝网页支付', NULL, 1588843529, '商品描述', NULL, NULL, 0),
(159, 2048, 0, '2020050717260033632753', 1, '1000.00', '支付宝网页支付', 1588843574, 1588843560, '商品描述', '2020050722001498330500900803', '{"gmt_create":"2020-05-07 17:26:04","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"sD0MmdaSnKnjwYbdkApbQqFcqrlrH\\/\\/QW+0SA9aWKKotTX9iGwr84ODzjENxS5r25PJcf7Wr7ecNXLf3iGusv2tHS6N1quECDSZrHHLSMUk2T3lyla26id29UkKfVIzNntyb6+U\\/PJ0NvCZuk5TqpdDuoncXykTY8kKTMmcEcM1GTvvHHudQpXGFIER2wx+QEz4V14y0hnYaFbvu1lVL7bE7o7cslFuZgOJoFr3Lky64kYa4VcZYJIiIW5ILXSAAssmSfS9rek93JrWmz33ixsiL8s6GnQuq0dpRqYn8uTL2uXTLtHs29VhJgIF7zeJTgOuHitpXNChc4O4IBEBbqg==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"1000.00","notify_id":"2020050700222172614098330504666285","fund_bill_list":"[{\\"amount\\":\\"1000.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"1000.00","buyer_pay_amount":"1000.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-07 17:26:14","notify_time":"2020-05-07 17:26:14","version":"1.0","out_trade_no":"2020050717260033632753","total_amount":"1000.00","trade_no":"2020050722001498330500900803","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 0),
(160, 2048, 0, '2020050717263177982430', 1, '1000.00', '支付宝网页支付', 1588843606, 1588843591, '商品描述', '2020050722001498330500901422', '{"gmt_create":"2020-05-07 17:26:36","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"QINYP2Yl07WKutAzxb1bqWN2h7OHi8gw8TMd\\/rUSKz31ahrK0gnk9C6O3oGYj4ONizwwz2roC0cwXOa\\/uKDIKsYxI9elFrCpbjCbhb+5KeyEdiUUvTSfRvM4Svv1JU0cwRXjBdFzGIRoQq0jByTfhRfcNyuYdVSDSMO4I8a9dGY+dlMGEB9lh0DEhhqfaPO8Ytb0mwwjcLU7Kcpz+HeMDYmRT1g6pMYjvSInVIxhkcOoewJcOifhpSqqBgj3bijRWve6yJcgWx87V+6WoIgxWFjnL5HBn07BbYXhD3S1KZuW15jfuBSORBXZe9jeKFsX\\/WqJEjpGQywzBkuwoLpgRA==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"1000.00","notify_id":"2020050700222172647098330504671715","fund_bill_list":"[{\\"amount\\":\\"1000.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"1000.00","buyer_pay_amount":"1000.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-07 17:26:46","notify_time":"2020-05-07 17:26:47","version":"1.0","out_trade_no":"2020050717263177982430","total_amount":"1000.00","trade_no":"2020050722001498330500901422","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 0),
(161, 2048, 0, '2020050717271178463682', 1, '2000.00', '支付宝网页支付', 1588843667, 1588843631, '商品描述', '2020050722001498330500901423', '{"gmt_create":"2020-05-07 17:27:37","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"AGNxOHT4vI6KHqIk8msdB+BdsGljyRlwyzabEXhPi4fL0LRm92hxCllP2j0CC9gKEh5bI5ii1MsX8mW7DBvEjzGFXI9kksz7y4abZuBjb3XLmTB7VHM7BFUdlQWiQxkTV7vHkc4o1XWBhkDg+HSapWkv09ePoIc9rswtvMBkTr7XS77fkip2uy1qjofLkyPHKnPFPIBMWea4IZu4MX6h9H0IcMEWPiiWyEE0yK8GqQfwyQ3lvrVE1qZYvjlhlZwEE2wXoy15QvD1da85aR7A9DMVjW\\/HEGn5tpObNOGPCH4io8wAMM2MB095UbENGIUQXGoNupSX6f7moq2+Ui6D\\/Q==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"2000.00","notify_id":"2020050700222172747098330504671716","fund_bill_list":"[{\\"amount\\":\\"2000.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"2000.00","buyer_pay_amount":"2000.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-07 17:27:47","notify_time":"2020-05-07 17:27:47","version":"1.0","out_trade_no":"2020050717271178463682","total_amount":"2000.00","trade_no":"2020050722001498330500901423","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 1),
(162, 2048, 0, '2020050717282488838940', 1, '2000.00', '支付宝网页支付', 1588843718, 1588843704, '商品描述', '2020050722001498330500901267', '{"gmt_create":"2020-05-07 17:28:29","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"U2+vqczbzcMFuCHSoluMiTHVIFF+JvjRu4ZZVAgfPL0SG91sxRmCfsKBxUQMOa9KOvtVU3GWJ73E\\/4PnfjdClAFEez538VflhRC64cCX0xMmPKp\\/4ZMv2n+erboAE\\/dq50WcVjXT9FN3eGON0Tu45IazJPZyauWpLHAAlyVjx5NJwEHyUdJjPeJuVwL46aso3J4ECYbP1+wGCXb4i2QCPgrXcWRL87KhfKX2ZqAdSJuJyVEwlHsksce88WKTbnm9Dqz\\/dWeshW6ZaUt4gAmPFug+Hv7zUn+JgufYmQCERE6\\/POXmUEeKqedTz+1bvWhKAgc5Xf+mhzFyvHSnKskcPw==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"2000.00","notify_id":"2020050700222172839098330504671718","fund_bill_list":"[{\\"amount\\":\\"2000.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"2000.00","buyer_pay_amount":"2000.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-07 17:28:38","notify_time":"2020-05-07 17:28:39","version":"1.0","out_trade_no":"2020050717282488838940","total_amount":"2000.00","trade_no":"2020050722001498330500901267","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 1),
(163, 2048, 0, '2020050717291512019868', 1, '500.00', '支付宝网页支付', 1588843765, 1588843755, '商品描述', '2020050722001498330500900956', '{"gmt_create":"2020-05-07 17:29:16","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"OSW9sKuhdkRVCmvwsy6\\/10trDfDuN9\\/S4eL7HxLT0J1XusHkOwwyJ0c1AYCsTgPV5JIsZRyhEmBRXtgN+KuLS8DD5QP8ZxEnsMTQqkSXpb2At+IivSplN1SkGPZSxrwVClAe8A1fuCfH1e3v5kfvCQFQ5iFd5ZYtEw\\/mZ80MU+XuvEbk0LCacKScnyG6u2vJWKEQnzTmvQpi1m4wxUBaItcHfxdSINZncjQREdOD4qs5h7NHg6UWCFuZJWOKDkc6JhLCw1eG2KEzAb+A1YC6nZsIMdKM9no8\\/4Cc9fjAQSCIUgwFiEeBRDnBQaO92duV7oxrPWxSxBOgHtsK9b+H6w==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"500.00","notify_id":"2020050700222172926098330504666288","fund_bill_list":"[{\\"amount\\":\\"500.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"500.00","buyer_pay_amount":"500.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-07 17:29:25","notify_time":"2020-05-07 17:29:26","version":"1.0","out_trade_no":"2020050717291512019868","total_amount":"500.00","trade_no":"2020050722001498330500900956","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 1),
(164, 2048, 0, '2020050811055173534934', 0, '200.00', '支付宝网页支付', NULL, 1588907151, '商品描述', NULL, NULL, 0),
(165, 2048, 0, '2020050814201777273614', 0, '200.00', '支付宝网页支付', NULL, 1588918817, '商品描述', NULL, NULL, 0),
(166, 2048, 0, '2020050814202684550724', 0, '500.00', '支付宝网页支付', NULL, 1588918826, '商品描述', NULL, NULL, 0),
(167, 2048, 0, '2020050814203956145358', 0, '200.00', '支付宝网页支付', NULL, 1588918839, '商品描述', NULL, NULL, 0),
(168, 2048, 0, '2020050814220531642093', 0, '200.00', '支付宝网页支付', NULL, 1588918925, '商品描述', NULL, NULL, 0),
(169, 2048, 0, '2020050814221254077539', 1, '10000.00', '支付宝网页支付', 1588918958, 1588918932, '商品描述', '2020050822001498330500902063', '{"gmt_create":"2020-05-08 14:22:26","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"jLSLDJHHWKV6j4U0G98vqQrrFSrwJQjGu3r3fX5XkCqZq5G\\/SRkn25Il2zq0HdugJEiAb6gfcC0sgX5A\\/Wzl8Vnl0k+x4d4u4FcWh1LPuS4cvuI7L4V1ffX3kE980r4ztB9u0SXxGMoUL45EthSs80pRjGlk60QJFDgW6mWppqg1pl3xdYoOT0m2KwYL3Kn3DT+jTIxcy63JpSgw9e3masaJp0ds7HL7zLU5SlmrfR07GX3t\\/N4fNqTvDOImFZP7NakhfVYucmhZKoMf\\/Z1nBXTr84eFe3BQ12N4FQyzKfxP0uxB8AQZY0PxIGeJhbC\\/dRWVc0zN0fF\\/0CICU9b8MA==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"10000.00","notify_id":"2020050800222142239098330504688874","fund_bill_list":"[{\\"amount\\":\\"10000.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"10000.00","buyer_pay_amount":"10000.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-08 14:22:38","notify_time":"2020-05-08 14:22:39","version":"1.0","out_trade_no":"2020050814221254077539","total_amount":"10000.00","trade_no":"2020050822001498330500902063","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 0),
(170, 2048, 0, '2020050814245759431096', 1, '10000.00', '支付宝网页支付', 1588919113, 1588919097, '商品描述', '2020050822001498330500902263', '{"gmt_create":"2020-05-08 14:25:03","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"OPJOpj8s+JtgleQwjXjdtWqmWRUM14brVKexith89APQMGs7lgDcF9t\\/z3cz9zbIHjDbI\\/N1TwKVzHrXv33DHxiaDXkwHJl5nIEt4wrB824+HsnOu5wQpn6pCX3YMPEHIIcZt3kdCDbsGm0WuPcJjSvnieNUsNBdgJ\\/t+HESCbiV9HG5LxdEYWaEV\\/5ffYf\\/4RVgZQ7kfz9Ew5erP5z20pa3ZdvH8J1JP8wf8eC7AwX3Mco4kutFbyscwQBwsW7f3CWFCkyyTwlkZ8T4+3jKVRxG0gMsbAGH4kAo1mwFZAB5nnu0zobkkn3kzmG64U0oFdgp688QGoUZ61j18sjX5A==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"10000.00","notify_id":"2020050800222142513098330504685163","fund_bill_list":"[{\\"amount\\":\\"10000.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"10000.00","buyer_pay_amount":"10000.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-08 14:25:13","notify_time":"2020-05-08 14:25:13","version":"1.0","out_trade_no":"2020050814245759431096","total_amount":"10000.00","trade_no":"2020050822001498330500902263","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 0),
(171, 4, 0, '2020050814282777373743', 0, '10000.00', '支付宝网页支付', NULL, 1588919307, '商品描述', NULL, NULL, 0),
(172, 4, 0, '2020050814283763667715', 0, '10000.00', '支付宝网页支付', NULL, 1588919317, '商品描述', NULL, NULL, 0),
(173, 4, 0, '2020050814285229430007', 1, '10000.00', '支付宝网页支付', 1588919353, 1588919332, '商品描述', '2020050822001498330500901686', '{"gmt_create":"2020-05-08 14:29:02","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"pAfJrAJ7Jg3jKQOKopVM9BNVfxTSdgWeUUK5YFzn\\/ykUjbZwlRzeZApyOsNdtuAgBrvy13ETNPdSIaEcO2kZNm45e6QjbrmAQVzpcmU96ze39N7VTZBsZMKBdsc01eK0VyeXLwkJ6Jx\\/RZ+WaqC0nMbjMjmJQAMcJHjcs00D3ZeKhIrZWbsu2vJA3wGw7ljY07WXvckoIW0yDHCiVHJquDgCl5d6aIlRnLsEsh0ao1EJaS97RGlJgWQQtdgxxTzsiRWbFqZTBin\\/pqAzppRaDe52zlxteAoHelmlmHAe0ajBShsoM28EnMDAPe9yy+RdCOCgI8sBE9m\\/kSTfD4uNSA==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"10000.00","notify_id":"2020050800222142914098330504686460","fund_bill_list":"[{\\"amount\\":\\"10000.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"10000.00","buyer_pay_amount":"10000.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-08 14:29:13","notify_time":"2020-05-08 14:29:14","version":"1.0","out_trade_no":"2020050814285229430007","total_amount":"10000.00","trade_no":"2020050822001498330500901686","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 1),
(174, 4, 0, '2020050814293765770388', 0, '10000.00', '支付宝网页支付', NULL, 1588919377, '商品描述', NULL, NULL, 0),
(175, 4, 0, '2020050918152946612691', 0, '200.00', '支付宝网页支付', NULL, 1589019329, '商品描述', NULL, NULL, 0),
(176, 4, 0, '2020050918153832502113', 0, '200.00', '支付宝网页支付', NULL, 1589019338, '商品描述', NULL, NULL, 0),
(177, 4, 0, '2020051116104963474679', 0, '50.00', '支付宝网页支付', NULL, 1589184649, '商品描述', NULL, NULL, 0),
(178, 4, 0, '2020051116114994908752', 0, '50.00', '支付宝网页支付', NULL, 1589184709, '商品描述', NULL, NULL, 0),
(179, 4, 0, '2020051116120273283436', 0, '200.00', '支付宝网页支付', NULL, 1589184722, '商品描述', NULL, NULL, 0),
(180, 4, 0, '2020051116121076747265', 0, '500.00', '支付宝网页支付', NULL, 1589184730, '商品描述', NULL, NULL, 0),
(181, 4, 0, '2020051201294061103496', 0, '200.00', '支付宝网页支付', NULL, 1589218180, '商品描述', NULL, NULL, 0),
(182, 4, 0, '2020051222255987667874', 1, '200.00', '支付宝网页支付', 1589293580, 1589293559, '商品描述', '2020051222001498330500905058', '{"gmt_create":"2020-05-12 22:26:05","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"qp47NIEoTmDXGvZapuz70ci02CZjdJAC5UEA4yLiOquwK257c0EumDcjhnNyysabGSFJBRk6Q3x5KgVsh0b5FDWkh7UIOI00Mtdi18pzDzRzPzOEaPO\\/XAKF1MBeAqjCogv9ZBmEtR98y+SvQ9YlW0okHJyRveSsRUJpwFIRrB5E3SkeErHPXTjroT1b+Di5plO6KBXigqPSp+2BHR1q21D1MIkwkC5EbHZU\\/Rq5BYKwr2V+cDYaTn1c3J+SA7vAm8X29e9snGeTZi63F\\/+qceKkiMajCMIGBtS\\/y3TxLzYCRUANlus213FVNa8etXyo+EVxnbvDaUr0tJh3VtbQog==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"200.00","notify_id":"2020051200222222620098330504755118","fund_bill_list":"[{\\"amount\\":\\"200.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"200.00","buyer_pay_amount":"200.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-12 22:26:20","notify_time":"2020-05-12 22:26:20","version":"1.0","out_trade_no":"2020051222255987667874","total_amount":"200.00","trade_no":"2020051222001498330500905058","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 1),
(183, 4, 0, '2020051222272837138857', 1, '200.00', '支付宝网页支付', 1589293663, 1589293648, '商品描述', '2020051222001498330500905060', '{"gmt_create":"2020-05-12 22:27:31","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"O3d056t2M2CfDF9KgbPKGZQB934ljemMXZ8bLatYGaQiLsLg+BF8otJxJDju7VCcbdhiTEjyUjmEKKv2quM5c26VTjlSl5hHz326ZralIzq4NLZEIIJpq9ceZ9HzqDq3GqffYVjeIhbjhUty1ZSwG1xJat2pYS3VQtmoQr\\/d1RFUi5v\\/9OXQFE64njVEOz8XIejazywl4pn6xh0E3QbuzomIjUYhBL6EeI9QcY1CQe+TmyPTbLlmWT1anlmlAYr+8FBJDhQYwUJuZhl8SGE7yhtK478Rkar+EWd\\/phepo6WmZhJDfBhLdZ2iTT+rX9j\\/yRO2UytQpktgVDiNHG30cQ==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"200.00","notify_id":"2020051200222222744098330504756597","fund_bill_list":"[{\\"amount\\":\\"200.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"200.00","buyer_pay_amount":"200.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-12 22:27:43","notify_time":"2020-05-12 22:27:44","version":"1.0","out_trade_no":"2020051222272837138857","total_amount":"200.00","trade_no":"2020051222001498330500905060","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 1),
(184, 4, 0, '2020051222292533517047', 1, '200.00', '支付宝网页支付', 1589293779, 1589293765, '商品描述', '2020051222001498330500905062', '{"gmt_create":"2020-05-12 22:29:28","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"bM1+xANjDvffn1ajnrdSdj113xTlzcBTp1KlmNJ3NNyuqQmUADDvJPyHofJsXGG1qu4eXJFpW5Rix+ry01ezqB\\/42QNtzvQsfNratJbIzplDtyw+28CHGevBrgvk+JQayTgY2BOj41fApIF+hYuDM8nFNIGv4L7KmBxomywqhvUwdJK9HBfUMAVtDhsN+1TKpgQruiufzS0v71D7BhJD\\/9vPG5AXdTrY8Ilb5p\\/sSMA2K5m1YHhySYh31Nz\\/tNHkcASa+wRvrbjH75\\/qHa4Ee4IRm8ncZP\\/BBYZPTqDe1Kof\\/F+EaipSgpQKvyJt6sRfKR04iTgNm4ensQvEOQKxtA==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"200.00","notify_id":"2020051200222222939098330504754026","fund_bill_list":"[{\\"amount\\":\\"200.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"200.00","buyer_pay_amount":"200.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-12 22:29:39","notify_time":"2020-05-12 22:29:39","version":"1.0","out_trade_no":"2020051222292533517047","total_amount":"200.00","trade_no":"2020051222001498330500905062","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 1),
(185, 4, 0, '2020051222310367127301', 1, '200.00', '支付宝网页支付', 1589293887, 1589293863, '商品描述', '2020051222001498330500904763', '{"gmt_create":"2020-05-12 22:31:09","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"ie7oxBxIq+lLqypw6R+N5SDOd1x84UuKwZQ\\/wjaJBF+DEAuCaEvCKExbcr6yT\\/HbE+FIL6Ty\\/4QS9EDeUMRo+L\\/Yn83vG5xDkiQZsmcqKLF7eOVhu47h6lfZVVj3GdsgoiQ+v6mh7Qfat9zwAumXXvdT+vqYvwxbDAm8iF6E6npsXgewgRmmYJJUKpCMxIXYjX7mJ661XIvy9yFqj+FC8GcxEfbTDCu0+TKmd1LfO8Pu1MvAyyydnbrPtxSwpOjlLW3hnYGTWvJrQkahhsOV1IJuKJiYirH0X9WVpn1eMSTd5GULWo6z\\/vfMshsKWAnVue8zyQSxURpKIB9cRfrqyg==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"200.00","notify_id":"2020051200222223127098330504756598","fund_bill_list":"[{\\"amount\\":\\"200.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"200.00","buyer_pay_amount":"200.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-12 22:31:27","notify_time":"2020-05-12 22:31:27","version":"1.0","out_trade_no":"2020051222310367127301","total_amount":"200.00","trade_no":"2020051222001498330500904763","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 1),
(186, 4, 0, '2020051223022725751596', 1, '200.00', '支付宝网页支付', 1589295763, 1589295747, '商品描述', '2020051222001498330500904453', '{"gmt_create":"2020-05-12 23:02:29","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"CAvSPaL4b9LXUGCb7yKQ6Lte\\/APLsAu+LNZXhhuXwPg\\/4Jr+VnWNmxs8cNsUxwXeDhFGYb2ey69gcbYtkRxNpsj9WgV\\/60YPHt1Z5vzMJ2\\/qNrVa4SkwdqLgLU6ysZ8kFj5brDx5x1QJPPzIKJL9Z+i4kLd2I2tecuo4pxaElJfn83FZwH6Df6fMX1IkoWvcKtiFEln1BBgPm9j6rgk1WyqDCQcyvP\\/84Dz3d4Y7N+BBZTfSZHWeYTD12W2CMACyMUE7qp25tVs+HMHZ5L9qvU24W6x4CK3T+NkMRYzlamAlXpsOrCCpjtJYffPeGU3hcG2KWKiCg7esGpDgCOFCbg==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"200.00","notify_id":"2020051200222230243098330504754027","fund_bill_list":"[{\\"amount\\":\\"200.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"200.00","buyer_pay_amount":"200.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-12 23:02:43","notify_time":"2020-05-12 23:02:44","version":"1.0","out_trade_no":"2020051223022725751596","total_amount":"200.00","trade_no":"2020051222001498330500904453","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 0),
(187, 4, 0, '2020051223041542344757', 1, '200.00', '支付宝网页支付', 1589295868, 1589295855, '商品描述', '2020051222001498330500904628', '{"gmt_create":"2020-05-12 23:04:18","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"IedojYQxXUbP86zTjjWokvMknYEAPj3OiTrvuvrTDc46+rig9TJpY5VrVgsQgX1gCF1m5xItL\\/eWyKqTQB1ikw1+tzDpelQDka0q3pdFe1IbA+oRgBIlHtshv85KE\\/RwkZ11ds9LrLe\\/pc3hVs7DyJAvxH6jEaTdOE32iTUuzQv9CYSgmcdy0a8T19b6c7DNWSSNN97CttaXm3Jnoo6AeR048n\\/\\/80wgiUkN3ZXNSWuYPpPDbXQq81X2KpqpRpwScs4rHhY7eCbgGm0P2WBALFP\\/6afALtYiTVE17lH+sYXP989MR0hkxCf9ImsPJgWHnzv+mdST90ecDtKML2fRhw==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"200.00","notify_id":"2020051200222230428098330504752117","fund_bill_list":"[{\\"amount\\":\\"200.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"200.00","buyer_pay_amount":"200.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-12 23:04:28","notify_time":"2020-05-12 23:04:28","version":"1.0","out_trade_no":"2020051223041542344757","total_amount":"200.00","trade_no":"2020051222001498330500904628","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 0),
(188, 4, 0, '2020051223222775147403', 1, '200.00', '支付宝网页支付', 1589296968, 1589296947, '商品描述', '2020051222001498330500905063', '{"gmt_create":"2020-05-12 23:22:32","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"Tg9KcggrsULChwK07lA07CEhkU5NSzu+jZkS51nUNevW5fpcMvMRgs0rbp\\/RNS36W62RauHjj+XUvo7KL7YIFDd+A+GKW+pT\\/H+BeyUeWpPv5x8dO+H9j6c0fkKlbjE4Ndj+2857U4DEhnoSQOixDLx7lZ39q47cPQ8XqYUahFGWXHk6InrMA\\/yi9TVQKG6x4etWv+9TAbAf5\\/inAzy4Es42Pki7ashjX1wpkLqvLSPQWKppflbephjRc0lA4KhjKSmACeebTPJZEX314Tjjd9p91xCSelYxbLfW3Mhr\\/RqJwzFhyfj9qNljObdUYlQnCwjGVda1a4CdPHcm9h\\/b+Q==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"200.00","notify_id":"2020051200222232249098330504754029","fund_bill_list":"[{\\"amount\\":\\"200.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"200.00","buyer_pay_amount":"200.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-12 23:22:48","notify_time":"2020-05-12 23:22:49","version":"1.0","out_trade_no":"2020051223222775147403","total_amount":"200.00","trade_no":"2020051222001498330500905063","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 0),
(189, 4, 0, '2020051223250699020446', 1, '200.00', '支付宝网页支付', 1589297120, 1589297106, '商品描述', '2020051222001498330500904454', '{"gmt_create":"2020-05-12 23:25:10","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"fR5UWcfIPxx56vEPSxYIx0nbaq1ELk5mIrLEcaq77mhD6Cfozncx\\/WuUSG1dfR3tpp09MRQu\\/FVniJrEyAGTGIrnxEdGVtNDdKjHUzhUzDM6uGACe43nD4LMFFEoCXtl5\\/F2Bry+NDkl1qJmsYbeImBp+Je\\/90\\/Pnk\\/rLxV32LzH7XMV\\/WeqyWPChLmRrLwLta7juTxiNeLOnHIWralCgEBRLLqbbAwIs1X+KpkVSF\\/ACm35UfUKFGW2MAQYU5eGivcV\\/6Cv1wU9YU2tRtl8qVuDC9BbxdB0CaXemZJumdP4LX4s6OKyudT\\/w0C2VUx8tf8lmdj1wxtu41OwGcOwZg==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"200.00","notify_id":"2020051200222232521098330504752118","fund_bill_list":"[{\\"amount\\":\\"200.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"200.00","buyer_pay_amount":"200.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-12 23:25:20","notify_time":"2020-05-12 23:25:21","version":"1.0","out_trade_no":"2020051223250699020446","total_amount":"200.00","trade_no":"2020051222001498330500904454","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 1),
(190, 4, 0, '2020051223274794677592', 0, '200.00', '支付宝网页支付', NULL, 1589297267, '商品描述', NULL, NULL, 0),
(191, 4, 0, '2020051223275548969050', 1, '200.00', '支付宝网页支付', 1589297291, 1589297275, '商品描述', '2020051222001498330500904630', '{"gmt_create":"2020-05-12 23:28:00","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"C3jGYreqCVs69wr1JCEKOuuLXXj2EASFvZWbHvDHsXVrCxKBoAU77ovgpLkLunX6P1HEOFgHMZe8N9IN2i4wgc\\/xMFSCt6TeDJYqe82jZ+neHLMh\\/ipziSwqJWVbqGAasSnoTATZwGyCbl+Q3FAr3nIHwzA7OlE6gnrJjt2BeqSqtUis4LmWOoyq3qfF\\/8GzxISlGpC1Ux1iyH2QxXxG5UoPxPFOqI0m1\\/\\/Ebhw7XOMaJF3kHBdMZDAretxqTj4TjpulUL05i8bybkCUt6nFvbsCiphhCCjfz6kPSZBca58xZBwzV84kKtiBvDz7u7\\/CwgPpi031fGCjJZTkqIxPog==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"200.00","notify_id":"2020051200222232812098330504752120","fund_bill_list":"[{\\"amount\\":\\"200.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"200.00","buyer_pay_amount":"200.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-12 23:28:11","notify_time":"2020-05-12 23:28:12","version":"1.0","out_trade_no":"2020051223275548969050","total_amount":"200.00","trade_no":"2020051222001498330500904630","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 1),
(192, 4, 0, '2020051223321092926744', 1, '200.00', '支付宝网页支付', 1589297542, 1589297530, '商品描述', '2020051222001498330500904456', '{"gmt_create":"2020-05-12 23:32:12","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"Ww2Np67le2naB9wghMDVAb+gRUc00mrqQ8eyRAEf++fuRZACat6YMJYAYxOV94YsqkynQvj9UIfFhjo6J7IuzlucmmZ2idtayA5gvBU8qvVPDxly8XXiwLhp\\/x7eMEPI7+pQe0fgFZb6V6\\/gfkclPPl9Sls+dU1K6bbmx9lvoTx893XVne8SAkWp6AKClspLBndvmzo9ddFDI7tSOkITseigteP0l1aXHvGX49d4FVzx7OP920QAw3f7mmMIT6m5ck0a4N3xE+Vg7\\/bMsa2SkSjA14SRnSR7cmzolfNC0M71UA7x9qvsZh0qXhvkuxOovhQr7qql\\/36AWFHYLBp5Qg==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"200.00","notify_id":"2020051200222233222098330504755122","fund_bill_list":"[{\\"amount\\":\\"200.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"200.00","buyer_pay_amount":"200.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-12 23:32:22","notify_time":"2020-05-12 23:32:22","version":"1.0","out_trade_no":"2020051223321092926744","total_amount":"200.00","trade_no":"2020051222001498330500904456","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 1),
(193, 4, 0, '2020051223371565890350', 1, '200.00', '支付宝网页支付', 1589297849, 1589297835, '商品描述', '2020051222001498330500904457', '{"gmt_create":"2020-05-12 23:37:18","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"GqMtDpOirFgnNrtzpPIX36w9SOmx6t7s+lv7BQlddWTxVV6fwaVibDQvMZOWaYe5Inyf8igPpRLW2bjPEMtsM1mXm3h0sMGuQqgqMuUtgjbDpMowymy09L27D6mjwWHd1mGs1fxNEpRj0TZkkRJHKrFErHigRLHt\\/gRp0VJauULqVm1lCJgqtPZBz7fo+GI\\/3sfdiDji79dMDU2Zj0AovvC5Z7pLgUj+SIRomgH7fzMrW8MFgkBGO323V3380RVGSgxWqfetJ6HxIxSro4wq8DMrfqQDIBSG6r2wstqgDJKvTdm2E1RTfNHf0Mm6NrsEpSucMJg0Wf\\/ohee2wuW4Ig==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"200.00","notify_id":"2020051200222233729098330504754031","fund_bill_list":"[{\\"amount\\":\\"200.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"200.00","buyer_pay_amount":"200.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-12 23:37:29","notify_time":"2020-05-12 23:37:30","version":"1.0","out_trade_no":"2020051223371565890350","total_amount":"200.00","trade_no":"2020051222001498330500904457","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 1),
(194, 4, 0, '2020051300202471851149', 0, '200.00', '支付宝网页支付', NULL, 1589300424, '商品描述', NULL, NULL, 0),
(195, 4, 0, '2020051300204685937069', 1, '499.00', '支付宝网页支付', 1589300464, 1589300446, '商品描述', '2020051322001498330500904632', '{"gmt_create":"2020-05-13 00:20:51","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"lFCkoIpGzbClaZEVtJGLBZHWZ7JcOQAFr\\/iVA+EiqVga6NhAUIlfZIRC7RLkrV7V\\/N5sxcu8nK7n4s9+ttxR+WMU7HOFC0edAnQnT8fSKzCCcsRwlDJJYKic1K2gh5HHYkNx239aMQUErllcXKwP8NulV+zrU3OE0Ocg8VeVdLxqd\\/lVEF3t3oGJu4tjHyhOeh7vj8SUbQsVaKtJwp2YD0JziFR4X2XeofOTopFhdDvZZK9cjkpmcTwuNcyv7aAViFWPqJZ4\\/TA8ihXO43Ru7+UlGjHGhIXd6QqWZCkkibsDYUCfrXe82IZWU1cQYd5jBcbnBSGvsc5Mh\\/svySszMQ==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"499.00","notify_id":"2020051300222002105098330504752121","fund_bill_list":"[{\\"amount\\":\\"499.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"499.00","buyer_pay_amount":"499.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-13 00:21:04","notify_time":"2020-05-13 00:21:05","version":"1.0","out_trade_no":"2020051300204685937069","total_amount":"499.00","trade_no":"2020051322001498330500904632","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 1),
(196, 4, 0, '2020051300265959403260', 0, '200.00', '支付宝网页支付', NULL, 1589300819, '商品描述', NULL, NULL, 0),
(197, 4, 0, '2020051311503335887107', 1, '10000.00', '支付宝网页支付', 1589341850, 1589341833, '商品描述', '2020051322001498330500905069', '{"gmt_create":"2020-05-13 11:50:37","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"B1AGs6JQjDxLkot78XBSzaXF6RthJijGo\\/mmgfXLntewXs+tqUEj2K7zOaWzl4nkfRgDTeYkGZ8GzpZvr3r5jKg3YpEvnn6lzLSHtMHPk6HR\\/jaN2dZIBYBnPmFmz9+AZyTDj6bod3EvTdhBVDrxBYDZmP6zPmr5f\\/XTzlJCYKUKB0\\/IPwMcInKPgC+\\/qryKYHingaf1Xq3yvaKeWgUTjB4gY\\/8uw40eYEjElOBtvh4Nz8Drj\\/3toY\\/tofA0BHqIVuuxJxvtLVoCJfSpP\\/5pLrewfCfbU1uxqEtYN1e8vLOyOWyS60YeZXnoy0CyMfP8RQVoIslqCuxQ02OgPLSg\\/Q==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"10000.00","notify_id":"2020051300222115051098330504768000","fund_bill_list":"[{\\"amount\\":\\"10000.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"10000.00","buyer_pay_amount":"10000.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-13 11:50:50","notify_time":"2020-05-13 11:50:51","version":"1.0","out_trade_no":"2020051311503335887107","total_amount":"10000.00","trade_no":"2020051322001498330500905069","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 1),
(198, 3, 0, '2020051315401810921999', 1, '10000.00', '支付宝网页支付', 1589355647, 1589355618, '商品描述', '2020051322001498330500904637', '{"gmt_create":"2020-05-13 15:40:35","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"B5sUgLoSZ5GaFqVgRgluRgRAA1L+TMNv\\/OfgF3mM2LOiqhgakvaN\\/cCnqAD2FSRTD0tLQ\\/pSwhYHjP71nsJ9WKoHj3Xz07hDDXbI9TlCaPuDVHUvnnx9CAGcmROy0plJFfNNXLWqFQCw3fQAQoRazGvN6zxijYvGf91FZQ5mGdliULwWX8R2rtHANbsqbo8W22i4JqG+QRplhLcpQqU1FJTV6Y0aLmMwy46DSJy0IKVmNLRkCUwAL+h0cUa0DCzfDL0hC1\\/pe2gYOEExYXEzvdmxrfbEQGNgSy5uDEMEeGsxFpM\\/nH0CH91fdze\\/c98qn7xzm9AKNx0Jd6lzXpbWZA==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"10000.00","notify_id":"2020051300222154048098330504774268","fund_bill_list":"[{\\"amount\\":\\"10000.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"10000.00","buyer_pay_amount":"10000.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-13 15:40:47","notify_time":"2020-05-13 15:40:48","version":"1.0","out_trade_no":"2020051315401810921999","total_amount":"10000.00","trade_no":"2020051322001498330500904637","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 1),
(199, 4, 0, '2020051411073114432926', 0, '2000.00', '支付宝网页支付', NULL, 1589425651, '商品描述', NULL, NULL, 0),
(200, 4, 0, '2020051412521187599712', 0, '200.00', '支付宝网页支付', NULL, 1589431931, '商品描述', NULL, NULL, 0),
(201, 4, 0, '2020051412521388299914', 0, '200.00', '支付宝网页支付', NULL, 1589431933, '商品描述', NULL, NULL, 0),
(202, 4, 0, '2020051412522385144713', 0, '200.00', '支付宝网页支付', NULL, 1589431943, '商品描述', NULL, NULL, 0),
(203, 4, 0, '2020051412535740120700', 0, '200.00', '支付宝网页支付', NULL, 1589432037, '商品描述', NULL, NULL, 0),
(204, 4, 0, '2020051412543295817632', 0, '200.00', '支付宝网页支付', NULL, 1589432072, '商品描述', NULL, NULL, 0),
(205, 4, 0, '2020051412543835328093', 0, '200.00', '支付宝网页支付', NULL, 1589432078, '商品描述', NULL, NULL, 0),
(206, 4, 0, '2020051412544559538112', 0, '200.00', '支付宝网页支付', NULL, 1589432085, '商品描述', NULL, NULL, 0),
(207, 4, 0, '2020051412545979140197', 0, '200.00', '支付宝网页支付', NULL, 1589432099, '商品描述', NULL, NULL, 0),
(208, 4, 0, '2020051412554117254565', 0, '200.00', '支付宝网页支付', NULL, 1589432141, '商品描述', NULL, NULL, 0),
(209, 4, 0, '2020051412554781262373', 0, '200.00', '支付宝网页支付', NULL, 1589432147, '商品描述', NULL, NULL, 0),
(210, 4, 0, '2020051412565084459068', 0, '200.00', '支付宝网页支付', NULL, 1589432210, '商品描述', NULL, NULL, 0),
(211, 4, 0, '2020051412594855804695', 0, '200.00', '支付宝网页支付', NULL, 1589432388, '商品描述', NULL, NULL, 0),
(212, 4, 0, '2020051413104274096675', 0, '200.00', '支付宝网页支付', NULL, 1589433042, '商品描述', NULL, NULL, 0),
(213, 4, 0, '2020051413140941728134', 0, '200.00', '支付宝网页支付', NULL, 1589433249, '商品描述', NULL, NULL, 0),
(214, 4, 0, '2020051413145151451698', 0, '200.00', '支付宝网页支付', NULL, 1589433291, '商品描述', NULL, NULL, 0),
(215, 4, 0, '2020051413155991018147', 0, '200.00', '支付宝网页支付', NULL, 1589433359, '商品描述', NULL, NULL, 0),
(216, 4, 0, '2020051413163269721936', 0, '200.00', '支付宝网页支付', NULL, 1589433392, '商品描述', NULL, NULL, 0),
(217, 4, 0, '2020051413261533621199', 1, '100000.00', '支付宝网页支付', 1589434014, 1589433975, '商品描述', '2020051422001498330500905479', '{"gmt_create":"2020-05-14 13:26:40","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"rcSwbfhivz2hYme4WSgjeCDQGO3+kEjAGsRuKH1H\\/U9FYfYXtLyyJs1X4D6JDdHB9QWMmybVQXpj6vQTJbbeLU1sy0rq7uGKr7FPvwRxT7UKbwz9nA3eGIux9G+RSEaZgDUgF5gczy9sD3Pd+y4dsoCb3gv0VmTX3sBGJY5izX9ureW8qocWg5qRWUPkdSmiafakNNiOsGUjBYDms+5dTlus3oQN5TZYcg3GiFC20KPVCh4Vc4KY9DlZe2PyWV4yt0+E8t0LPWjtVh8p8v\\/YsiH\\/CEBQaH5kXwtwSPr5VNW+isxgRF21f9zIWko5Vo+IfdS18gtd6UO2IzY4IBLRfA==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"100000.00","notify_id":"2020051400222132655098330504788550","fund_bill_list":"[{\\"amount\\":\\"100000.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"100000.00","buyer_pay_amount":"100000.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-14 13:26:54","notify_time":"2020-05-14 13:26:55","version":"1.0","out_trade_no":"2020051413261533621199","total_amount":"100000.00","trade_no":"2020051422001498330500905479","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 1),
(218, 4, 0, '2020051413280823895476', 1, '1000.00', '支付宝网页支付', 1589434108, 1589434088, '商品描述', '2020051422001498330500905480', '{"gmt_create":"2020-05-14 13:28:18","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"LyWK0wFpxxogYolCrQdM24hCWe6ttzzoW57BS0kK7BkLcU4n9RPuhqKEgozXKHnps0hjAQXKUf59YvmgECEQWX0V8n2g54Swi58y+ydzvFo1ksBjdRSRqijOS+cBtQiQJWF+oO4Vc0YOhL1GZ3nsKnhTv1WM8aqnvJQC7OIsWWrAqoY\\/4UQVK+unjalUG\\/h7KiNHNdY3VFj51BDd88U6FPdlFf6KaXtGM9eFjCESjgurtTENJUy8kuVaI3FO5w5qOHYjcFwcjUklaXViy9ydDmOYyKRGtyTQgpTr2b3hd+M2l8nwMZA1fLqLSF9B9AWt1BgD6keQeyTbKZfPYPCUSQ==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"1000.00","notify_id":"2020051400222132829098330504790341","fund_bill_list":"[{\\"amount\\":\\"1000.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"1000.00","buyer_pay_amount":"1000.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-14 13:28:28","notify_time":"2020-05-14 13:28:29","version":"1.0","out_trade_no":"2020051413280823895476","total_amount":"1000.00","trade_no":"2020051422001498330500905480","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 1),
(219, 3, 0, '2020051416173377434212', 1, '10000.00', '支付宝网页支付', 1589444275, 1589444253, '商品描述', '2020051422001498330500906001', '{"gmt_create":"2020-05-14 16:17:37","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"KSXmrTQD91FcTBnpnd7gbl9orU+yIlL5RpBKw3OBVM5Y0GCDL8Y6KdYAGxV8YMSp8wftfqiDcQUMjMVvAsl5a3S1RWQ0RwFuyiIkX9Kvd\\/J7W2NTb2ZBt3qILaA8zIwxytCxtntFMxc0EQcm4efWVdA7cLQqaEHaecBYxs9Dl\\/NJEuRqWEjvw3gkPO\\/0\\/bOxeEAbPuFBr8jw0snqRJcGG+8+KJ5YS5k5+xniyBVJTkYb2dCjESeLIQsU5KcCFIfEERWjZqpvplQREO5VPca71bTj3P4+w8mDbk394ph\\/f0dX51pc7F5YVa7oNMLGkDLM8fg+9Gy+PSdVBe3dUncuXw==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"10000.00","notify_id":"2020051400222161755098330504786987","fund_bill_list":"[{\\"amount\\":\\"10000.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"10000.00","buyer_pay_amount":"10000.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-14 16:17:55","notify_time":"2020-05-14 16:17:55","version":"1.0","out_trade_no":"2020051416173377434212","total_amount":"10000.00","trade_no":"2020051422001498330500906001","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 1),
(220, 3, 0, '2020051416184131022555', 0, '10000.00', '支付宝网页支付', NULL, 1589444321, '商品描述', NULL, NULL, 0),
(221, 3, 0, '2020051416185174213059', 0, '10000.00', '支付宝网页支付', NULL, 1589444331, '商品描述', NULL, NULL, 0),
(222, 3, 0, '2020051416190369243283', 0, '10000.00', '支付宝网页支付', NULL, 1589444343, '商品描述', NULL, NULL, 0),
(223, 3, 0, '2020051416191757692949', 0, '10000.00', '支付宝网页支付', NULL, 1589444357, '商品描述', NULL, NULL, 0),
(224, 3, 0, '2020051416193364142364', 0, '10000.00', '支付宝网页支付', NULL, 1589444373, '商品描述', NULL, NULL, 0),
(225, 3, 0, '2020051416200268947682', 0, '10000.00', '支付宝网页支付', NULL, 1589444402, '商品描述', NULL, NULL, 0),
(226, 3, 0, '2020051416201118945601', 0, '10000.00', '支付宝网页支付', NULL, 1589444411, '商品描述', NULL, NULL, 0),
(227, 3, 0, '2020051416202235510005', 0, '10000.00', '支付宝网页支付', NULL, 1589444422, '商品描述', NULL, NULL, 0),
(228, 3, 0, '2020051416210293358424', 0, '200.00', '支付宝网页支付', NULL, 1589444462, '商品描述', NULL, NULL, 0),
(229, 3, 0, '2020051416210751181932', 0, '200.00', '支付宝网页支付', NULL, 1589444467, '商品描述', NULL, NULL, 0),
(230, 3, 0, '2020051416265864132879', 1, '200.00', '支付宝网页支付', 1589444841, 1589444818, '商品描述', '2020051422001498330500905372', '{"gmt_create":"2020-05-14 16:27:09","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"TSHZrL0uTy97Rodqd+spCD1PLumkvikTzzv6vOpZfSdSfq0o2pYEg8v0YfKByxepspK765bDnMzAxO\\/z0XGExGJRjO5hJTAQU3FKBmv98L3EO9S7fRcOpquTlSvODeX9MoEfVHMX3SDC9QDqy2VFRDPYLVM+IhMvKfCgAv55HD9\\/H9QOGzhD4O2daMIZYEHlCVcdrWmOQTQuv0A0X9rSozvjpw7dQpGk6PzaSWh3DPiQyD9IymKDiaglYF\\/oX6MzXxDJhDdssqi1hs3rGBL8DRiaP0xwkiG9PrzD7WqI7+c8td+W0crm1tS5YKOA4HmgIEt+m55KxI4svdgjxzMTbQ==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"200.00","notify_id":"2020051400222162721098330504790352","fund_bill_list":"[{\\"amount\\":\\"200.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"200.00","buyer_pay_amount":"200.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-14 16:27:21","notify_time":"2020-05-14 16:27:21","version":"1.0","out_trade_no":"2020051416265864132879","total_amount":"200.00","trade_no":"2020051422001498330500905372","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 1),
(231, 3, 0, '2020051416290335512078', 1, '3000.00', '支付宝网页支付', 1589444957, 1589444943, '商品描述', '2020051422001498330500905851', '{"gmt_create":"2020-05-14 16:29:07","charset":"UTF-8","seller_email":"laxieg6002@sandbox.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"O9eYq7OeDA8GzOh7kGBb0c3iEffYjIwCJS7uXCt1qotI10t9tQ8i\\/HnoJWtZiSuz+9cNcc2eYRZ\\/Qq\\/lOvzPURj2UR4WfuceRIFMcInUmr6Cb8m\\/Dg8jiMVNVAv7YDEkjn0nbDWYRnyhVlHPc\\/wweoubStDhHzDvobGLEkJcpmxab6f4xyBMecBiDU1GCe0DYCL+TxYMGt3hG5a2EDGnAYrJ1Dl0T8xfI9jfzdn2lr6RXjfaRY8b6ks6cCKonVAUV2B32EvdH2mcL7giREHenf6KyxviEq0pVGreAhYxyoxi+pFZ0dIsVmcY3n7hjiSeyqRFS7QLFTGInR5s\\/GX+9w==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088102179898337","invoice_amount":"3000.00","notify_id":"2020051400222162917098330504776002","fund_bill_list":"[{\\"amount\\":\\"3000.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"3000.00","buyer_pay_amount":"3000.00","app_id":"2016101200665852","sign_type":"RSA2","seller_id":"2088102179178660","gmt_payment":"2020-05-14 16:29:17","notify_time":"2020-05-14 16:29:17","version":"1.0","out_trade_no":"2020051416290335512078","total_amount":"3000.00","trade_no":"2020051422001498330500905851","auth_app_id":"2016101200665852","buyer_logon_id":"fuw***@sandbox.com","point_amount":"0.00"}', 1),
(232, 4, 0, '2020051420485036040235', 0, '200.00', '支付宝网页支付', NULL, 1589460530, '商品描述', NULL, NULL, 0),
(233, 4, 0, '2020051420485527778065', 0, '200.00', '支付宝网页支付', NULL, 1589460535, '商品描述', NULL, NULL, 0),
(234, 4, 0, '2020051420492596543495', 0, '200.00', '支付宝网页支付', NULL, 1589460565, '商品描述', NULL, NULL, 0),
(235, 4, 0, '2020051420503387782438', 0, '200.00', '支付宝网页支付', NULL, 1589460633, '商品描述', NULL, NULL, 0),
(236, 4, 0, '2020051420503324452387', 0, '200.00', '支付宝网页支付', NULL, 1589460633, '商品描述', NULL, NULL, 0),
(237, 4, 0, '2020051420503430459208', 0, '200.00', '支付宝网页支付', NULL, 1589460634, '商品描述', NULL, NULL, 0),
(238, 4, 0, '2020051420503436498624', 0, '200.00', '支付宝网页支付', NULL, 1589460634, '商品描述', NULL, NULL, 0),
(239, 4, 0, '2020051420503451740462', 0, '200.00', '支付宝网页支付', NULL, 1589460634, '商品描述', NULL, NULL, 0),
(240, 4, 0, '2020051420503467196927', 0, '200.00', '支付宝网页支付', NULL, 1589460634, '商品描述', NULL, NULL, 0),
(241, 4, 0, '2020051420503455703497', 0, '200.00', '支付宝网页支付', NULL, 1589460634, '商品描述', NULL, NULL, 0),
(242, 4, 0, '2020051420503580877635', 0, '200.00', '支付宝网页支付', NULL, 1589460635, '商品描述', NULL, NULL, 0),
(243, 4, 0, '2020051513395071319797', 0, '200.00', '支付宝网页支付', NULL, 1589521190, '商品描述', NULL, NULL, 0),
(244, 4, 0, '2020051513494275215933', 0, '200.00', '支付宝网页支付', NULL, 1589521782, '商品描述', NULL, NULL, 0),
(245, 4, 0, '2020051513504838716951', 0, '100.00', '支付宝网页支付', NULL, 1589521848, '商品描述', NULL, NULL, 0),
(246, 4, 0, '2020051513521068712229', 0, '100.00', '支付宝网页支付', NULL, 1589521930, '商品描述', NULL, NULL, 0),
(247, 4, 0, '2020051513533633550799', 0, '100.00', '支付宝网页支付', NULL, 1589522016, '商品描述', NULL, NULL, 0),
(248, 4, 0, '2020051513580876799899', 0, '100.00', '支付宝网页支付', NULL, 1589522288, '商品描述', NULL, NULL, 0),
(249, 4, 0, '2020051514012691308365', 0, '100.00', '支付宝网页支付', NULL, 1589522486, '商品描述', NULL, NULL, 0);
INSERT INTO `w_recharge_order` (`id`, `member_id`, `pay_type`, `order_sn`, `pay_state`, `amount`, `pay_source`, `completion_time`, `add_time`, `describe`, `pay_trans`, `return_info`, `is_recharge`) VALUES
(250, 4, 0, '2020051514041857422884', 0, '100.00', '支付宝网页支付', NULL, 1589522658, '商品描述', NULL, NULL, 0),
(251, 4, 0, '2020051514045737309621', 0, '100.00', '支付宝网页支付', NULL, 1589522697, '商品描述', NULL, NULL, 0),
(252, 4, 0, '2020051514061132265624', 0, '100.00', '支付宝网页支付', NULL, 1589522771, '商品描述', NULL, NULL, 0),
(253, 4, 0, '2020051514072052917904', 0, '100.00', '支付宝网页支付', NULL, 1589522840, '商品描述', NULL, NULL, 0),
(254, 4, 0, '2020051514083146937771', 0, '100.00', '支付宝网页支付', NULL, 1589522911, '商品描述', NULL, NULL, 0),
(255, 4, 0, '2020051514083543702915', 0, '100.00', '支付宝网页支付', NULL, 1589522915, '商品描述', NULL, NULL, 0),
(256, 4, 0, '2020051514103414359136', 0, '100.00', '支付宝网页支付', NULL, 1589523034, '商品描述', NULL, NULL, 0),
(257, 4, 0, '2020051514103891656805', 0, '100.00', '支付宝网页支付', NULL, 1589523038, '商品描述', NULL, NULL, 0),
(258, 4, 0, '2020051514111788694754', 0, '100.00', '支付宝网页支付', NULL, 1589523077, '商品描述', NULL, NULL, 0),
(259, 4, 0, '2020051514124853794365', 0, '100.00', '支付宝网页支付', NULL, 1589523168, '商品描述', NULL, NULL, 0),
(260, 4, 0, '2020051514130376499372', 0, '200.00', '支付宝网页支付', NULL, 1589523183, '商品描述', NULL, NULL, 0),
(261, 4, 0, '2020051514130798040626', 0, '1.00', '支付宝网页支付', NULL, 1589523187, '商品描述', NULL, NULL, 0),
(262, 4, 0, '2020051514134281844180', 0, '1.00', '支付宝网页支付', NULL, 1589523222, '商品描述', NULL, NULL, 0),
(263, 4, 0, '2020051514135424755759', 1, '500.00', '支付宝网页支付', 1589523270, 1589523234, '商品描述', '2020051522001404601425269679', '{"gmt_create":"2020-05-15 14:14:25","charset":"UTF-8","seller_email":"2022011382@qq.com","subject":"\\u6d41\\u91cf\\u5e01","sign":"BlnbBmL6xYr0GUy6Z2YwG9wa+K5Vipk2cSB5N8q05JwFH911zoBwcfH+4pnL5i5PA4A\\/hlIFFcZ6jsIbJJNO6rzwXKVojkdhelQgZzYcU4YG+z3cAgsoqik7y\\/rWCrbo7pxUl3LyunsfvWcsq6bTbq5UmLt\\/rN49smO\\/26w7L8e9yFZk\\/oy4ABa0xQDc7GVMLUQYPx2azUPRylIQGPVOZ0WvyYNqG0b1mNvumhDjozfEqAJmxTG2iGTYba4X4IIHj7nonGNb4K3JRlPN0GcD0jcztwLKNbtI0invqtl576xKQywXiKwJhZ9RlOvYpL8U8Y\\/D35fwduEN7nrjfpyIdQ==","body":"\\u5546\\u54c1\\u63cf\\u8ff0","buyer_id":"2088802702304602","invoice_amount":"500.00","notify_id":"2020051500222141431004601424005229","fund_bill_list":"[{\\"amount\\":\\"500.00\\",\\"fundChannel\\":\\"PCREDIT\\"}]","notify_type":"trade_status_sync","trade_status":"TRADE_SUCCESS","receipt_amount":"500.00","buyer_pay_amount":"500.00","app_id":"2021001162627500","sign_type":"RSA2","seller_id":"2088331016475332","gmt_payment":"2020-05-15 14:14:30","notify_time":"2020-05-15 14:14:31","version":"1.0","out_trade_no":"2020051514135424755759","total_amount":"500.00","trade_no":"2020051522001404601425269679","auth_app_id":"2021001162627500","buyer_logon_id":"133****4482","point_amount":"0.00"}', 1);

-- --------------------------------------------------------

--
-- 表的结构 `w_setting`
--

CREATE TABLE IF NOT EXISTS `w_setting` (
  `label` varchar(50) NOT NULL DEFAULT ' ',
  `name` varchar(50) NOT NULL DEFAULT '',
  `value` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `w_setting`
--

INSERT INTO `w_setting` (`label`, `name`, `value`) VALUES
(' ', 'alipay_appid', '333'),
(' ', 'alipay_private', '3333'),
(' ', 'alipay_public', '33'),
(' ', 'alipay_type', 'sha1'),
(' ', 'cache_time', '444'),
(' ', 'copyright', '3333'),
(' ', 'currency', '520'),
(' ', 'descript', '                           \n豌豆是一款集店铺推广与电商查询为一体的流量软件！我们致力打造手机APP流量、PC流量，通过猎流可快速提升淘宝、京东、拼多多等广大卖家的店铺流量，新开发的电商工具更可查验号，防止被骗避免损失，为网店卖家打造 '),
(' ', 'keywords', '豌豆是一款集店铺推广与电商查询为一体的流量软件！我们致力打造手机APP流量、PC流量，通过猎流可快速提升淘宝、京东、拼多多等广大卖家的店铺流量，新开发的电商工具更可查验号，防止被骗避免损失，为网店卖家打造 '),
(' ', 'max_file_upload_size', '333'),
(' ', 'title', '豌豆是一款集店铺推广与电商查询为一体的流量软件！我们致力打造手机APP流量、PC流量，通过猎流可快速提升淘宝、京东、拼多多等广大卖家的店铺流量，新开发的电商工具更可查验号，防止被骗避免损失，为网店卖家打造 '),
(' ', 'upload_file_type', '333'),
(' ', 'web_domian', 'www.taouduo.com'),
(' ', 'web_title', '豌豆电商');

-- --------------------------------------------------------

--
-- 表的结构 `w_task_column`
--

CREATE TABLE IF NOT EXISTS `w_task_column` (
  `column_id` smallint(5) unsigned NOT NULL COMMENT '菜单id',
  `column_name` varchar(30) NOT NULL DEFAULT '' COMMENT '菜单昵称',
  `column_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '父级菜单',
  `column_parent_path` varchar(100) NOT NULL DEFAULT '',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '栏目添加时间',
  `sort` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `keywords` varchar(50) NOT NULL DEFAULT '' COMMENT 'seo关键字',
  `description` varchar(100) NOT NULL DEFAULT '' COMMENT 'seo描述',
  `show_location` tinyint(4) NOT NULL DEFAULT '0',
  `module_id` int(10) unsigned NOT NULL DEFAULT '0',
  `type` tinyint(4) NOT NULL DEFAULT '0',
  `template_id` int(10) unsigned DEFAULT '0'
) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='后台导航';

-- --------------------------------------------------------

--
-- 表的结构 `w_task_record`
--

CREATE TABLE IF NOT EXISTS `w_task_record` (
  `task_record_id` int(10) unsigned NOT NULL,
  `api_id` int(10) unsigned NOT NULL DEFAULT '0',
  `order_price` decimal(10,2) unsigned NOT NULL,
  `order_status` tinyint(4) NOT NULL,
  `count` int(10) unsigned DEFAULT '0',
  `complete_count` int(10) unsigned DEFAULT '0',
  `begin_time` varchar(50) DEFAULT '',
  `send_time` varchar(50) NOT NULL DEFAULT '',
  `taobao_token` varchar(255) NOT NULL,
  `order_id` varchar(30) NOT NULL DEFAULT '',
  `keyword` varchar(255) NOT NULL DEFAULT '',
  `sen_day` varchar(255) NOT NULL,
  `member_id` int(10) unsigned NOT NULL DEFAULT '0',
  `task_name` varchar(30) NOT NULL DEFAULT '',
  `show` int(10) unsigned NOT NULL DEFAULT '0',
  `complete_show` int(10) unsigned DEFAULT '0',
  `send_day` smallint(255) unsigned NOT NULL DEFAULT '0',
  `remark` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `w_task_record`
--

INSERT INTO `w_task_record` (`task_record_id`, `api_id`, `order_price`, `order_status`, `count`, `complete_count`, `begin_time`, `send_time`, `taobao_token`, `order_id`, `keyword`, `sen_day`, `member_id`, `task_name`, `show`, `complete_show`, `send_day`, `remark`) VALUES
(1, 173, '8000.00', 1, 1, 0, '1589426803', '1589426821', '', '2020051453485757', '欢迎前来淘宝网选购热销商品', '', 4, '淘宝App流量', 1000, 0, 1, ''),
(2, 173, '2400.00', 1, 10, 10, '1589427464', '1589427499', '', '2020051498525310', '尖头真皮显瘦弹', '', 4, '淘宝App流量', 30, 30, 1, ''),
(3, 173, '2640.00', 1, 10, 10, '1589427464', '1589427508', '', '2020051452100491', '尖头真皮显瘦弹', '', 4, '淘宝App流量', 33, 33, 1, ''),
(4, 173, '200.00', 1, 5, 5, '1589431852', '1589431905', '', '2020051449521025', '白衬衫女中长款宽松显瘦', '', 4, '淘宝App流量', 5, 5, 1, ''),
(5, 173, '1400.00', 0, 35, 5, '1589431852', '1589431916', '', '2020051499524810', '白衬衫女中长款宽松显瘦', '', 4, '淘宝App流量', 35, 5, 7, ''),
(6, 173, '800.00', 1, 10, 10, '1589431767', '1589432855', '', '2020051455545456', '网店装修代上架', '', 4, '淘宝App流量', 10, 10, 1, ''),
(7, 189, '0.00', 1, 10, 10, '1589432988', '1589433079', '', '2020051455485254', '淘宝店铺代开', '', 4, '淘宝商品搜索', 0, 0, 1, ''),
(8, 188, '0.00', 1, 10, 10, '1589432988', '1589433121', '', '2020051449535298', '淘宝店铺代开', '', 4, '淘宝商品收藏', 0, 0, 1, ''),
(9, 189, '0.00', 1, 10, 10, '1589433020', '1589433241', '', '2020051457505448', '淘宝店铺代开', '', 4, '淘宝商品搜索', 0, 0, 1, ''),
(10, 190, '0.00', 1, 10, 10, '1589433020', '1589433422', '', '2020051410197100', '淘宝店铺代开', '', 4, '淘宝商品直接加购', 0, 0, 1, ''),
(11, 202, '600.00', 1, 10, 10, '1589433452', '1589433618', '', '2020051449561005', '俞兆林（YUZHAOLIN）', '', 4, '京东流量任务', 0, 0, 1, ''),
(12, 204, '1000.00', 1, 10, 10, '1589433453', '1589433695', '', '2020051499509757', '俞兆林（YUZHAOLIN）', '', 4, '京东商品直接收藏任务', 0, 0, 1, ''),
(13, 204, '1000.00', 1, 10, 10, '1589433453', '1589433695', '', '2020051410297505', '俞兆林（YUZHAOLIN）', '', 4, '京东商品直接收藏任务', 0, 0, 1, ''),
(14, 204, '1000.00', 1, 10, 10, '1589433453', '1589433696', '', '2020051410210052', '俞兆林（YUZHAOLIN）', '', 4, '京东商品直接收藏任务', 0, 0, 1, ''),
(15, 204, '1000.00', 1, 10, 10, '1589433453', '1589434054', '', '2020051498101525', '俞兆林（YUZHAOLIN）', '', 4, '京东商品直接收藏任务', 0, 0, 1, ''),
(16, 204, '1000.00', 1, 10, 10, '1589433453', '1589434066', '', '2020051449100485', '俞兆林（YUZHAOLIN）童装夏季', '', 4, '京东商品直接收藏任务', 0, 0, 1, ''),
(17, 204, '1000.00', 1, 10, 10, '1589433453', '1589434111', '', '2020051410149575', '俞兆林（YUZHAOLIN）童装夏季', '', 4, '京东商品直接收藏任务', 0, 0, 1, ''),
(18, 204, '1000.00', 1, 10, 10, '1589433453', '1589434221', '', '2020051410056101', '俞兆林（YUZHAOLIN）童装', '', 4, '京东商品直接收藏任务', 0, 0, 1, ''),
(19, 204, '1000.00', 1, 10, 10, '1589433453', '1589434244', '', '2020051452555310', '俞兆林（YUZHAOLIN）童装', '', 4, '京东商品直接收藏任务', 0, 0, 1, ''),
(20, 216, '200.00', 1, 10, 10, '1589434248', '1589434364', '', '2020051499100569', '烟台大樱桃', '', 4, '拼多多流量任务', 0, 0, 1, ''),
(21, 217, '1000.00', 1, 10, 10, '1589434248', '1589434403', '', '2020051451514910', '烟台大樱桃', '', 4, '拼多多商品搜索收藏任务', 0, 0, 1, ''),
(22, 218, '800.00', 1, 10, 10, '1589434248', '1589434426', '', '2020051497579948', '烟台大樱桃', '', 4, '拼多多商品直接收藏任务', 0, 0, 1, ''),
(23, 187, '33.00', 1, 1, 1, '1589435182', '1589435437', '', '2020051451504999', '', '', 4, '淘宝店铺收藏', 0, 0, 1, ''),
(24, 187, '33.00', 1, 1, 1, '1589435182', '1589435455', '', '2020051456575151', '', '', 4, '淘宝店铺收藏', 0, 0, 1, ''),
(25, 187, '33.00', 1, 1, 1, '1589435182', '1589435473', '', '2020051410253102', '', '', 4, '淘宝店铺收藏', 0, 0, 1, ''),
(26, 187, '33.00', 1, 1, 1, '1589435182', '1589435475', '', '2020051449535498', '', '', 4, '淘宝店铺收藏', 0, 0, 1, ''),
(27, 187, '33.00', 1, 1, 1, '1589435182', '1589435478', '', '2020051451565749', '', '', 4, '淘宝店铺收藏', 0, 0, 1, ''),
(28, 187, '33.00', 1, 1, 1, '1589435182', '1589435526', '', '2020051497575610', '', '', 4, '淘宝店铺收藏', 0, 0, 1, ''),
(29, 187, '33.00', 1, 1, 1, '1589435182', '1589435528', '', '2020051454515650', '', '', 4, '淘宝店铺收藏', 0, 0, 1, ''),
(30, 173, '8.00', 1, 1, 1, '1589437788', '1589437800', '', '2020051456985348', '1', '', 4, '淘宝App流量', 1, 1, 1, ''),
(31, 173, '8.00', 1, 1, 1, '1589437867', '1589437879', '', '2020051449495753', '1', '', 4, '淘宝App流量', 1, 1, 1, ''),
(32, 173, '8.00', 1, 1, 1, '1589437724', '1589437905', '', '2020051449515510', '33', '', 4, '淘宝App流量', 1, 1, 1, ''),
(33, 202, '0.00', 1, 1, 1, '1589437931', '1589437980', '', '2020051498491025', '33', '', 4, '京东流量任务', 0, 0, 1, ''),
(34, 202, '0.00', 1, 1, 1, '1589437931', '1589437992', '', '2020051456979756', '33', '', 4, '京东流量任务', 0, 0, 1, ''),
(35, 189, '0.00', 1, 1, 1, '1589438624', '1589438635', '', '2020051498101521', '啊', '', 4, '淘宝商品搜索', 0, 0, 1, ''),
(36, 173, '80000.00', 1, 100, 100, '1589438888', '1589438905', '', '2020051456555110', '11', '', 4, '淘宝App流量', 100, 100, 1, ''),
(37, 173, '8.00', 0, 1, 0, '1590076800', '1589439169', '', '2020051449485652', '1', '', 4, '淘宝App流量', 1, 0, 1, ''),
(38, 173, '8.00', 1, 1, 1, '1589385600', '1589439180', '', '2020051499571005', '1', '', 4, '淘宝App流量', 1, 1, 1, ''),
(39, 202, '0.00', 8, 13039, 1003, '1589439736', '1589439755', '', '2020051497100555', '33', '', 4, '京东流量任务', 0, 0, 13, ''),
(40, 204, '10890.00', 1, 33, 33, '1589439763', '1589439771', '', '2020051498555497', '33', '', 4, '京东商品直接收藏任务', 0, 0, 1, ''),
(41, 202, '0.00', 1, 1, 1, '1589439693', '1589439855', '', '2020051410155995', '111', '', 4, '京东流量任务', 0, 0, 1, ''),
(42, 202, '0.00', 1, 1, 1, '1589439887', '1589439898', '', '2020051497564949', '1', '', 4, '京东流量任务', 0, 0, 1, ''),
(43, 204, '10.00', 1, 1, 1, '1589439978', '1589439989', '', '2020051452100504', '1', '', 4, '京东商品直接收藏任务', 0, 0, 1, ''),
(44, 173, '8.00', 1, 1, 1, '1589448862', '1589448889', '', '2020051457481019', '矮矮', '', 4, '淘宝App流量', 1, 1, 1, ''),
(45, 173, '8.00', 1, 1, 1, '1589458735', '1589458777', '', '2020051457999857', '搜索', '', 4, '淘宝App流量', 1, 1, 1, ''),
(46, 173, '8.00', 1, 1, 1, '1589458735', '1589458783', '', '2020051410253481', '搜索', '', 4, '淘宝App流量', 1, 1, 1, ''),
(47, 173, '80000.00', 1, 100, 100, '1589458787', '1589458807', '', '2020051455534810', '去', '', 4, '淘宝App流量', 100, 100, 1, ''),
(48, 173, '80000.00', 1, 100, 100, '1589458787', '1589458813', '', '2020051410051995', '去', '', 4, '淘宝App流量', 100, 100, 1, ''),
(49, 173, '800.00', 1, 10, 10, '1589460350', '1589460645', '', '2020051453541005', ' 京东淘宝阿里巴巴店铺代运营', '', 4, '淘宝App流量', 10, 10, 1, ''),
(50, 187, '3300.00', 1, 10, 10, '1589460454', '1589460694', '', '2020051498495254', '', '', 4, '淘宝店铺收藏', 0, 0, 1, ''),
(51, 187, '3300.00', 1, 10, 10, '1589460454', '1589460696', '', '2020051454101485', '', '', 4, '淘宝店铺收藏', 0, 0, 1, '');

-- --------------------------------------------------------

--
-- 表的结构 `w_video`
--

CREATE TABLE IF NOT EXISTS `w_video` (
  `video_id` int(10) unsigned NOT NULL COMMENT '视频id',
  `video_title` varchar(255) NOT NULL DEFAULT '' COMMENT '视频标题',
  `video_author` varchar(30) NOT NULL DEFAULT '' COMMENT '视频作者',
  `video_desc` varchar(255) NOT NULL DEFAULT '' COMMENT '视频简短描述',
  `member_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员id',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态',
  `admin_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '审核管理员id',
  `release_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '发布时间',
  `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '视频添加时间',
  `like_people_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点赞人数',
  `seo_title` varchar(100) NOT NULL DEFAULT '' COMMENT 'seo标题',
  `seo_desc` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo描述',
  `seo_keywords` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo_关键字',
  `video_img` varchar(100) NOT NULL DEFAULT '',
  `item` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `category_id` int(10) unsigned NOT NULL DEFAULT '0',
  `video_path` varchar(50) NOT NULL DEFAULT '' COMMENT '视频'
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='视频表';

--
-- 转存表中的数据 `w_video`
--

INSERT INTO `w_video` (`video_id`, `video_title`, `video_author`, `video_desc`, `member_id`, `status`, `admin_id`, `release_time`, `add_time`, `like_people_num`, `seo_title`, `seo_desc`, `seo_keywords`, `video_img`, `item`, `category_id`, `video_path`) VALUES
(2, '3333', '33', '333333', 0, 0, 0, '2020-05-08 18:48:16', '2020-05-08 18:48:16', 0, '', '', '', '/upload/wx.png', 1, 1, '/upload/demo.mp4'),
(3, 'fsdfsdfdsf', 'fsdfsdf', 'fsdfsd', 0, 0, 0, '2020-05-08 18:52:45', '2020-05-08 18:52:45', 0, '', '', '', '/upload/zfb.png', 1, 1, '/upload/demo.mp4'),
(4, 'fdsfdsfsdf', 'fsdfdsf', 'fsdfdsfds', 0, 0, 0, '2020-05-12 07:08:55', '2020-05-12 07:08:55', 0, '', '', '', '/upload/wx.png', 1, 1, '/upload/demo.mp4'),
(5, 'fsdfdsf', 'fdsfds', 'fdsfds', 0, 0, 0, '2020-05-12 07:09:15', '2020-05-12 07:09:15', 0, '', '', '', '/upload/wx.png', 1, 1, '/upload/demo.mp4');

-- --------------------------------------------------------

--
-- 表的结构 `w_video_category`
--

CREATE TABLE IF NOT EXISTS `w_video_category` (
  `category_id` int(10) unsigned NOT NULL COMMENT '分类id',
  `category_title` varchar(255) NOT NULL DEFAULT '' COMMENT '分类id',
  `category_parent` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '分类父级id',
  `category_parent_path` varchar(10) NOT NULL DEFAULT '' COMMENT '分类父节点路径',
  `seo_title` varchar(50) NOT NULL DEFAULT '' COMMENT 'seo标题',
  `seo_keywords` varchar(100) NOT NULL DEFAULT '' COMMENT 'seo 关键字',
  `seo_desc` varchar(255) NOT NULL DEFAULT '' COMMENT 'seo描述',
  `sort` tinyint(255) unsigned NOT NULL DEFAULT '255'
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='视频分类';

--
-- 转存表中的数据 `w_video_category`
--

INSERT INTO `w_video_category` (`category_id`, `category_title`, `category_parent`, `category_parent_path`, `seo_title`, `seo_keywords`, `seo_desc`, `sort`) VALUES
(1, '电商教程', 0, '', '电商教程', '电商教程', '电商教程', 255);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `w_admin_group`
--
ALTER TABLE `w_admin_group`
  ADD PRIMARY KEY (`admin_group_id`) USING BTREE;

--
-- Indexes for table `w_admin_menu`
--
ALTER TABLE `w_admin_menu`
  ADD PRIMARY KEY (`menu_id`) USING BTREE;

--
-- Indexes for table `w_admin_user`
--
ALTER TABLE `w_admin_user`
  ADD PRIMARY KEY (`admin_id`) USING BTREE;

--
-- Indexes for table `w_advertising`
--
ALTER TABLE `w_advertising`
  ADD PRIMARY KEY (`advertising_id`) USING BTREE;

--
-- Indexes for table `w_api`
--
ALTER TABLE `w_api`
  ADD PRIMARY KEY (`api_id`);

--
-- Indexes for table `w_api_field`
--
ALTER TABLE `w_api_field`
  ADD PRIMARY KEY (`api_field_id`),
  ADD KEY `api_id` (`api_id`);

--
-- Indexes for table `w_api_param`
--
ALTER TABLE `w_api_param`
  ADD PRIMARY KEY (`api_param_id`);

--
-- Indexes for table `w_api_price`
--
ALTER TABLE `w_api_price`
  ADD PRIMARY KEY (`price_id`);

--
-- Indexes for table `w_api_type`
--
ALTER TABLE `w_api_type`
  ADD PRIMARY KEY (`api_type_id`);

--
-- Indexes for table `w_article`
--
ALTER TABLE `w_article`
  ADD PRIMARY KEY (`article_id`);

--
-- Indexes for table `w_article_category`
--
ALTER TABLE `w_article_category`
  ADD PRIMARY KEY (`category_id`);

--
-- Indexes for table `w_article_comment`
--
ALTER TABLE `w_article_comment`
  ADD PRIMARY KEY (`comment_id`);

--
-- Indexes for table `w_cash`
--
ALTER TABLE `w_cash`
  ADD PRIMARY KEY (`cash_id`);

--
-- Indexes for table `w_cash_back_log`
--
ALTER TABLE `w_cash_back_log`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `w_column`
--
ALTER TABLE `w_column`
  ADD PRIMARY KEY (`column_id`) USING BTREE;

--
-- Indexes for table `w_content`
--
ALTER TABLE `w_content`
  ADD PRIMARY KEY (`content_id`);

--
-- Indexes for table `w_friend_link`
--
ALTER TABLE `w_friend_link`
  ADD PRIMARY KEY (`link_id`) USING BTREE;

--
-- Indexes for table `w_member`
--
ALTER TABLE `w_member`
  ADD PRIMARY KEY (`member_id`) USING BTREE;

--
-- Indexes for table `w_member_level`
--
ALTER TABLE `w_member_level`
  ADD PRIMARY KEY (`level_id`) USING BTREE;

--
-- Indexes for table `w_recharge_order`
--
ALTER TABLE `w_recharge_order`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `w_setting`
--
ALTER TABLE `w_setting`
  ADD UNIQUE KEY `w_setting_name_uindex` (`name`);

--
-- Indexes for table `w_task_column`
--
ALTER TABLE `w_task_column`
  ADD PRIMARY KEY (`column_id`) USING BTREE;

--
-- Indexes for table `w_task_record`
--
ALTER TABLE `w_task_record`
  ADD PRIMARY KEY (`task_record_id`);

--
-- Indexes for table `w_video`
--
ALTER TABLE `w_video`
  ADD PRIMARY KEY (`video_id`);

--
-- Indexes for table `w_video_category`
--
ALTER TABLE `w_video_category`
  ADD PRIMARY KEY (`category_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `w_admin_group`
--
ALTER TABLE `w_admin_group`
  MODIFY `admin_group_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '组id',AUTO_INCREMENT=41;
--
-- AUTO_INCREMENT for table `w_admin_menu`
--
ALTER TABLE `w_admin_menu`
  MODIFY `menu_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '菜单id',AUTO_INCREMENT=292;
--
-- AUTO_INCREMENT for table `w_admin_user`
--
ALTER TABLE `w_admin_user`
  MODIFY `admin_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户id',AUTO_INCREMENT=50;
--
-- AUTO_INCREMENT for table `w_advertising`
--
ALTER TABLE `w_advertising`
  MODIFY `advertising_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '广告id',AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT for table `w_api`
--
ALTER TABLE `w_api`
  MODIFY `api_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',AUTO_INCREMENT=247;
--
-- AUTO_INCREMENT for table `w_api_field`
--
ALTER TABLE `w_api_field`
  MODIFY `api_field_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1203;
--
-- AUTO_INCREMENT for table `w_api_param`
--
ALTER TABLE `w_api_param`
  MODIFY `api_param_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=127;
--
-- AUTO_INCREMENT for table `w_api_price`
--
ALTER TABLE `w_api_price`
  MODIFY `price_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=388;
--
-- AUTO_INCREMENT for table `w_api_type`
--
ALTER TABLE `w_api_type`
  MODIFY `api_type_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `w_article`
--
ALTER TABLE `w_article`
  MODIFY `article_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文章id',AUTO_INCREMENT=36;
--
-- AUTO_INCREMENT for table `w_article_category`
--
ALTER TABLE `w_article_category`
  MODIFY `category_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文章分类id',AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `w_article_comment`
--
ALTER TABLE `w_article_comment`
  MODIFY `comment_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '评论id';
--
-- AUTO_INCREMENT for table `w_cash`
--
ALTER TABLE `w_cash`
  MODIFY `cash_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=80;
--
-- AUTO_INCREMENT for table `w_cash_back_log`
--
ALTER TABLE `w_cash_back_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `w_column`
--
ALTER TABLE `w_column`
  MODIFY `column_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '菜单id',AUTO_INCREMENT=54;
--
-- AUTO_INCREMENT for table `w_content`
--
ALTER TABLE `w_content`
  MODIFY `content_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=26;
--
-- AUTO_INCREMENT for table `w_friend_link`
--
ALTER TABLE `w_friend_link`
  MODIFY `link_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',AUTO_INCREMENT=21;
--
-- AUTO_INCREMENT for table `w_member`
--
ALTER TABLE `w_member`
  MODIFY `member_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户id',AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `w_member_level`
--
ALTER TABLE `w_member_level`
  MODIFY `level_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=27;
--
-- AUTO_INCREMENT for table `w_recharge_order`
--
ALTER TABLE `w_recharge_order`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=264;
--
-- AUTO_INCREMENT for table `w_task_column`
--
ALTER TABLE `w_task_column`
  MODIFY `column_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '菜单id',AUTO_INCREMENT=47;
--
-- AUTO_INCREMENT for table `w_task_record`
--
ALTER TABLE `w_task_record`
  MODIFY `task_record_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=52;
--
-- AUTO_INCREMENT for table `w_video`
--
ALTER TABLE `w_video`
  MODIFY `video_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '视频id',AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `w_video_category`
--
ALTER TABLE `w_video_category`
  MODIFY `category_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类id',AUTO_INCREMENT=3;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;