wu0
/
sifangpay
1
0
Fork 0
Code Issues Pull Requests Releases Wiki Activity
sifangpay/鈺も枌鈺┾暃SQL.sql

2251 lines
191 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

-- phpMyAdmin SQL Dump
-- version 4.4.15.10
-- https://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: 2019-12-09 17:44:25
-- 服务器版本： 10.3.10-MariaDB-log
-- PHP Version: 7.3.3
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: `zf2`
--
-- --------------------------------------------------------
--
-- 表的结构 `admins`
--
CREATE TABLE IF NOT EXISTS `admins` (
`id` int(10) unsigned NOT NULL,
`account` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '账号',
`mobile` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '手机',
`realname` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '真实姓名',
`password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '密码',
`last_number` int(11) NOT NULL DEFAULT 0 COMMENT '登陆次数',
`ip` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '登陆IP',
`last_time` datetime DEFAULT NULL COMMENT '最后登陆时间',
`is_checked` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态1:启用,0:禁用',
`remember_token` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '记录登陆',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `admins`
--
INSERT INTO `admins` (`id`, `account`, `mobile`, `realname`, `password`, `last_number`, `ip`, `last_time`, `is_checked`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'kongqi', '13420454614', '超级管理员', '$2y$10$J9lrcFPwKy.VQ9FrxfYmtuJytAEM8vnzRuhedLLpIe4Jo30OOiJ.q', 0, '', NULL, 1, 'TFzlS3QGHCo34OJwPDB64x68uVs6L3ZpkurUU6p1Dd4c9mn7SdDUbXZHdNb9', NULL, '2019-11-07 03:42:15');
-- --------------------------------------------------------
--
-- 表的结构 `admin_logs`
--
CREATE TABLE IF NOT EXISTS `admin_logs` (
`id` int(10) unsigned NOT NULL,
`admin_id` int(10) unsigned NOT NULL COMMENT '所属管理员id',
`desc` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '日志描述',
`ip` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'IP地址',
`url` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '操作地址',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `admin_logs`
--
INSERT INTO `admin_logs` (`id`, `admin_id`, `desc`, `ip`, `url`, `created_at`, `updated_at`) VALUES
(1, 1, '网站配置创建成功', '223.74.193.18', 'admin/website/store', '2019-08-23 15:27:43', '2019-08-23 15:27:43'),
(2, 1, '管理员更新成功', '120.235.124.47', 'admin/admin/1', '2019-11-07 03:42:15', '2019-11-07 03:42:15'),
(3, 1, '网站配置创建成功', '120.235.124.47', 'admin/website/store', '2019-11-07 03:56:54', '2019-11-07 03:56:54'),
(4, 1, '网站配置创建成功', '113.16.249.110', 'admin/website/store', '2019-11-09 13:39:58', '2019-11-09 13:39:58'),
(5, 1, '风控设置创建成功', '206.201.6.140', 'admin/gatewaywind', '2019-11-09 19:11:22', '2019-11-09 19:11:22'),
(6, 1, '系统公告创建成功', '134.159.247.196', 'admin/noticearticle', '2019-11-10 04:39:04', '2019-11-10 04:39:04'),
(7, 1, '支付通道创建成功', '183.3.226.234', 'admin/gateway', '2019-11-18 06:52:34', '2019-11-18 06:52:34'),
(8, 1, '支付通道更新成功', '183.3.226.234', 'admin/gateway/2', '2019-11-18 06:53:44', '2019-11-18 06:53:44'),
(9, 1, '支付通道更新成功', '183.3.226.234', 'admin/gateway/3', '2019-11-18 06:54:04', '2019-11-18 06:54:04'),
(10, 1, '支付通道创建成功', '183.3.226.234', 'admin/gateway', '2019-11-18 06:56:36', '2019-11-18 06:56:36'),
(11, 1, '支付通道创建成功', '183.3.226.234', 'admin/gateway', '2019-11-18 06:57:52', '2019-11-18 06:57:52'),
(12, 1, '支付通道创建成功', '183.3.226.234', 'admin/gateway', '2019-11-18 06:59:15', '2019-11-18 06:59:15'),
(13, 1, '支付通道更新成功', '120.235.126.53', 'admin/gateway/6', '2019-11-21 09:17:50', '2019-11-21 09:17:50'),
(14, 1, '产品服务删除 ID:11', '61.158.148.117', 'admin/handle/del', '2019-11-21 14:32:47', '2019-11-21 14:32:47'),
(15, 1, '会员删除 ID:1', '103.216.43.146', 'admin/handle/del', '2019-11-22 02:23:14', '2019-11-22 02:23:14'),
(16, 1, '操作订单，行为是完成订单支付操作', '103.216.43.146', 'admin/orderhandleapi/handle/post/10/payUpdate', '2019-11-22 02:24:47', '2019-11-22 02:24:47'),
(17, 1, '操作订单，行为是完成订单支付操作', '1.198.19.250', 'admin/orderhandleapi/handle/post/12/payUpdate', '2019-11-22 07:27:14', '2019-11-22 07:27:14'),
(18, 1, '商户创建成功', '117.140.169.251', 'admin/merchant', '2019-11-22 07:35:44', '2019-11-22 07:35:44'),
(19, 1, '商户创建成功', '117.140.169.251', 'admin/merchant', '2019-11-22 07:57:49', '2019-11-22 07:57:49'),
(20, 1, '商户创建成功', '117.140.169.251', 'admin/merchant', '2019-11-22 07:58:45', '2019-11-22 07:58:45'),
(21, 1, '网站配置创建成功', '125.41.133.67', 'admin/website/store', '2019-11-23 07:28:39', '2019-11-23 07:28:39'),
(22, 1, '网站配置创建成功', '125.41.133.67', 'admin/website/store', '2019-11-23 07:29:15', '2019-11-23 07:29:15'),
(23, 1, '操作订单，行为是完成订单支付操作', '223.74.193.71', 'admin/orderhandleapi/handle/post/22/payUpdate', '2019-11-23 15:15:31', '2019-11-23 15:15:31'),
(24, 1, '操作订单，行为是完成订单支付操作', '223.74.193.71', 'admin/orderhandleapi/handle/post/23/payUpdate', '2019-11-23 15:15:34', '2019-11-23 15:15:34'),
(25, 1, '操作订单，行为是完成订单支付操作', '110.52.199.181', 'admin/orderhandleapi/handle/post/24/payUpdate', '2019-11-23 18:43:37', '2019-11-23 18:43:37'),
(26, 1, '服务分类更新成功', '115.190.202.151', 'admin/category/server/4', '2019-11-24 05:42:44', '2019-11-24 05:42:44'),
(27, 1, '操作订单，行为是完成订单支付操作', '116.233.108.44', 'admin/orderhandleapi/handle/post/30/payUpdate', '2019-11-25 02:47:32', '2019-11-25 02:47:32'),
(28, 1, '服务分类更新成功', '171.83.4.123', 'admin/category/server/4', '2019-11-25 03:43:47', '2019-11-25 03:43:47'),
(29, 1, '服务分类更新成功', '171.83.4.123', 'admin/category/server/4', '2019-11-25 03:43:52', '2019-11-25 03:43:52'),
(30, 1, '操作订单，行为是完成订单支付操作', '211.68.119.166', 'admin/orderhandleapi/handle/post/36/payUpdate', '2019-11-25 13:50:28', '2019-11-25 13:50:28'),
(31, 1, '操作订单，行为是完成订单支付操作', '123.1.184.251', 'admin/orderhandleapi/handle/post/39/payUpdate', '2019-11-25 14:41:45', '2019-11-25 14:41:45'),
(32, 1, '操作订单，行为是完成订单支付操作', '59.41.65.222', 'admin/orderhandleapi/handle/post/43/payUpdate', '2019-11-26 10:46:51', '2019-11-26 10:46:51'),
(33, 1, '单页分类删除 ID:2', '219.141.211.74', 'admin/handle/del', '2019-11-27 09:40:40', '2019-11-27 09:40:40'),
(34, 1, '会员创建成功', '113.70.218.92', 'admin/user', '2019-11-27 13:01:47', '2019-11-27 13:01:47'),
(35, 1, '银行列表更新成功', '60.176.149.245', 'admin/bank/9', '2019-11-27 16:00:39', '2019-11-27 16:00:39'),
(36, 1, '银行列表更新成功', '60.176.149.245', 'admin/bank/9', '2019-11-27 16:00:48', '2019-11-27 16:00:48'),
(37, 1, '操作订单，行为是完成订单支付操作', '222.247.142.145', 'admin/orderhandleapi/handle/post/50/payUpdate', '2019-11-27 17:33:23', '2019-11-27 17:33:23'),
(38, 1, '网站配置创建成功', '110.184.65.24', 'admin/website/store', '2019-11-28 00:58:46', '2019-11-28 00:58:46'),
(39, 1, '网站配置创建成功', '110.184.65.24', 'admin/website/store', '2019-11-28 00:58:53', '2019-11-28 00:58:53'),
(40, 1, '网站配置创建成功', '66.42.67.124', 'admin/website/store', '2019-11-28 01:41:44', '2019-11-28 01:41:44'),
(41, 1, '操作订单，行为是完成订单支付操作', '175.9.184.203', 'admin/orderhandleapi/handle/post/54/payUpdate', '2019-11-28 01:45:45', '2019-11-28 01:45:45'),
(42, 1, '操作订单，行为是完成订单支付操作', '175.9.184.203', 'admin/orderhandleapi/handle/post/53/payUpdate', '2019-11-28 01:45:53', '2019-11-28 01:45:53'),
(43, 1, '商户更新成功', '180.142.152.138', 'admin/merchant/16', '2019-11-28 18:39:00', '2019-11-28 18:39:00'),
(44, 1, '商户更新成功', '180.142.152.138', 'admin/merchant/17', '2019-11-28 18:39:23', '2019-11-28 18:39:23'),
(45, 1, '操作订单，行为是完成订单支付操作', '110.53.228.12', 'admin/orderhandleapi/handle/post/58/payUpdate', '2019-11-29 06:45:55', '2019-11-29 06:45:55'),
(46, 1, '产品服务删除 ID:4', '123.117.17.148', 'admin/handle/del', '2019-11-29 11:44:50', '2019-11-29 11:44:50'),
(47, 1, '服务分类更新成功', '117.28.246.18', 'admin/category/server/4', '2019-12-01 12:56:03', '2019-12-01 12:56:03'),
(48, 1, '服务分类更新成功', '117.28.246.18', 'admin/category/server/4', '2019-12-01 12:56:04', '2019-12-01 12:56:04'),
(49, 1, '内容更新成功', '117.28.246.18', 'admin/article/content/post', '2019-12-01 12:56:33', '2019-12-01 12:56:33'),
(50, 1, '商户更新成功', '180.142.152.138', 'admin/merchant/13', '2019-12-01 15:03:19', '2019-12-01 15:03:19'),
(51, 1, '商户创建成功', '180.142.152.138', 'admin/merchant', '2019-12-01 15:04:15', '2019-12-01 15:04:15'),
(52, 1, '商户创建成功', '180.142.152.138', 'admin/merchant', '2019-12-01 15:05:18', '2019-12-01 15:05:18'),
(53, 1, '商户更新成功', '180.142.152.138', 'admin/merchant/18', '2019-12-01 15:06:24', '2019-12-01 15:06:24'),
(54, 1, '商户更新成功', '223.10.187.57', 'admin/merchant/19', '2019-12-02 03:45:44', '2019-12-02 03:45:44'),
(55, 1, '商户更新成功', '223.10.187.57', 'admin/merchant/19', '2019-12-02 03:46:23', '2019-12-02 03:46:23'),
(56, 1, '服务分类删除 ID:4', '117.28.246.18', 'admin/handle/del', '2019-12-02 07:34:46', '2019-12-02 07:34:46'),
(57, 1, '会员创建成功', '117.28.246.18', 'admin/user', '2019-12-02 07:35:55', '2019-12-02 07:35:55'),
(58, 1, '单页分类删除 ID:1', '125.70.229.227', 'admin/handle/del', '2019-12-02 07:52:20', '2019-12-02 07:52:20'),
(59, 1, '银行列表删除 ID:9、8、7、6、5、4、3、2、1', '125.70.229.227', 'admin/handle/del', '2019-12-02 07:53:42', '2019-12-02 07:53:42'),
(60, 1, '商户删除 ID:17', '183.67.44.98', 'admin/handle/del', '2019-12-03 02:24:04', '2019-12-03 02:24:04'),
(61, 1, '网站配置创建成功', '210.68.95.160', 'admin/website/store', '2019-12-03 03:25:43', '2019-12-03 03:25:43'),
(62, 1, '网站配置创建成功', '120.229.153.134', 'admin/website/store', '2019-12-04 14:16:45', '2019-12-04 14:16:45'),
(63, 1, '操作订单，行为是完成订单支付操作', '120.229.153.134', 'admin/orderhandleapi/handle/post/73/payUpdate', '2019-12-04 16:38:35', '2019-12-04 16:38:35'),
(64, 1, '支付通道更新成功', '117.181.147.145', 'admin/gateway/2', '2019-12-05 15:09:50', '2019-12-05 15:09:50'),
(65, 1, '支付通道更新成功', '183.236.87.106', 'admin/gateway/5', '2019-12-06 08:00:14', '2019-12-06 08:00:14'),
(66, 1, '网站配置创建成功', '183.236.87.106', 'admin/website/store', '2019-12-06 08:02:42', '2019-12-06 08:02:42'),
(67, 1, '服务分类创建成功', '36.47.160.44', 'admin/category/server/store', '2019-12-07 02:23:37', '2019-12-07 02:23:37'),
(68, 1, '操作订单，行为是完成订单支付操作', '220.176.214.49', 'admin/orderhandleapi/handle/post/82/payUpdate', '2019-12-08 14:23:02', '2019-12-08 14:23:02'),
(69, 1, '网站配置创建成功', '103.42.217.84', 'admin/website/store', '2019-12-08 20:34:19', '2019-12-08 20:34:19'),
(70, 1, '网站配置创建成功', '114.102.177.102', 'admin/website/store', '2019-12-09 01:30:24', '2019-12-09 01:30:24'),
(71, 1, '操作订单，行为是完成订单支付操作', '121.32.183.243', 'admin/orderhandleapi/handle/post/86/payUpdate', '2019-12-09 03:14:14', '2019-12-09 03:14:14'),
(72, 1, '网站配置创建成功', '120.235.126.92', 'admin/website/store', '2019-12-09 05:47:49', '2019-12-09 05:47:49'),
(73, 1, '操作订单，行为是完成订单支付操作', '120.235.126.92', 'admin/orderhandleapi/handle/post/89/payUpdate', '2019-12-09 05:59:55', '2019-12-09 05:59:55'),
(74, 1, '网站配置创建成功', '120.235.126.92', 'admin/website/store', '2019-12-09 09:44:11', '2019-12-09 09:44:11');
-- --------------------------------------------------------
--
-- 表的结构 `articles`
--
CREATE TABLE IF NOT EXISTS `articles` (
`id` int(10) unsigned NOT NULL,
`category_id` int(11) NOT NULL DEFAULT 0 COMMENT '栏目id',
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名字',
`ename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '英文名',
`content` text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '内容',
`sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
`is_checked` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态1:启用,0:禁用',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `articles`
--
INSERT INTO `articles` (`id`, `category_id`, `name`, `ename`, `content`, `sort`, `is_checked`, `created_at`, `updated_at`) VALUES
(1, 1, '关于我们', NULL, '<p>112121</p>', 0, 1, '2019-12-01 12:56:33', '2019-12-01 12:56:33');
-- --------------------------------------------------------
--
-- 表的结构 `banks`
--
CREATE TABLE IF NOT EXISTS `banks` (
`id` int(10) unsigned NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '银行名称',
`thumb` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '银行图标',
`bank_sn` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '银行编码',
`sort` smallint(6) NOT NULL DEFAULT 1 COMMENT '排序',
`is_checked` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态1:启用,0:禁用',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `bank_rels`
--
CREATE TABLE IF NOT EXISTS `bank_rels` (
`id` int(10) unsigned NOT NULL,
`sort` smallint(6) NOT NULL DEFAULT 0 COMMENT '排序',
`model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`model_id` bigint(20) unsigned NOT NULL,
`name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '银行名字',
`realname` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收款人',
`account` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '银行账号',
`source` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '银行开户行',
`is_default` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否默认，1是，0否',
`is_checked` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态1:启用,0:禁用',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `banners`
--
CREATE TABLE IF NOT EXISTS `banners` (
`id` int(10) unsigned NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',
`type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '使用场景',
`thumb` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '图片地址',
`url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '#' COMMENT '链接',
`sort` smallint(6) NOT NULL DEFAULT 0 COMMENT '排序',
`is_checked` tinyint(4) NOT NULL DEFAULT 1 COMMENT '审核1=通过,0=不通过,默认1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `categories`
--
CREATE TABLE IF NOT EXISTS `categories` (
`id` int(10) unsigned NOT NULL,
`type` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '类型:exp百科,话题,商城,酒店星级,银行分类,商家分类..',
`name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',
`ename` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '调用英文名字',
`thumb` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '图片',
`parent_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '上级id',
`sort` smallint(6) NOT NULL DEFAULT 0 COMMENT '排序',
`is_checked` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态1:启用,0:禁用',
`seo_title` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'SEO标题',
`seo_keyword` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'SEO关键词',
`seo_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'SEO描述',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `categories`
--
INSERT INTO `categories` (`id`, `type`, `name`, `ename`, `thumb`, `parent_id`, `sort`, `is_checked`, `seo_title`, `seo_keyword`, `seo_description`, `created_at`, `updated_at`) VALUES
(5, 'server', '测试', 'cs', '0', 0, 0, 1, '', '', '', '2019-12-07 02:23:37', '2019-12-07 02:23:37');
-- --------------------------------------------------------
--
-- 表的结构 `configs`
--
CREATE TABLE IF NOT EXISTS `configs` (
`id` int(10) unsigned NOT NULL,
`ename` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '调用英文名',
`content` text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '值'
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `configs`
--
INSERT INTO `configs` (`id`, `ename`, `content`) VALUES
(1, 'file', ''),
(2, 'logo', '/upload/images/20191209/6b3fe4064330e8323a57964fcbc63c334761.jpg'),
(3, 'sitename', 'test'),
(4, 'subname', 'test'),
(5, 'keyword', 'test'),
(6, 'description', 'test'),
(7, 'copyright', ''),
(8, 'icp', ''),
(9, 'mobile', ''),
(10, 'tongji', ''),
(11, 'wx_mchid', '56111'),
(12, 'wx_appkey', '5546'),
(13, 'wx_appid', '65664'),
(14, 'wx_appsert', '5664'),
(15, 'al_account', '6456655465'),
(16, 'al_appkey', '6566656'),
(17, 'al_partner', '46565'),
(18, 'sms_name', ''),
(19, 'sms_appid', ''),
(20, 'sms_appkey', ''),
(21, 'stmp_name', '5656'),
(22, 'stmp_port', '56565'),
(23, 'stmp_account', '65654'),
(24, 'stmp_password', '6'),
(25, 'stmp_accept_email', '5656'),
(27, 'config_name', 'merchant_config'),
(28, 'draw_min_money', '10'),
(29, 'draw_max_money', '50000'),
(30, 'draw_day_max_money', '500000'),
(31, 'draw_day_times', '5'),
(32, 'draw_email', ''),
(33, 'draw_open', '1'),
(34, 'doc', ''),
(35, 'api_pay_url', 'http://zf2.kongqikeji.com/order/order'),
(36, 'api_pay_url2', ''),
(37, 'api_pay_url3', ''),
(38, '_token', 'HLrfxQo14It8Wh79LhOqKiGx3gmPEqbSXG4ILlGf'),
(39, 'draw_day_money_ratio', '20'),
(40, 'draw_time_limit', '0-24'),
(41, 'merchant_time', '30'),
(42, 'merchant_update_number', '50'),
(43, 'order_time', '30'),
(44, 'order_nopay_number', '50'),
(45, 'demo_pay_url', 'http://zf2.kongqikeji.com/demo2/'),
(46, 'admin_res_version', 'v4.2311'),
(47, 'merchant_res_version', 'v4.2311'),
(48, 'draw_money_ratio', '0.3'),
(49, 'draw_tips', '本平台支持D0、T0、D1、T1提现。\nD日是指自然日，包括周末和节假日均可办理提现。\nT日是指交易日\n+0的含义是指资金清算时间为本日, 而非实时到\n+1的含义是指正常清算时间为第二个工作日\nD0一般到账时间为2小时内，处理时间为自然日9:00-20:00\nT0一般到账时间为2小时内，处理时间为工作日9:00-20:00\nD1一般到账时间为2小时内，处理时间为自然日9:00-22:00\nT1一般到账时间为2小时内，处理时间为工作日9:00-22:00'),
(50, 'admin_path', 'admin'),
(51, 'merchant_path', ''),
(52, 'order_tips_time', '15'),
(53, 'draw_tips_time', '1800'),
(54, 'ma_to_share', '0'),
(55, 'merchant_gudong_check', '1'),
(56, 'merchant_daili_check', '0'),
(57, 'merchant_regist', '1'),
(58, 'merchant_regist_min_money', ''),
(59, 'merchant_regist_money_list', '500\n1000\n1500\n2000\n2500\n3500\n4500\n5000\n5500\n6000\n6500'),
(60, 'merchant_regist_has_ratio', '10'),
(61, 'merchant_regist_min_ratio', '60'),
(62, 'merchant_regist_pay_account_id', '');
-- --------------------------------------------------------
--
-- 表的结构 `draw_moneys`
--
CREATE TABLE IF NOT EXISTS `draw_moneys` (
`id` int(10) unsigned NOT NULL,
`merchant_id` int(11) NOT NULL COMMENT '商户id',
`draw_money` decimal(10,2) NOT NULL COMMENT '提现金额',
`money` decimal(10,2) NOT NULL COMMENT '到账金额',
`fee_money` decimal(8,2) NOT NULL DEFAULT 0.00 COMMENT '手续费',
`bank_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '银行卡类型',
`bank_account` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '银行卡账号',
`bank_realname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '收款人',
`bank_source` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '银行开户行',
`status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '状态:1,提现成功,0,未处理，2,处理中,3提现失败',
`draw_type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '提现到账类型,1=T+0,2=T+1,3...',
`success_at` datetime DEFAULT NULL COMMENT '处理时间',
`mark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
`admin_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '操作人id',
`admin_name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '操作人姓名',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `draw_sets`
--
CREATE TABLE IF NOT EXISTS `draw_sets` (
`id` int(10) unsigned NOT NULL,
`start_money` decimal(10,2) NOT NULL COMMENT '开始金额',
`end_money` decimal(10,2) NOT NULL COMMENT '截至金额',
`money` decimal(10,2) NOT NULL COMMENT '收费金额',
`draw_type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '提现类型,1=T+0,2=T+1,3...',
`sort` smallint(6) NOT NULL DEFAULT 0 COMMENT '排序',
`is_checked` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态1:启用,0:禁用',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `draw_sets`
--
INSERT INTO `draw_sets` (`id`, `start_money`, `end_money`, `money`, `draw_type`, `sort`, `is_checked`, `created_at`, `updated_at`) VALUES
(1, '0.00', '5000.00', '10.00', 1, 0, 1, '2019-01-06 05:45:40', '2019-01-06 05:45:40'),
(2, '5000.00', '20000.00', '25.00', 1, 0, 1, '2019-01-06 05:47:16', '2019-01-06 05:47:16'),
(3, '0.00', '5000.00', '10.00', 2, 0, 1, '2019-01-06 05:49:27', '2019-01-06 05:49:27'),
(4, '50000.00', '20000.00', '25.00', 2, 0, 1, '2019-01-06 05:49:46', '2019-01-06 05:49:46');
-- --------------------------------------------------------
--
-- 表的结构 `files`
--
CREATE TABLE IF NOT EXISTS `files` (
`id` int(10) unsigned NOT NULL,
`tmp` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '原始名字',
`type` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'image' COMMENT '文件类型:image,vedio,pdf,office,zip,rar,other',
`filename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '新文件名',
`screen_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '使用场景',
`size` int(11) NOT NULL DEFAULT 0 COMMENT '文件大小',
`path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '文件路径',
`oss_type` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'local' COMMENT '存储位置',
`user_type` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '上传用户类型:平台|用户',
`user_id` int(10) unsigned NOT NULL COMMENT '所属用户id',
`create_type` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建类型shop为商家，personal为个人开店',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `files`
--
INSERT INTO `files` (`id`, `tmp`, `type`, `filename`, `screen_type`, `size`, `path`, `oss_type`, `user_type`, `user_id`, `create_type`, `created_at`, `updated_at`) VALUES
(1, 'favicon_1502874489186_0cf91d.png', 'image', 'b4965215d313359912465e7af8ff3cc233571.png', NULL, 3, '/upload/images/20191109/b4965215d313359912465e7af8ff3cc233571.png', 'local', 'admin', 1, NULL, '2019-11-09 13:39:55', '2019-11-09 13:39:55'),
(2, '79170650_2.jpg', 'image', '6ed20465fb6c963b5d8324cf637c5a0966943.jpg', NULL, 4, '/upload/images/20191118/6ed20465fb6c963b5d8324cf637c5a0966943.jpg', 'local', 'admin', 1, NULL, '2019-11-18 06:51:47', '2019-11-18 06:51:47'),
(3, 'mmexport1572184856935.jpg', 'image', '70d7fd2e22bfc3d4d0f7a286aaf6f9012304.jpg', NULL, 1515, '/upload/images/20191118/70d7fd2e22bfc3d4d0f7a286aaf6f9012304.jpg', 'local', 'admin', 1, NULL, '2019-11-18 06:56:13', '2019-11-18 06:56:13'),
(4, '79170650_2(1).jpg', 'image', 'a177ec9789d9a76c8fbd91dd2688e65c98040.jpg', NULL, 4, '/upload/images/20191118/a177ec9789d9a76c8fbd91dd2688e65c98040.jpg', 'local', 'admin', 1, NULL, '2019-11-18 06:57:22', '2019-11-18 06:57:22'),
(5, '79170650_4(1).jpg', 'image', '5ff92fe692df8bc078638f95def46a8553397.jpg', NULL, 10, '/upload/images/20191118/5ff92fe692df8bc078638f95def46a8553397.jpg', 'local', 'admin', 1, NULL, '2019-11-18 06:59:08', '2019-11-18 06:59:08'),
(6, 'ia_10001.jpg', 'image', '0cbc438907f2414b458fbd19c8a8516024324.jpg', NULL, 150, '/upload/images/20191123/0cbc438907f2414b458fbd19c8a8516024324.jpg', 'local', 'admin', 1, NULL, '2019-11-23 07:28:22', '2019-11-23 07:28:22'),
(7, 'ia_10007.jpg', 'image', '095fd9a749a6cd3183173d35046b06d722022.jpg', NULL, 184, '/upload/images/20191123/095fd9a749a6cd3183173d35046b06d722022.jpg', 'local', 'admin', 1, NULL, '2019-11-23 07:37:06', '2019-11-23 07:37:06'),
(8, 'dog.jpg', 'image', 'd80e86b8a7c76c8a3a9aca32c9e02b7e82630.jpg', NULL, 18, '/upload/images/20191202/d80e86b8a7c76c8a3a9aca32c9e02b7e82630.jpg', 'local', 'admin', 1, NULL, '2019-12-02 06:06:10', '2019-12-02 06:06:10'),
(9, 'toux.jpg', 'image', '9dd267c071e9eb8f44c138b7ba73574024192.jpg', NULL, 16, '/upload/images/20191207/9dd267c071e9eb8f44c138b7ba73574024192.jpg', 'local', 'admin', 1, NULL, '2019-12-07 02:23:55', '2019-12-07 02:23:55'),
(10, 'logo.jpg', 'image', '6b3fe4064330e8323a57964fcbc63c334761.jpg', NULL, 71, '/upload/images/20191209/6b3fe4064330e8323a57964fcbc63c334761.jpg', 'local', 'admin', 1, NULL, '2019-12-09 05:47:46', '2019-12-09 05:47:46');
-- --------------------------------------------------------
--
-- 表的结构 `gateways`
--
CREATE TABLE IF NOT EXISTS `gateways` (
`id` int(10) unsigned NOT NULL,
`name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '通道名称',
`ename` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '通道标识符',
`app_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '商户id',
`app_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '商户密钥',
`mch_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '商户账号',
`client_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pc' COMMENT '客户端类型',
`cert_pub` varchar(4000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '支付公钥',
`cert_key` varchar(4000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '应用私钥',
`is_dev` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否沙箱',
`ratio` tinyint(4) NOT NULL DEFAULT 6 COMMENT '费率，单位为1000',
`thumb` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`mthumb` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sort` smallint(6) NOT NULL DEFAULT 0 COMMENT '排序',
`is_checked` tinyint(4) NOT NULL DEFAULT 1 COMMENT '通道状态1:启用,0:禁用',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`limit_money` int(11) NOT NULL DEFAULT 45000 COMMENT '支付单笔限额',
`up_ratio` smallint(6) NOT NULL DEFAULT 0 COMMENT '上浮费率',
`is_system_close` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否系统关闭，1表示是，0非',
`deleted_at` timestamp NULL DEFAULT NULL,
`cert_private_type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '私钥证书类型：文本，文件',
`cert_pub_type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '二进制证书',
`username` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '开户人',
`source` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '开户行',
`url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '二维码地址',
`bank_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '所属银行'
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `gateways`
--
INSERT INTO `gateways` (`id`, `name`, `ename`, `app_id`, `app_key`, `mch_id`, `client_type`, `cert_pub`, `cert_key`, `is_dev`, `ratio`, `thumb`, `mthumb`, `sort`, `is_checked`, `created_at`, `updated_at`, `limit_money`, `up_ratio`, `is_system_close`, `deleted_at`, `cert_private_type`, `cert_pub_type`, `username`, `source`, `url`, `bank_name`) VALUES
(2, '沙箱2016092500592678', 'alipay', '2016092500592678', '2016092500592678', '2016092500592678', 'webm', 'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAsqeCr2QNoyGjRHcwo7kW9mH/zOiLchs4epaxtGC2IYoup/ZEKkzW4ybHdh9RTF6UsjavKtoWb0+lZLIDcgbayJ5JEyjYjqfXPCUjYp1tcwuuDIrVg/eJIwfgfcoIIpgMyv94lO/lYeyWbYSP4HXMWVRxY+tucz/7Wz6qkeKxL0QXv8+mHj311cAg82ZX925RgLi5UaY5t0jLrE4dvtSGJPB9SBn7N/bdxH63EaF4uPNWlXGVZNBwv1uE5SXwJswMBtcJuOYAUz3ZehDvITSXtD26XNzteKgq/TiOzVKn6QyvB6js76GIQY6M1/ZDzXzYLLF9a1X5nBr6BnboxCTUqQIDAQAB', 'MIIEoAIBAAKCAQEAuzT9Zzj6ZH1XCVbXHGaMXaOtoXl4FkWlUy25J3C9UDRqzj2jabx3p0ZTY4qdElnrJo7yWZpqdc3oM9nsovoRJChj4MYz3hFYCGg0l3E2oDDAPSVitd9k7QmqofsZmkRBER03ABxznqaG6M51oV9C2ZWvxHOqCnX6n8oc8DgUzqnFO3h/VqE7LZ/cgf9klrO6WfzqkPIaUjKD4sfcnBRMugIxNQels0nE7Wy/BHxZ7Inq3hdOAucTkNdWfARqbN/d52V61ni/PxzirerLDBcHWU5mE3bQYdM0CAbjZjz1cwkkMTVfXMUp6Kr2Pe5SxuhxbNyrsPJ1w0zh8FtxoSBA5wIDAQABAoIBAHgiIRtEbSpfZKMRnykShbDxgFLG6FEikF04UkEFD/eQK5n95AfOcdpePtT59qH4Ifa0dMEbXoYKhKABkOFlJ+rUIIP1rQMsjhmXBWjJtgxGPJcAjr+3g8S5F06rHFrqwfaBkPH5UBjXNGvhUYsk3nlSnWCr+MqNuy8fPELLOk8Dd8+CoY+S1sa/RapXMCndD/hU7Fbv8g34EmMAo6dHgCP9gQaJ2kcVjoXtxy0D8QaNj9CVsTGEOlqGcS8nieetj8cOF3/z3QOKK9dYSa6QlwYN2GgI/sz3Mfzr+8WHD19CDgA9lc7ZwodBHnp/YwZ9f7t4XAV+4aLhhGBuypL1+YECgYEA+NJp9p9TptiCWFhDfLBkrwCmXR8K7iHOGdWTDsU/5p+p/cnXibe9Aq2YRaTRHciDTh3HwDaq5tLQpLBImQ6Mt2INegf7WToCZ+Em1cF3qznmSV8nJ1rDSJOqHC7hV9Dq4uBUKwmGflaBqcadNkfpx+bebAswEDtoBZr49RC8OWkCgYEAwJuKaaJJsZb3KjW7jLuFYQXXeULJdh+tHd7s+/SpZycqio/KYFjznxGjmZgW9u1ZBHyvktGCkSm9MC3aigg7V0mCFgzmHY/9/ufQ20tW0OgCMt/Wdeh+IJtInQkUGUj+eQLk3lkXUIzUxkitmhk3A/Kis48x6v+e4zyUI6H3jc8CgYBMBj5KFDRC7jQlOhKkrmCU9+Xc3fdA+yM10YO1J592n6IY4OryMSmW/+NepBUgvHsiCwdVO17MV+1X5GTKHx/viA4GExpBEPBbPPfYp9wgfPhXwrL720d/jV6Ubd58LmEWIOSWobpuL5A+h2jRhPdxFKEw8dolm4EU9VzLw+k+wQJ/dJ24MD0SYXQGMohWBd+D4jqnO8Q0NlD3gB55XhPEfbA5Eav93Ff/KVCEvXpYbSlHvG/B3iL76uhao9EfgHN7el4HZVJqAXwtTSkOS7hR2CqhKixcrQcXVqauUGYuxSBs8tfNutI2S475RRS8B5E8vicqW41Xq/EZQnxrNSfbuwKBgF2JnjAbhc5FOQnW9xrr68Ywv5ps2XhgPcqWHFzXqFHPzhTtb5DQjUc0B4g1KKMPWgikmcSHut2E2u0hKbtVsEeiC6tsWv6en7aiDKHtnahq3DhKINZ+UI9g0978f8v+ecfnkbsZAP1ThTCCxpCUW2YRlQ6FWOPYE2Xs72gtKkFR', 1, 7, '', NULL, 0, 1, '2019-01-17 06:24:23', '2019-11-18 06:53:44', 45000, 0, 0, NULL, 1, 1, '', '', '', ''),
(3, '固码支付', 'tr_wxalbank', '', '', 'test12346588', 'webm', '', '', 0, 15, '/upload/images/20191118/6ed20465fb6c963b5d8324cf637c5a0966943.jpg', NULL, 0, 0, '2019-11-18 06:52:34', '2019-11-18 06:54:04', 45000, 0, 0, NULL, 1, 1, '空气', '广东深圳', 'http://www.heibaiketang.com', '空气工作室'),
(4, '测试支付宝固码支付', 'tr_alipay', '', '', '531833998@qq.com', 'webm', '', '', 0, 0, '/upload/images/20191118/70d7fd2e22bfc3d4d0f7a286aaf6f9012304.jpg', NULL, 0, 0, '2019-11-18 06:56:36', '2019-11-18 06:56:36', 45000, 0, 0, NULL, 1, 1, '空气', '五', '', '空气测试'),
(5, '微信支付固码测试', 'tr_weixin', '', '', '测试13313161', 'webm', '', '', 0, 18, '/upload/images/20191118/a177ec9789d9a76c8fbd91dd2688e65c98040.jpg', NULL, 0, 0, '2019-11-18 06:57:52', '2019-11-18 06:57:52', 45000, 2, 0, NULL, 1, 1, '空气工作室', '', '', ''),
(6, '微信支付宝二合一固码支付', 'tr_wxal', '', '', '黑白课堂', 'webm', '', '', 0, 20, '/upload/images/20191118/5ff92fe692df8bc078638f95def46a8553397.jpg', NULL, 0, 1, '2019-11-18 06:59:15', '2019-11-18 06:59:15', 45000, 0, 0, NULL, 1, 1, '黑白课堂', '', '', '');
-- --------------------------------------------------------
--
-- 表的结构 `gateway_winds`
--
CREATE TABLE IF NOT EXISTS `gateway_winds` (
`id` int(10) unsigned NOT NULL,
`gateway_id` int(11) NOT NULL COMMENT '通道id',
`amount_total` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '目前交易总额',
`max_total` decimal(10,2) NOT NULL DEFAULT 500000.00 COMMENT '最大交易总额,默认50万',
`day` date NOT NULL COMMENT '交易时间',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`gateway_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '通道名字'
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `gateway_winds`
--
INSERT INTO `gateway_winds` (`id`, `gateway_id`, `amount_total`, `max_total`, `day`, `created_at`, `updated_at`, `deleted_at`, `gateway_name`) VALUES
(1, 2, '0.00', '50000.00', '2019-11-05', '2019-11-09 19:11:22', '2019-11-09 19:11:22', NULL, '沙箱2016092500592678(2016092500592678)'),
(2, 2, '4444.00', '500000.00', '2019-11-21', '2019-11-21 09:20:40', '2019-11-21 09:20:40', NULL, '沙箱2016092500592678(2016092500592678)'),
(3, 2, '2.00', '500000.00', '2019-11-22', '2019-11-22 02:24:47', '2019-11-22 07:27:14', NULL, '沙箱2016092500592678(2016092500592678)'),
(4, 2, '100.00', '500000.00', '2019-11-23', '2019-11-23 15:15:31', '2019-11-23 15:15:31', NULL, '沙箱2016092500592678(2016092500592678)'),
(5, 4, '100.00', '500000.00', '2019-11-23', '2019-11-23 15:15:34', '2019-11-23 15:15:34', NULL, '测试支付宝固码支付(531833998@qq.com)'),
(6, 5, '180.00', '500000.00', '2019-11-24', '2019-11-23 18:43:38', '2019-11-23 18:43:38', NULL, '微信支付固码测试(测试13313161)'),
(7, 2, '1.00', '500000.00', '2019-11-25', '2019-11-25 02:47:32', '2019-11-25 02:47:32', NULL, '沙箱2016092500592678(2016092500592678)'),
(8, 4, '1.00', '500000.00', '2019-11-25', '2019-11-25 13:50:28', '2019-11-25 13:50:28', NULL, '测试支付宝固码支付(531833998@qq.com)'),
(9, 5, '10.00', '500000.00', '2019-11-25', '2019-11-25 14:41:45', '2019-11-25 14:41:45', NULL, '微信支付固码测试(测试13313161)'),
(10, 2, '111.00', '500000.00', '2019-11-26', '2019-11-26 10:46:52', '2019-11-26 10:46:52', NULL, '沙箱2016092500592678(2016092500592678)'),
(11, 2, '212.00', '500000.00', '2019-11-28', '2019-11-27 17:33:23', '2019-11-28 01:45:53', NULL, '沙箱2016092500592678(2016092500592678)'),
(12, 2, '100.00', '500000.00', '2019-11-29', '2019-11-29 06:45:56', '2019-11-29 06:45:56', NULL, '沙箱2016092500592678(2016092500592678)'),
(13, 2, '88.00', '500000.00', '2019-12-02', '2019-12-02 06:01:35', '2019-12-02 06:01:35', NULL, '沙箱2016092500592678(2016092500592678)'),
(14, 3, '100.00', '500000.00', '2019-12-05', '2019-12-04 16:38:35', '2019-12-04 16:38:35', NULL, '固码支付(test12346588)'),
(15, 6, '1.00', '500000.00', '2019-12-08', '2019-12-08 14:23:03', '2019-12-08 14:23:03', NULL, '微信支付宝二合一固码支付(黑白课堂)'),
(16, 2, '1.00', '500000.00', '2019-12-09', '2019-12-09 03:14:14', '2019-12-09 03:14:14', NULL, '沙箱2016092500592678(2016092500592678)'),
(17, 6, '100.00', '500000.00', '2019-12-09', '2019-12-09 05:59:55', '2019-12-09 05:59:55', NULL, '微信支付宝二合一固码支付(黑白课堂)');
-- --------------------------------------------------------
--
-- 表的结构 `goods`
--
CREATE TABLE IF NOT EXISTS `goods` (
`id` int(10) unsigned NOT NULL,
`category_id` int(11) NOT NULL DEFAULT 0 COMMENT '栏目id',
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',
`subname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '副标题',
`server_content` text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '服务内容',
`server_feature` text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '服务特点',
`server_srceen` text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '应用场景',
`server_result` text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '交付结果',
`pay_content` text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收费方式',
`money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '支付价格',
`thumb` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图标',
`intro` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '简介',
`seo_title` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'SEO标题',
`seo_keyword` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'SEO关键词',
`seo_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'SEO描述',
`sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
`is_checked` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态1:启用,0:禁用',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `goods`
--
INSERT INTO `goods` (`id`, `category_id`, `name`, `subname`, `server_content`, `server_feature`, `server_srceen`, `server_result`, `pay_content`, `money`, `thumb`, `intro`, `seo_title`, `seo_keyword`, `seo_description`, `sort`, `is_checked`, `created_at`, `updated_at`) VALUES
(5, 4, '微信应用定制开发', '8亿用户在微信盼你的产品上线', '<p>1、用户需求分析，用户模型设计，角色类型分析等；</p><p>2、业务需求分析，解决方案设计，产品功能模块设计等；</p><p>3、用户界面设计(UI)，用户体验设计(UX)，视觉与交互设计；</p><p>4、页面编写，页面交互与逻辑开发，后台程序与数据开发；</p><p>5、产品功能与性能测试，服务器环境搭建，产品部署等。</p>', '<p>1、专业的PRD产品分析，精准呈现产品需求，量化产品需求；</p><p>2、成熟的微信开发方案，经验丰富的设计开发团队倾情打造；</p><p>3、设计开发流程系统化管理，环环相扣，提升效率，省时省心；</p><p>4、根据业务需求定制开发，升级维护容易，系统拓展便捷。</p>', '<p>1、微信支付，让用户在你的网站直接微信支付，交易更便捷；</p><p>2、微信登录，让用户通过微信授权登录你的网站，方便快捷；</p><p>3、微信扫码，让用户可以扫码完成下单，签到，预约等操作；</p><p>4、微信推送，让用户可以收到你的自定义信息，随时保持沟通；</p><p>5、其它所有基于微信开放接口的场景应用。</p>', '<p>1、系统开发技术文档 (pdf文件)；</p><p>2、用户操作使用手册 (pdf文件)；</p><p>3、系统文件及源代码</p>', '<p>根据功能模块整体评估开发费用。<br></p>', '10000.00', '/upload/images/20181227/c5224906ebc76beabd40d4dce9484e9064751.png', '', NULL, NULL, NULL, 0, 1, '2018-12-27 04:17:02', '2018-12-27 08:02:06'),
(6, 4, '苹果iOSAPP定制开发', '万事俱备, 就差一个APP啦', '<p>1、用户需求分析，用户模型设计，角色类型分析等；</p><p>2、业务需求分析，解决方案设计，产品功能模块设计等；</p><p>3、用户界面设计(UI)，用户体验设计(UX)，视觉与交互设计；</p><p>4、页面编写，页面交互与逻辑开发，后台程序与数据开发；</p><p>5、产品功能与性能测试，产品发布与服务器应用部署等</p>', '<p>1、专业的PRD产品分析，精准呈现产品需求，量化产品需求；</p><p>2、成熟的APP开发方案，经验丰富的设计开发团队倾情打造；</p><p>3、设计开发流程系统化管理，环环相扣，提升效率，省时省心；</p><p>4、根据业务需求定制开发，升级维护容易，系统拓展便捷。</p>', '<p>1、工具类应用，如信息查询，图形图像处理，视频音频播放等；</p><p>2、平台类应用，如任务发布平台，知识交易平台，在线学习平台等；</p><p>3、电商类应用，如B2C商店，分销系统，导购系统，在线商场等；</p><p>4、社交类应用，如图片分享平台，名片分享平台，论坛交友等；</p><p>5、其它所有基于iOS设备和安卓设备的场景应用。</p>', '<p>1、系统开发技术文档 (pdf文件)；</p><p>2、用户操作使用手册 (pdf文件)；</p><p>3、系统文件及源代码</p>', '<p>根据功能模块整体评估开发费用。<br></p>', '20000.00', '/upload/images/20181227/391dd2db779236d9093b27bff3a5dc9117528.png', '', NULL, NULL, NULL, 0, 1, '2018-12-27 04:18:21', '2018-12-27 08:02:14'),
(7, 4, 'CRM客户系统定制开发', '谁说CRM系统只能套用模版', '<p>1、用户需求分析，用户模型设计，角色类型分析等；</p><p>2、产品目标分析，产品定位，产品功能分析与模块设计；</p><p>3、用户界面设计(UI)，用户体验设计(UX)，视觉与交互设计；</p><p>4、页面编写，页面交互与逻辑开发，后台程序与数据开发；</p><p>5、产品功能与性能测试，服务器环境搭建，产品部署等。</p>', '<p>1、专业的PRD产品分析，精准呈现产品需求，不花冤枉钱；</p><p>2、设计开发流程系统化管理，环环相扣，提升效率，省时省心；</p><p>3、成熟的CRM系统方案，经验丰富的设计开发团队倾情打造；</p><p>4、根据业务需求定制开发，不套用模版，升级与拓展便捷。</p>', '<p>1、市面上的CRM系统大而全，很多功能付了钱但用不上；</p><p>2、很多CRM系统设计不符合我的行业，我想要个按需定制的；</p><p>3、买的CRM系统都是封闭的，我们想做二次开发，难度太大；</p><p>4、其它所有需要实现客户系统化管理的应用场景。</p>', '<p>1、系统开发技术文档 (pdf文件)；</p><p>2、用户操作使用手册 (pdf文件)；</p><p>3、系统文件及源代码 (因应用类型而定)；</p>', '<ul style="margin-bottom: 0px; list-style: none; padding-right: 30px; line-height: 26px; color: rgb(153, 153, 153); font-family: &quot;Helvetica Neue&quot;, Helvetica, Tahoma, Arial, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; background-color: rgb(247, 247, 247);"><li>根据功能模块整体评估开发费用。</li></ul>', '8000.00', '/upload/images/20181227/391dd2db779236d9093b27bff3a5dc9176081.png', '', NULL, NULL, NULL, 0, 1, '2018-12-27 04:19:18', '2018-12-27 08:02:27'),
(8, 4, 'B2C电商系统定制开发', '怕被平台束缚，就做自己的平台', '<p>1、用户需求分析，用户模型设计，角色类型分析等；</p><p>2、产品目标分析，产品定位，产品功能分析与模块设计；</p><p>3、用户界面设计(UI)，用户体验设计(UX)，视觉与交互设计；</p><p>4、页面编写，页面交互与逻辑开发，后台程序与数据开发；</p><p>5、产品功能与性能测试，服务器环境搭建，产品部署等。</p>', '<p>1、专业的PRD产品分析，精准呈现产品需求，不花冤枉钱；</p><p>2、设计开发流程系统化管理，环环相扣，提升效率，省时省心；</p><p>3、成熟的电商系统方案，经验丰富的设计开发团队倾情打造；</p><p>4、根据业务需求定制开发，不套用模版，升级与拓展便捷。</p>', '<p>1、不想总在别人的平台上做渠道，想塑造自己的电商品牌；</p><p>2、我们的产品线下销售遇到瓶颈，想拓展线上销售渠道；</p><p>3、买了个开源的电商系统，用户体验不好，升级开发太麻烦，；</p><p>4、其它所有需要搭建自有电商平台的场景。</p>', '<p>1、系统开发技术文档 (pdf文件)；</p><p>2、用户操作使用手册 (pdf文件)；</p><p>3、系统文件及源代码 (因应用类型而定)；</p>', '<p>根据功能模块整体评估开发费用。<br></p>', '7800.00', '/upload/images/20181227/c5224906ebc76beabd40d4dce9484e9068840.png', '', NULL, NULL, NULL, 0, 1, '2018-12-27 04:21:17', '2018-12-27 08:02:41'),
(9, 4, 'WEB前端页面开发', '前端工程师已就位, 请发号施令', '', '', '', '1、系统开发技术文档 (pdf文件)；<br/>\r\n2、用户操作使用手册 (pdf文件)；<br/>\r\n3、系统文件及源代码 (因应用类型而定)；', '根据功能模块整体评估开发费用。', '10.00', '/upload/images/20181227/391dd2db779236d9093b27bff3a5dc9125488.png', '', NULL, NULL, NULL, 0, 1, '2018-12-27 04:22:08', '2018-12-29 04:09:55'),
(10, 4, '用户界面与体验设计', '用更好的设计俘获用户的心', '', '', '', '1、系统开发技术文档 (pdf文件)；<br/>\r\n2、用户操作使用手册 (pdf文件)；<br/>\r\n3、系统文件及源代码 (因应用类型而定)；', '根据功能模块整体评估开发费用。', '3500.00', '/upload/images/20181227/391dd2db779236d9093b27bff3a5dc9192780.png', '', NULL, NULL, NULL, 0, 1, '2018-12-27 04:22:31', '2018-12-27 08:03:01');
-- --------------------------------------------------------
--
-- 表的结构 `hande_do_logs`
--
CREATE TABLE IF NOT EXISTS `hande_do_logs` (
`id` int(10) unsigned NOT NULL,
`model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '类型',
`model_id` int(11) NOT NULL COMMENT '类型ID',
`do_value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '操作标识值',
`data` varchar(2000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '数据包',
`do_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '操作人',
`do_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '操作人类型',
`do_id` int(11) DEFAULT NULL COMMENT '操作人id',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `merchants`
--
CREATE TABLE IF NOT EXISTS `merchants` (
`id` int(10) unsigned NOT NULL,
`sort` smallint(6) NOT NULL DEFAULT 0 COMMENT '排序',
`next_ratio` smallint(6) NOT NULL DEFAULT 0 COMMENT '上级结算佣金，如果为空，则没有上级佣金',
`origin_password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '原始密码',
`password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '密码',
`name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '接口商名字',
`ip` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'ip',
`host` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '域名',
`app_key` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '密钥',
`token` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'token',
`draw_type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '提现到账类型,1=T+0,2=T+1,3...',
`min_money` int(11) NOT NULL DEFAULT 0 COMMENT '最低提款金额',
`realname` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '真实姓名',
`idcard` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '身份证号码',
`address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '地址',
`email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮箱',
`mobile` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '手机',
`ratio` smallint(6) NOT NULL DEFAULT 10 COMMENT '总费率',
`qq` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'qq',
`is_proxy` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否代理1:是,0:否',
`from_id` int(11) NOT NULL DEFAULT 0 COMMENT '上级id',
`is_checked` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态1:启用,0:禁用',
`login_status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '登陆状态:1启用，0禁用',
`last_number` int(11) NOT NULL DEFAULT 0 COMMENT '登陆次数',
`login_ip` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '127.0.0.1' COMMENT '登陆IP',
`last_time` datetime DEFAULT NULL COMMENT '最后登陆时间',
`remember_token` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '记录登陆',
`check_status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '申请审核',
`check_at` datetime DEFAULT NULL COMMENT '审核通过时间',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`level` tinyint(4) NOT NULL COMMENT '等级类型：股东是1,代理是2，商户是3',
`gateways_id` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '使用通道列表',
`max_price` int(11) NOT NULL DEFAULT 45000 COMMENT '单笔最大金额',
`min_price` int(11) NOT NULL DEFAULT 1 COMMENT '单笔最小金额',
`draw_day_money_ratio` smallint(6) NOT NULL DEFAULT -1 COMMENT '每天押款比例',
`from_regist` tinyint(4) NOT NULL DEFAULT 1 COMMENT '注册来源，1是系统注册',
`skype` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'skype'
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `merchants`
--
INSERT INTO `merchants` (`id`, `sort`, `next_ratio`, `origin_password`, `password`, `name`, `ip`, `host`, `app_key`, `token`, `draw_type`, `min_money`, `realname`, `idcard`, `address`, `email`, `mobile`, `ratio`, `qq`, `is_proxy`, `from_id`, `is_checked`, `login_status`, `last_number`, `login_ip`, `last_time`, `remember_token`, `check_status`, `check_at`, `created_at`, `updated_at`, `deleted_at`, `level`, `gateways_id`, `max_price`, `min_price`, `draw_day_money_ratio`, `from_regist`, `skype`) VALUES
(10, 0, 0, '123456', '$2y$10$UnfcgtTx0Sio/tMPotSq1.xeMopJvGV.b231lEys3LNxOqjf7BgqO', '大股东A', '', '', '20190301114921twArPT', 'WxWSJTbo6kA0SfoVTguxzcoCCGVWlrGu', 1, 0, '', NULL, '', '1551411757@qq.com', '', 20, '', 0, 0, 1, 1, 1, '127.0.0.1', '2019-03-02 18:11:03', '6kZEkPPZM7oiw4BhriiGwtM7lVBjvOzhcyR1qe8BvYx54nr4g5iiVFj23WeY', 1, NULL, '2019-03-01 03:49:21', '2019-03-02 10:11:03', NULL, 1, '0', 45000, 1, -1, 1, NULL),
(11, 0, 0, '123456', '$2y$10$4SGafWyUjpUzuA8CI.fo0uhdd/MC/aqDHrM5kEY2CtbHwsA5.UYd6', '大股东B', '103.89.179.146', '', '20190301114947VeflUS', 'SznzD5dGdSxe9J9jHyIoRmRbeytDykrV', 0, 0, '', NULL, '', '1551412165@qq.com', '', 30, '', 0, 0, 1, 1, 3, '127.0.0.1', '2019-12-09 13:44:32', 'QzBshEtp4KJ606YMQcSRXnUI4mbha7vEVgtTEYfLnXpHkh7tQFJBBHkYGXap', 1, NULL, '2019-03-01 03:49:47', '2019-12-09 05:44:32', NULL, 1, '0', 45000, 1, -1, 1, NULL),
(12, 0, 0, '1551412192', '$2y$10$apBdpcZTR8tJRxQoOSS7dukHeGEInzeKcDy54Yl1KwqpwZtwREUIi', '大股东B->商户b1', '', '', '20190301115025Nuy2Gs', 'ypzF3CBshRuCzVpS0p5Z7Sa6tcG7jzDh', 0, 0, '', NULL, '', '1551412192@qq.com', '', 40, '', 0, 11, 1, 1, 0, '127.0.0.1', NULL, NULL, 1, NULL, '2019-03-01 03:50:25', '2019-03-01 03:50:25', NULL, 3, '0', 45000, 1, -1, 1, NULL),
(13, 0, 20, '1551412229', '$2y$10$2udrJJrpTFxJC1.BnWMmHu3T2NFowWvllimam03iVMopEdOo3HShG', '大股东B的代理B1', '', '', '20190301115051YMBtuG', 'gCxIryld0QB0b48NPFicycu1y9B7YVLg', 0, 0, '', NULL, '', 'dsdfs', '', 50, '', 0, 10, 1, 1, 0, '127.0.0.1', NULL, NULL, 1, NULL, '2019-03-01 03:50:51', '2019-12-01 15:03:19', NULL, 2, '0', 45000, 1, -1, 1, NULL),
(14, 0, 50, '111111', '$2y$10$wUVnDjnLkrGkKXg.YVfPdeZ7PYzqBp5oE9lLk3gZhQf6yEwYGnS1y', '大股东B的代理B1的商户b2', '', '', '20190301115132dkQMhx', 's9RWhDqahUMugvaoq2gr9YtnwipNdFHS', 0, 0, '大股东B的代理B1', NULL, '', '1551412256@qq.com', '', 60, '', 0, 13, 1, 1, 1, '127.0.0.1', '2019-03-02 18:09:13', 'e8utg2BP0nxDg9RWSWY16FQhNEJcXlfewWqMTrJgotRsO4yLodb0O0iw31Fh', 1, NULL, '2019-03-01 03:51:32', '2019-03-02 10:09:13', NULL, 3, '0', 45000, 1, -1, 1, NULL),
(15, 0, 30, '6666666', '$2y$10$4EGFqZAIBHNb39qVl.ruzOBlJ0wNKokp9aQNU27169uol7RsBIBvC', '66', '', '', '20191122153543otlofI', 'w5aM2fzznj82H9c8e4brMj73vWRwEUY6', 0, 0, NULL, NULL, '', '66', '', 66, '', 0, 11, 1, 1, 0, '127.0.0.1', NULL, NULL, 1, NULL, '2019-11-22 07:35:44', '2019-11-22 07:35:44', NULL, 2, '0', 45000, 1, -1, 1, NULL),
(16, 0, 0, 'tttttt', '$2y$10$ZkHY1dY4FIbTXYTeiKpEi.bkN.L/2ZlbwqkFNyeSAyfN0BUeyiY2G', 'tttt', '', '', '2019112215574912DkX5', 'KX8ySnaZqUmrStaCmCbImLo5Vu7nLR3b', 0, 0, NULL, NULL, '', 'ttt', '', 4000, '', 0, 0, 1, 1, 0, '127.0.0.1', NULL, NULL, 1, NULL, '2019-11-22 07:57:49', '2019-11-28 18:39:00', NULL, 2, '0', 45000, 1, -1, 1, NULL),
(17, 0, 0, '66666666', '$2y$10$dtmwrZ2KRL.ftHXRSICvd.8Tz9Rkwh.hq1sza6AfkUmRWYiGdl8fC', '6666666', '', '', '20191122155845A0Bayt', 'zDqeo1qiRupcenPfmaE3G9p31woPX0I5', 0, 0, NULL, NULL, '', '666', '', 6, '', 0, 0, 1, 1, 0, '127.0.0.1', NULL, NULL, 1, NULL, '2019-11-22 07:58:45', '2019-11-28 18:39:23', '2019-12-03 02:24:04', 3, '0', 45000, 1, -1, 1, NULL),
(18, 0, 20, 'sdfasSDFS', '$2y$10$CBOi3P6hGfUYiM.2PK8plOQiHbV6aAwjU6o.igDZuR98vQ80Svnga', 'P1', '', '', '20191201230415JUnjZA', '6zGIfo4RHVgzEdkzNuk6o3CzH1SOFQae', 0, 0, NULL, NULL, '', 'sdfads', '', 30, '', 0, 10, 1, 1, 0, '127.0.0.1', NULL, NULL, 1, NULL, '2019-12-01 15:04:15', '2019-12-01 15:06:24', NULL, 2, '0', 45000, 1, -1, 1, NULL),
(19, 0, 30, '123456', '$2y$10$b5nX12SAbVfRE4nLVFDmte4fevUFF3G1JPeNvoL0.2vnRTJyG0ite', 'P2', '', '', '20191201230518LOxC7X', 'yMwyuXDpdt7D5qk38bM7NTKbSiQAqJbf', 0, 0, NULL, NULL, '', '123@163.com', '', 31, '', 0, 18, 1, 1, 0, '127.0.0.1', NULL, NULL, 1, NULL, '2019-12-01 15:05:18', '2019-12-02 03:46:23', NULL, 3, '0', 45000, 1, -1, 1, NULL);
-- --------------------------------------------------------
--
-- 表的结构 `merchant_commissions`
--
CREATE TABLE IF NOT EXISTS `merchant_commissions` (
`id` int(10) unsigned NOT NULL,
`merchant_id` int(11) NOT NULL COMMENT '订单商户id',
`from_merchant_id` int(11) NOT NULL COMMENT '上级商户id',
`gateway_id` int(11) NOT NULL COMMENT '通道id',
`order_id` int(10) unsigned NOT NULL COMMENT '订单ID',
`order_sn` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '订单号',
`order_money` decimal(8,2) NOT NULL COMMENT '订单价格',
`pay_money` decimal(8,2) NOT NULL COMMENT '支付价格',
`ratio` int(11) NOT NULL DEFAULT 6 COMMENT '佣金比率：代理比例-平台比例',
`money` decimal(8,2) NOT NULL COMMENT '佣金',
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '佣金来源描述',
`order_at` datetime DEFAULT NULL COMMENT '下单时间',
`pay_ok_at` datetime DEFAULT NULL COMMENT '支付成功时间',
`data` varchar(5000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '其他信息',
`status` tinyint(4) NOT NULL DEFAULT 2 COMMENT '佣金状态:1交易成功,2处理中,3交易失败',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`success_at` datetime DEFAULT NULL COMMENT '成功结算时间',
`admin_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '结算人',
`admin_id` int(11) DEFAULT NULL COMMENT '结算人ID'
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `merchant_commissions`
--
INSERT INTO `merchant_commissions` (`id`, `merchant_id`, `from_merchant_id`, `gateway_id`, `order_id`, `order_sn`, `order_money`, `pay_money`, `ratio`, `money`, `name`, `order_at`, `pay_ok_at`, `data`, `status`, `created_at`, `updated_at`, `success_at`, `admin_name`, `admin_id`) VALUES
(1, 13, 11, 2, 5, '20191121172019937449', '4444.00', '4444.00', 20, '88.88', '大股东B的代理B1的订单佣金', '2019-11-21 17:20:19', '2019-11-21 17:20:40', NULL, 1, '2019-11-21 09:20:40', '2019-11-21 10:17:56', NULL, NULL, NULL),
(2, 13, 11, 2, 10, '20191122100405726528', '1.00', '1.00', 20, '0.02', '大股东B的代理B1的订单佣金', '2019-11-22 10:04:05', '2019-11-22 10:24:43', NULL, 1, '2019-11-22 02:24:47', '2019-11-22 02:53:44', NULL, NULL, NULL),
(3, 13, 11, 2, 12, '20191122152602853111', '1.00', '1.00', 20, '0.02', '大股东B的代理B1的订单佣金', '2019-11-22 15:26:02', '2019-11-22 15:27:11', NULL, 1, '2019-11-22 07:27:14', '2019-11-22 07:32:49', NULL, NULL, NULL),
(4, 13, 11, 2, 22, '20191123200550973265', '100.00', '100.00', 20, '2.00', '大股东B的代理B1的订单佣金', '2019-11-23 20:05:50', '2019-11-23 23:15:28', NULL, 1, '2019-11-23 15:15:31', '2019-11-23 16:14:06', NULL, NULL, NULL),
(5, 13, 11, 4, 23, '20191123200837327969', '100.00', '100.00', 20, '2.00', '大股东B的代理B1的订单佣金', '2019-11-23 20:08:37', '2019-11-23 23:15:33', NULL, 1, '2019-11-23 15:15:34', '2019-11-23 16:14:06', NULL, NULL, NULL),
(6, 13, 11, 5, 24, '20191124001501199969', '180.00', '180.00', 20, '3.60', '大股东B的代理B1的订单佣金', '2019-11-24 00:15:01', '2019-11-24 02:43:34', NULL, 1, '2019-11-23 18:43:37', '2019-11-23 19:20:16', NULL, NULL, NULL),
(7, 13, 11, 2, 30, '20191125093902915363', '1.00', '1.00', 20, '0.02', '大股东B的代理B1的订单佣金', '2019-11-25 09:39:02', '2019-11-25 10:47:30', NULL, 1, '2019-11-25 02:47:32', '2019-11-25 02:49:24', NULL, NULL, NULL),
(8, 13, 11, 4, 36, '20191125205316781590', '1.00', '1.00', 20, '0.02', '大股东B的代理B1的订单佣金', '2019-11-25 20:53:16', '2019-11-25 21:50:27', NULL, 1, '2019-11-25 13:50:28', '2019-11-25 14:38:56', NULL, NULL, NULL),
(9, 13, 11, 5, 39, '20191125223713800497', '10.00', '10.00', 20, '0.20', '大股东B的代理B1的订单佣金', '2019-11-25 22:37:13', '2019-11-25 22:41:36', NULL, 1, '2019-11-25 14:41:45', '2019-11-25 15:14:02', NULL, NULL, NULL),
(10, 13, 11, 2, 43, '20191126184148839412', '111.00', '111.00', 20, '2.22', '大股东B的代理B1的订单佣金', '2019-11-26 18:41:48', '2019-11-26 18:46:47', NULL, 1, '2019-11-26 10:46:51', '2019-11-26 11:14:37', NULL, NULL, NULL),
(11, 13, 11, 2, 50, '20191128002218948241', '100.00', '100.00', 20, '2.00', '大股东B的代理B1的订单佣金', '2019-11-28 00:22:18', '2019-11-28 01:33:21', NULL, 1, '2019-11-27 17:33:23', '2019-11-28 01:08:18', NULL, NULL, NULL),
(12, 13, 11, 2, 54, '20191128094308132171', '111.00', '111.00', 20, '2.22', '大股东B的代理B1的订单佣金', '2019-11-28 09:43:08', '2019-11-28 09:45:39', NULL, 1, '2019-11-28 01:45:45', '2019-11-28 02:38:57', NULL, NULL, NULL),
(13, 13, 11, 2, 53, '20191128093944740209', '1.00', '1.00', 20, '0.02', '大股东B的代理B1的订单佣金', '2019-11-28 09:39:44', '2019-11-28 09:45:52', NULL, 1, '2019-11-28 01:45:53', '2019-11-28 02:38:57', NULL, NULL, NULL),
(14, 13, 11, 2, 58, '20191129144130425607', '100.00', '100.00', 20, '2.00', '大股东B的代理B1的订单佣金', '2019-11-29 14:41:30', '2019-11-29 14:45:53', NULL, 1, '2019-11-29 06:45:55', '2019-11-29 07:31:23', NULL, NULL, NULL),
(15, 13, 10, 2, 64, '20191202140017602666', '88.00', '88.00', 30, '2.64', '大股东B的代理B1的订单佣金', '2019-12-02 14:00:17', '2019-12-02 14:01:35', NULL, 1, '2019-12-02 06:01:35', '2019-12-02 06:05:17', NULL, NULL, NULL),
(16, 13, 10, 3, 73, '20191205003737602899', '100.00', '100.00', 30, '3.00', '大股东B的代理B1的订单佣金', '2019-12-05 00:37:37', '2019-12-05 00:38:34', NULL, 1, '2019-12-04 16:38:35', '2019-12-05 03:36:23', NULL, NULL, NULL),
(17, 13, 10, 6, 82, '20191208222122749556', '1.00', '1.00', 30, '0.03', '大股东B的代理B1的订单佣金', '2019-12-08 22:21:22', '2019-12-08 22:23:00', NULL, 1, '2019-12-08 14:23:02', '2019-12-09 01:20:43', NULL, NULL, NULL),
(18, 13, 10, 2, 86, '20191209111335403428', '1.00', '1.00', 30, '0.03', '大股东B的代理B1的订单佣金', '2019-12-09 11:13:35', '2019-12-09 11:14:11', NULL, 1, '2019-12-09 03:14:14', '2019-12-09 03:15:05', NULL, NULL, NULL),
(19, 13, 10, 6, 89, '20191209135652138318', '100.00', '100.00', 30, '3.00', '大股东B的代理B1的订单佣金', '2019-12-09 13:56:52', '2019-12-09 13:57:35', NULL, 1, '2019-12-09 05:59:55', '2019-12-09 06:42:26', NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- 表的结构 `merchant_logs`
--
CREATE TABLE IF NOT EXISTS `merchant_logs` (
`id` int(10) unsigned NOT NULL,
`merchant_id` int(10) unsigned NOT NULL COMMENT 'merchant_id',
`desc` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '日志描述',
`ip` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'IP地址',
`url` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '操作地址',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `merchant_logs`
--
INSERT INTO `merchant_logs` (`id`, `merchant_id`, `desc`, `ip`, `url`, `created_at`, `updated_at`) VALUES
(1, 11, '注册推广ID:1,创建成功', '120.235.126.92', 'agent/admin/merchantregisttoken', '2019-12-09 05:46:18', '2019-12-09 05:46:18');
-- --------------------------------------------------------
--
-- 表的结构 `merchant_money_logs`
--
CREATE TABLE IF NOT EXISTS `merchant_money_logs` (
`id` int(10) unsigned NOT NULL,
`merchant_id` int(11) NOT NULL COMMENT '商户id',
`order_id` int(11) NOT NULL DEFAULT 0 COMMENT '来源订单',
`pay_at` datetime DEFAULT NULL COMMENT '支付时间',
`order_at` datetime DEFAULT NULL COMMENT '订单时间',
`before_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '变动之前金额',
`after_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '变动之后金额',
`type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1' COMMENT '资金变动类型1:交易，2：加减款',
`money` decimal(8,2) NOT NULL COMMENT '金额',
`mark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`order_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'order' COMMENT '1'
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `merchant_money_logs`
--
INSERT INTO `merchant_money_logs` (`id`, `merchant_id`, `order_id`, `pay_at`, `order_at`, `before_money`, `after_money`, `type`, `money`, `mark`, `created_at`, `updated_at`, `order_type`) VALUES
(1, 13, 5, '2019-11-21 17:20:40', '2019-11-21 17:20:19', '0.00', '4221.80', '1', '4221.80', '支付宝电脑支付', '2019-11-21 09:20:40', NULL, 'order'),
(2, 11, 1, '2019-11-21 17:20:40', '2019-11-21 17:20:19', '0.00', '88.88', '4', '88.88', '代理结算佣金', '2019-11-21 10:17:56', NULL, 'merchant_commission'),
(3, 13, 10, '2019-11-22 10:24:43', '2019-11-22 10:04:05', '4221.80', '0.95', '1', '4222.75', '微信支付电脑支付', '2019-11-22 02:24:47', NULL, 'order'),
(4, 11, 2, '2019-11-22 10:24:43', '2019-11-22 10:04:05', '88.88', '0.02', '4', '88.90', '代理结算佣金', '2019-11-22 02:53:44', NULL, 'merchant_commission'),
(5, 13, 12, '2019-11-22 15:27:11', '2019-11-22 15:26:02', '4222.75', '0.95', '1', '4223.70', '支付宝电脑支付', '2019-11-22 07:27:14', NULL, 'order'),
(6, 11, 3, '2019-11-22 15:27:11', '2019-11-22 15:26:02', '88.90', '0.02', '4', '88.92', '代理结算佣金', '2019-11-22 07:32:49', NULL, 'merchant_commission'),
(7, 13, 22, '2019-11-23 23:15:28', '2019-11-23 20:05:50', '4223.70', '95.00', '1', '4318.70', '支付宝电脑支付', '2019-11-23 15:15:31', NULL, 'order'),
(8, 13, 23, '2019-11-23 23:15:33', '2019-11-23 20:08:37', '4318.70', '95.00', '1', '4413.70', '固码支付宝收款电脑支付', '2019-11-23 15:15:34', NULL, 'order'),
(9, 11, 4, '2019-11-23 23:15:28', '2019-11-23 20:05:50', '88.92', '2.00', '4', '90.92', '代理结算佣金', '2019-11-23 16:14:06', NULL, 'merchant_commission'),
(10, 11, 5, '2019-11-23 23:15:33', '2019-11-23 20:08:37', '90.92', '2.00', '4', '92.92', '代理结算佣金', '2019-11-23 16:14:06', NULL, 'merchant_commission'),
(11, 13, 24, '2019-11-24 02:43:34', '2019-11-24 00:15:01', '4413.70', '170.64', '1', '4584.34', '固码微信收款手机端支付', '2019-11-23 18:43:37', NULL, 'order'),
(12, 11, 6, '2019-11-24 02:43:34', '2019-11-24 00:15:01', '92.92', '3.60', '4', '96.52', '代理结算佣金', '2019-11-23 19:20:16', NULL, 'merchant_commission'),
(13, 13, 30, '2019-11-25 10:47:30', '2019-11-25 09:39:02', '4584.34', '0.95', '1', '4585.29', '支付宝电脑支付', '2019-11-25 02:47:32', NULL, 'order'),
(14, 11, 7, '2019-11-25 10:47:30', '2019-11-25 09:39:02', '96.52', '0.02', '4', '96.54', '代理结算佣金', '2019-11-25 02:49:24', NULL, 'merchant_commission'),
(15, 13, 36, '2019-11-25 21:50:27', '2019-11-25 20:53:16', '4585.29', '0.95', '1', '4586.24', '固码支付宝收款手机端支付', '2019-11-25 13:50:28', NULL, 'order'),
(16, 11, 8, '2019-11-25 21:50:27', '2019-11-25 20:53:16', '96.54', '0.02', '4', '96.56', '代理结算佣金', '2019-11-25 14:38:56', NULL, 'merchant_commission'),
(17, 13, 39, '2019-11-25 22:41:36', '2019-11-25 22:37:13', '4586.24', '9.48', '1', '4595.72', '固码微信收款手机端支付', '2019-11-25 14:41:45', NULL, 'order'),
(18, 11, 9, '2019-11-25 22:41:36', '2019-11-25 22:37:13', '96.56', '0.20', '4', '96.76', '代理结算佣金', '2019-11-25 15:14:02', NULL, 'merchant_commission'),
(19, 13, 43, '2019-11-26 18:46:47', '2019-11-26 18:41:48', '4595.72', '105.45', '1', '4701.17', '银联支付电脑支付', '2019-11-26 10:46:51', NULL, 'order'),
(20, 11, 10, '2019-11-26 18:46:47', '2019-11-26 18:41:48', '96.76', '2.22', '4', '98.98', '代理结算佣金', '2019-11-26 11:14:37', NULL, 'merchant_commission'),
(21, 13, 50, '2019-11-28 01:33:21', '2019-11-28 00:22:18', '4701.17', '95.00', '1', '4796.17', '支付宝电脑支付', '2019-11-27 17:33:23', NULL, 'order'),
(22, 11, 11, '2019-11-28 01:33:21', '2019-11-28 00:22:18', '98.98', '2.00', '4', '100.98', '代理结算佣金', '2019-11-28 01:08:18', NULL, 'merchant_commission'),
(23, 13, 54, '2019-11-28 09:45:39', '2019-11-28 09:43:08', '4796.17', '105.45', '1', '4901.62', '支付宝电脑支付', '2019-11-28 01:45:45', NULL, 'order'),
(24, 13, 53, '2019-11-28 09:45:52', '2019-11-28 09:39:44', '4901.62', '0.95', '1', '4902.57', '支付宝电脑支付', '2019-11-28 01:45:53', NULL, 'order'),
(25, 11, 12, '2019-11-28 09:45:39', '2019-11-28 09:43:08', '100.98', '2.22', '4', '103.20', '代理结算佣金', '2019-11-28 02:38:57', NULL, 'merchant_commission'),
(26, 11, 13, '2019-11-28 09:45:52', '2019-11-28 09:39:44', '103.20', '0.02', '4', '103.22', '代理结算佣金', '2019-11-28 02:38:57', NULL, 'merchant_commission'),
(27, 13, 58, '2019-11-29 14:45:53', '2019-11-29 14:41:30', '4902.57', '95.00', '1', '4997.57', '支付宝电脑支付', '2019-11-29 06:45:55', NULL, 'order'),
(28, 11, 14, '2019-11-29 14:45:53', '2019-11-29 14:41:30', '103.22', '2.00', '4', '105.22', '代理结算佣金', '2019-11-29 07:31:23', NULL, 'merchant_commission'),
(29, 13, 64, '2019-12-02 14:01:35', '2019-12-02 14:00:17', '4997.57', '83.60', '1', '5081.17', '支付宝电脑支付', '2019-12-02 06:01:35', NULL, 'order'),
(30, 10, 15, '2019-12-02 14:01:35', '2019-12-02 14:00:17', '0.00', '2.64', '4', '2.64', '代理结算佣金', '2019-12-02 06:05:17', NULL, 'merchant_commission'),
(31, 13, 73, '2019-12-05 00:38:34', '2019-12-05 00:37:37', '5081.17', '95.00', '1', '5176.17', '固码多合一电脑支付', '2019-12-04 16:38:35', NULL, 'order'),
(32, 10, 16, '2019-12-05 00:38:34', '2019-12-05 00:37:37', '2.64', '3.00', '4', '5.64', '代理结算佣金', '2019-12-05 03:36:23', NULL, 'merchant_commission'),
(33, 13, 82, '2019-12-08 22:23:00', '2019-12-08 22:21:22', '5176.17', '0.95', '1', '5177.12', '固码微信支付宝二合一电脑支付', '2019-12-08 14:23:02', NULL, 'order'),
(34, 10, 17, '2019-12-08 22:23:00', '2019-12-08 22:21:22', '5.64', '0.03', '4', '5.67', '代理结算佣金', '2019-12-09 01:20:43', NULL, 'merchant_commission'),
(35, 13, 86, '2019-12-09 11:14:11', '2019-12-09 11:13:35', '5177.12', '0.95', '1', '5178.07', '银行转账收款电脑支付', '2019-12-09 03:14:14', NULL, 'order'),
(36, 10, 18, '2019-12-09 11:14:11', '2019-12-09 11:13:35', '5.67', '0.03', '4', '5.70', '代理结算佣金', '2019-12-09 03:15:05', NULL, 'merchant_commission'),
(37, 13, 89, '2019-12-09 13:57:35', '2019-12-09 13:56:52', '5178.07', '95.00', '1', '5273.07', '固码微信支付宝二合一电脑支付', '2019-12-09 05:59:55', NULL, 'order'),
(38, 10, 19, '2019-12-09 13:57:35', '2019-12-09 13:56:52', '5.70', '3.00', '4', '8.70', '代理结算佣金', '2019-12-09 06:42:26', NULL, 'merchant_commission');
-- --------------------------------------------------------
--
-- 表的结构 `merchant_orders`
--
CREATE TABLE IF NOT EXISTS `merchant_orders` (
`id` int(10) unsigned NOT NULL,
`order_sn` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '订单号',
`pay_order_sn` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '支付流水号',
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '订单名称',
`money` decimal(14,2) NOT NULL COMMENT '订单金额',
`pay_money` decimal(14,2) NOT NULL,
`model_type` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '订单来源',
`model_id` int(11) NOT NULL COMMENT '来源订单ID',
`from_merchant_id` int(11) NOT NULL DEFAULT 0 COMMENT '商户id',
`merchant_id` int(11) NOT NULL DEFAULT 0 COMMENT '商户id',
`status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '订单状态',
`pay_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '支付状态',
`notify_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '支付回调成功',
`order_data` varchar(5000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '订单数据',
`gateway_id` int(11) NOT NULL DEFAULT 0 COMMENT '通道id',
`gateway_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '通道支付类型',
`gateway_method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '通道支付方法',
`gateway_data` text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '通道数据',
`merchant_money` decimal(14,2) NOT NULL DEFAULT 0.00 COMMENT '商户获得佣金',
`system_money` decimal(14,2) NOT NULL DEFAULT 0.00 COMMENT '系统获得金额',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `merchant_ratios`
--
CREATE TABLE IF NOT EXISTS `merchant_ratios` (
`id` int(10) unsigned NOT NULL,
`level` tinyint(4) NOT NULL DEFAULT 1 COMMENT '身份等级：股东，代理，商户',
`hierarchy` tinyint(4) NOT NULL DEFAULT 1 COMMENT '层级1,2,3',
`parent_id` int(11) NOT NULL COMMENT '商户上级id',
`merchant_id` int(11) NOT NULL COMMENT '商户id',
`ratio` smallint(6) NOT NULL DEFAULT 10 COMMENT '费率',
`is_self` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否是自己',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `merchant_ratios`
--
INSERT INTO `merchant_ratios` (`id`, `level`, `hierarchy`, `parent_id`, `merchant_id`, `ratio`, `is_self`, `created_at`, `updated_at`) VALUES
(3, 3, 2, 11, 12, 40, 1, NULL, NULL),
(7, 3, 2, 13, 14, 60, 1, NULL, NULL),
(8, 1, 1, 0, 10, 20, 1, NULL, NULL),
(9, 1, 1, 0, 11, 30, 1, NULL, NULL),
(10, 2, 2, 11, 15, 66, 1, NULL, NULL),
(13, 2, 1, 0, 16, 4000, 1, NULL, NULL),
(14, 3, 1, 0, 17, 6, 1, NULL, NULL),
(15, 2, 2, 10, 13, 50, 1, NULL, NULL),
(18, 2, 2, 10, 18, 30, 1, NULL, NULL),
(21, 3, 3, 10, 19, 31, 0, NULL, NULL),
(22, 3, 2, 18, 19, 31, 1, NULL, NULL);
-- --------------------------------------------------------
--
-- 表的结构 `merchant_regists`
--
CREATE TABLE IF NOT EXISTS `merchant_regists` (
`id` int(10) unsigned NOT NULL,
`from_merchant_id` int(11) NOT NULL COMMENT '商户id',
`token_id` int(11) NOT NULL COMMENT '注册token表id',
`pay_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '支付状态',
`status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '审核状态',
`merchant_id` int(11) NOT NULL DEFAULT 0 COMMENT '注册成功后的商户ID',
`email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '注册邮箱',
`password` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '注册密码',
`mobile` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '手机号码',
`qq` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'qq',
`skype` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '手机号码',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`money` decimal(8,2) NOT NULL DEFAULT 0.00 COMMENT '价格',
`ratio` smallint(6) NOT NULL DEFAULT 0 COMMENT '费率',
`level` tinyint(4) NOT NULL COMMENT '生成级别：3：商户，2代理',
`type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '类型:默认注册费用1，2费率增加'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `merchant_regist_tokens`
--
CREATE TABLE IF NOT EXISTS `merchant_regist_tokens` (
`id` int(10) unsigned NOT NULL,
`type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '类型:默认注册费用1，2费率增加',
`merchant_id` int(11) NOT NULL COMMENT '商户id',
`regist_token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '注册token',
`level` tinyint(4) NOT NULL COMMENT '生成级别：3：商户，2代理',
`money` decimal(8,2) NOT NULL DEFAULT 0.00 COMMENT '价格',
`ratio` smallint(6) NOT NULL DEFAULT 0 COMMENT '费率',
`is_checked` tinyint(4) NOT NULL DEFAULT 1,
`regist_number` int(11) NOT NULL DEFAULT 0 COMMENT '注册人数',
`click_number` int(11) NOT NULL DEFAULT 0 COMMENT '点击人数',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `merchant_regist_tokens`
--
INSERT INTO `merchant_regist_tokens` (`id`, `type`, `merchant_id`, `regist_token`, `level`, `money`, `ratio`, `is_checked`, `regist_number`, `click_number`, `created_at`, `updated_at`) VALUES
(1, 1, 11, '20191209134618hQEVfLJIX60Uf1obDDXN', 3, '1000.00', 40, 1, 0, 0, '2019-12-09 05:46:18', '2019-12-09 05:46:18');
-- --------------------------------------------------------
--
-- 表的结构 `merchant_wallets`
--
CREATE TABLE IF NOT EXISTS `merchant_wallets` (
`id` int(10) unsigned NOT NULL,
`merchant_id` int(11) NOT NULL COMMENT '商户id',
`money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '账号余额',
`total_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '资金总额',
`draw_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '提现总额',
`other_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '加减款总额',
`trans_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '交易总额',
`trans_ok_number` int(11) NOT NULL DEFAULT 0 COMMENT '交易成功笔数',
`trans_fail_number` int(11) NOT NULL DEFAULT 0 COMMENT '交易失败笔数',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`commission_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '获得推广总额',
`pay_fail_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '未支付总额'
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `merchant_wallets`
--
INSERT INTO `merchant_wallets` (`id`, `merchant_id`, `money`, `total_money`, `draw_money`, `other_money`, `trans_money`, `trans_ok_number`, `trans_fail_number`, `created_at`, `updated_at`, `commission_money`, `pay_fail_money`) VALUES
(8, 10, '8.70', '0.00', '0.00', '0.00', '0.00', 0, 0, '2019-03-01 03:49:21', '2019-12-09 06:42:26', '8.70', '0.00'),
(9, 11, '105.22', '0.00', '0.00', '0.00', '0.00', 0, 0, '2019-03-01 03:49:47', '2019-12-09 05:46:11', '105.22', '0.00'),
(10, 12, '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, '2019-03-01 03:50:25', '2019-03-01 03:50:25', '0.00', '0.00'),
(11, 13, '5273.07', '5273.07', '0.00', '0.00', '5273.07', 5273, 0, '2019-03-01 03:50:51', '2019-12-09 05:59:55', '0.00', '0.00'),
(12, 14, '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, '2019-03-01 03:51:32', '2019-03-02 10:09:17', '0.00', '0.00'),
(13, 15, '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, '2019-11-22 07:35:44', '2019-11-22 07:35:44', '0.00', '0.00'),
(14, 16, '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, '2019-11-22 07:57:49', '2019-11-22 07:57:49', '0.00', '0.00'),
(15, 17, '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, '2019-11-22 07:58:45', '2019-11-22 07:58:45', '0.00', '0.00'),
(16, 18, '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, '2019-12-01 15:04:15', '2019-12-01 15:04:15', '0.00', '0.00'),
(17, 19, '0.00', '0.00', '0.00', '0.00', '0.00', 0, 0, '2019-12-01 15:05:18', '2019-12-01 15:05:18', '0.00', '0.00');
-- --------------------------------------------------------
--
-- 表的结构 `migrations`
--
CREATE TABLE IF NOT EXISTS `migrations` (
`id` int(10) unsigned NOT NULL,
`migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`batch` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `migrations`
--
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2018_09_12_032845_create_table_banners', 1),
(2, '2018_09_12_045822_create_table_banks', 1),
(3, '2018_09_13_083014_create_files_table', 1),
(4, '2018_09_13_100350_create_permission_tables', 1),
(5, '2018_09_17_091519_create_admin_logs_table', 1),
(6, '2018_10_26_110418_create_notice_articles_table', 1),
(7, '2018_12_22_163306_create_admins_table', 1),
(8, '2018_12_22_163326_create_users_table', 1),
(9, '2018_12_22_163350_create_orders_table', 1),
(10, '2018_12_22_163405_create_order_infos_table', 1),
(11, '2018_12_22_172958_create_pay_logs_table', 1),
(12, '2018_12_22_173040_create_categories_table', 1),
(13, '2018_12_22_173121_create_goods_table', 1),
(14, '2018_12_22_173928_create_configs_table', 1),
(15, '2018_12_22_174214_create_articles_table', 1),
(16, '2018_12_24_100534_create_merchants_table', 1),
(17, '2018_12_24_101115_create_pay_for_logs_table', 1),
(18, '2018_12_24_104015_create_notify_logs_table', 1),
(19, '2018_12_26_100226_create_order_handle_logs_table', 1),
(20, '2018_12_28_155120_create_gateways_table', 1),
(21, '2018_12_28_160427_create_gateway_winds__table', 1),
(22, '2018_12_30_021908_create_bank_rels_table', 1),
(23, '2018_12_30_022350_create_merchant_wallets_table', 1),
(24, '2018_12_30_023839_create_merchant_ratios_table', 1),
(25, '2018_12_30_025833_create_system_commissions_table', 1),
(26, '2018_12_30_025850_create_merchant_commissions_table', 1),
(27, '2018_12_30_030712_create_draw_moneys_table', 1),
(28, '2018_12_30_031906_create_draw_sets_table', 1),
(29, '2018_12_30_033316_create_merchant_money_logs_table', 1),
(30, '2019_01_03_155234_create_merchant_logs', 1),
(31, '2019_01_09_145331_add_field_merchant_wallters', 1),
(32, '2019_01_09_153822_add_field_merchant_commissions', 1),
(33, '2019_01_09_171323_add_field_order_handle_logs', 1),
(34, '2019_01_10_160415_add_field_to_merchant_money_logs', 1),
(35, '2019_01_10_182600_create_hande_do_logs_table', 1),
(36, '2019_01_11_155004_create_order_dels_table', 1),
(37, '2019_01_11_170115_create_order_del_infos_table', 1),
(38, '2019_01_12_135122_add_field_two_to_order_infos', 1),
(39, '2019_01_15_234912_add_field_to_system_commissions', 1),
(40, '2019_01_15_235254_add_field_to_three_orders', 1),
(41, '2019_01_16_004227_add_field_to_four_orders', 1),
(42, '2019_01_17_113708_add_field_to_order_del_infos', 1),
(43, '2019_01_18_150308_add_field_to_order_dels', 1),
(44, '2019_01_18_172525_add_field_three_to_gateways', 1),
(45, '2019_01_19_095808_add_field_03_to_gateways', 1),
(46, '2019_01_19_100223_add_field_03_to_orders', 1),
(47, '2019_01_19_142353_create_system_update_logs_table', 1),
(48, '2019_01_20_182715_add_field_to_3_order_dels', 1),
(49, '2019_02_27_211041_add_field_to_merchats', 1),
(50, '2019_02_27_212202_add_field_to_orders2', 1),
(51, '2019_02_27_212458_add_field_to_gateways', 1),
(52, '2019_03_02_192333_add_del_field_to_gateways', 1),
(53, '2019_03_02_192856_add_del_field_to_gateway_winds', 1),
(54, '2019_03_02_205607_add_del_field_to_order_infos', 1),
(55, '2019_03_02_205632_add_del_field_to_order_del_infos', 1),
(56, '2019_03_03_033028_add_del_field_to3_orders', 1),
(57, '2019_03_03_033055_add_del_field_to3_order_dels', 1),
(58, '2019_03_03_113158_add_field_day_draw_ratio_to_merchants', 1),
(59, '2019_03_06_033537_add_filed_to_gateways', 1),
(60, '2019_03_30_113638_add_field_to_gateway_winds', 1),
(61, '2019_04_30_061426_create_merchant_regists_table', 1),
(62, '2019_04_30_062357_create_merchant_regist_tokens_table', 1),
(63, '2019_06_10_043330_add_field_to_0610_orders', 1),
(64, '2019_06_10_044538_add_field_to_0610_gateways', 1),
(65, '2019_06_10_181235_add_field_to_06_10merchant_regists', 1),
(66, '2019_06_10_185848_add_field_to_06_10merchants', 1),
(67, '2019_06_10_211559_create_merchant_orders_table', 1),
(68, '2019_06_14_225606_add_field_to_614_gateways', 1);
-- --------------------------------------------------------
--
-- 表的结构 `model_has_permissions`
--
CREATE TABLE IF NOT EXISTS `model_has_permissions` (
`permission_id` int(10) unsigned NOT NULL,
`model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`model_id` bigint(20) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `model_has_roles`
--
CREATE TABLE IF NOT EXISTS `model_has_roles` (
`role_id` int(10) unsigned NOT NULL,
`model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`model_id` bigint(20) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `notice_articles`
--
CREATE TABLE IF NOT EXISTS `notice_articles` (
`id` int(10) unsigned NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',
`type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '发布类型',
`thumb` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '公告名称',
`content` text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '公告内容',
`user_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发布者类型',
`user_id` int(11) NOT NULL DEFAULT 0 COMMENT '发布者',
`is_checked` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态1:启用,0:禁用',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `notice_articles`
--
INSERT INTO `notice_articles` (`id`, `name`, `type`, `thumb`, `content`, `user_type`, `user_id`, `is_checked`, `created_at`, `updated_at`) VALUES
(1, '2156', 0, '0', '<p>测试</p>', 'admin', 1, 1, '2019-11-10 04:39:04', '2019-11-10 04:39:04');
-- --------------------------------------------------------
--
-- 表的结构 `notify_logs`
--
CREATE TABLE IF NOT EXISTS `notify_logs` (
`id` int(10) unsigned NOT NULL,
`order_id` int(11) NOT NULL COMMENT '订单id',
`local_order_status` tinyint(4) DEFAULT 0 COMMENT '回调更新本地订单状态1表示更新成功',
`out_order_status` tinyint(4) DEFAULT 0 COMMENT '回调更新外部订单状态1表示更新成功',
`mark` varchar(1500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `orders`
--
CREATE TABLE IF NOT EXISTS `orders` (
`id` int(10) unsigned NOT NULL,
`gateway_id` smallint(6) NOT NULL DEFAULT 1 COMMENT '通道id',
`gateway_method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '支付通道方法',
`pay_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '支付类型:微信,支付宝,银行',
`order_sn` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '订单编号',
`out_trade_sn` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '来源订单编号',
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '商品名称',
`goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id',
`pay_order_sn` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '支付接口流水号',
`order_money` decimal(10,2) NOT NULL COMMENT '支付金额',
`total_money` decimal(10,2) NOT NULL COMMENT '结算金额',
`pay_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '支付返回的金额',
`pay_rate` decimal(10,2) NOT NULL COMMENT '手续费',
`ratio` smallint(6) NOT NULL DEFAULT 12 COMMENT '扣点，1000单位，12表示12/1000=1.2%',
`local_user_id` int(10) unsigned DEFAULT NULL COMMENT '本站用户id',
`out_user_id` int(10) unsigned DEFAULT NULL COMMENT '外部用户id',
`merchant_id` int(11) NOT NULL DEFAULT 0 COMMENT '服务商id,0表示本站',
`merchant_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '服务器商名字',
`username` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '充值会员名字',
`status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '订单状态:1,交易成功,0,未支付，2,处理中,3交易失败',
`pay_status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '支付状态:1,支付成功,0,未支付，2,支付失败',
`notify_status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '支付回调状态:0还没回调，1回调成功，2回调失败',
`out_notify_status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '第三方回调状态:0还没回调，1回调成功，2回调失败',
`next_ratio` smallint(6) NOT NULL DEFAULT 0 COMMENT '上级结算佣金比例',
`next_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '上级计算佣金金额',
`system_ratio` smallint(6) NOT NULL DEFAULT 0 COMMENT '系统获得佣金比例',
`order_at` datetime DEFAULT NULL COMMENT '下单时间',
`pay_ok_at` datetime DEFAULT NULL COMMENT '支付成功时间',
`mark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`gateway_money` decimal(8,2) NOT NULL DEFAULT 0.00 COMMENT '通道成本资金',
`final_money` decimal(8,2) NOT NULL DEFAULT 0.00 COMMENT '扣除通道成本后的资金',
`final_ratio` smallint(6) NOT NULL DEFAULT 6 COMMENT '最后盈利费率',
`gateway_ratio` smallint(6) NOT NULL DEFAULT 6 COMMENT '通道费率',
`real_pate_money` decimal(8,2) NOT NULL DEFAULT 0.00 COMMENT '扣费商户金额',
`up_ratio` smallint(6) NOT NULL DEFAULT 0 COMMENT '上浮费率',
`original_ratio` smallint(6) NOT NULL DEFAULT 0 COMMENT '原始费率',
`top_ratio` smallint(6) NOT NULL DEFAULT 0 COMMENT '股东结算佣金比例',
`top_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '股东计算佣金金额',
`dali_id` int(11) NOT NULL DEFAULT 0 COMMENT '代理id,默认0表示没有',
`top_id` int(11) NOT NULL DEFAULT 0 COMMENT '股东id,默认0表示没有',
`rand_number` decimal(10,2) DEFAULT 0.00 COMMENT '随机金额',
`ewm_mark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
`ewm_account` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '付款人账号',
`gateway_data` varchar(5000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '通道数据',
`notify_number` smallint(6) NOT NULL DEFAULT 0 COMMENT '回调次数'
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `orders`
--
INSERT INTO `orders` (`id`, `gateway_id`, `gateway_method`, `pay_type`, `order_sn`, `out_trade_sn`, `name`, `goods_id`, `pay_order_sn`, `order_money`, `total_money`, `pay_money`, `pay_rate`, `ratio`, `local_user_id`, `out_user_id`, `merchant_id`, `merchant_name`, `username`, `status`, `pay_status`, `notify_status`, `out_notify_status`, `next_ratio`, `next_money`, `system_ratio`, `order_at`, `pay_ok_at`, `mark`, `created_at`, `updated_at`, `deleted_at`, `gateway_money`, `final_money`, `final_ratio`, `gateway_ratio`, `real_pate_money`, `up_ratio`, `original_ratio`, `top_ratio`, `top_money`, `dali_id`, `top_id`, `rand_number`, `ewm_mark`, `ewm_account`, `gateway_data`, `notify_number`) VALUES
(5, 2, 'web', 'alipay', '20191121172019937449', '201911211718057942', '20191121172019937449定制订单', 0, '2019112122001402241000040833', '4444.00', '4221.80', '4444.00', '133.32', 50, 5, 100460, 13, '大股东B的代理B1', 'demo242', 1, 1, 1, 1, 20, '88.88', 30, '2019-11-21 17:20:19', '2019-11-21 17:20:40', NULL, '2019-11-21 09:20:19', '2019-11-21 09:20:40', NULL, '31.11', '102.21', 23, 7, '222.20', 0, 50, 20, '88.88', 0, 11, '0.00', NULL, NULL, NULL, 0),
(10, 2, 'web', 'weixin', '20191122100405726528', '201911221003432842', '20191122100405726528定制订单', 0, NULL, '1.00', '0.95', '1.00', '0.03', 50, 10, 100180, 13, '大股东B的代理B1', 'demo142', 1, 1, 1, 1, 20, '0.02', 30, '2019-11-22 10:04:05', '2019-11-22 10:24:43', NULL, '2019-11-22 02:04:05', '2019-11-22 02:24:47', NULL, '0.01', '0.02', 23, 7, '0.05', 0, 50, 20, '0.02', 0, 11, '0.00', NULL, NULL, NULL, 0),
(12, 2, 'web', 'alipay', '20191122152602853111', '201911221525494409', '20191122152602853111定制订单', 0, NULL, '1.00', '0.95', '1.00', '0.03', 50, 12, 100948, 13, '大股东B的代理B1', 'demo718', 1, 1, 1, 1, 20, '0.02', 30, '2019-11-22 15:26:02', '2019-11-22 15:27:11', NULL, '2019-11-22 07:26:02', '2019-11-22 07:27:14', NULL, '0.01', '0.02', 23, 7, '0.05', 0, 50, 20, '0.02', 0, 11, '0.00', NULL, NULL, NULL, 0),
(22, 2, 'web', 'alipay', '20191123200550973265', '201911232005275233', '20191123200550973265定制订单', 0, NULL, '100.00', '95.00', '100.00', '3.00', 50, 21, 100690, 13, '大股东B的代理B1', 'demo879', 1, 1, 1, 1, 20, '2.00', 30, '2019-11-23 20:05:50', '2019-11-23 23:15:28', NULL, '2019-11-23 12:05:50', '2019-11-23 15:15:31', NULL, '0.70', '2.30', 23, 7, '5.00', 0, 50, 20, '2.00', 0, 11, '0.00', NULL, NULL, NULL, 0),
(23, 4, 'web', 'tr_alipay', '20191123200837327969', '201911232007457531', '20191123200837327969定制订单', 0, NULL, '100.00', '95.00', '100.00', '3.00', 50, 22, 100358, 13, '大股东B的代理B1', 'demo9', 1, 1, 1, 1, 20, '2.00', 30, '2019-11-23 20:08:37', '2019-11-23 23:15:33', NULL, '2019-11-23 12:08:37', '2019-11-23 15:15:34', NULL, '0.00', '3.00', 30, 0, '5.00', 0, 50, 20, '2.00', 0, 11, '0.00', '2', '123456', NULL, 0),
(24, 5, 'wap', 'tr_weixin', '20191124001501199969', '201911240014463819', '20191124001501199969定制订单', 0, NULL, '180.00', '170.64', '180.00', '5.76', 52, 23, 100869, 13, '大股东B的代理B1', 'demo531', 1, 1, 1, 1, 20, '3.60', 32, '2019-11-24 00:15:01', '2019-11-24 02:43:34', NULL, '2019-11-23 16:15:01', '2019-11-23 18:43:38', NULL, '3.24', '2.52', 14, 18, '9.36', 2, 50, 20, '3.60', 0, 11, '0.00', NULL, NULL, NULL, 0),
(30, 2, 'web', 'alipay', '20191125093902915363', '201911250938440102', '20191125093902915363定制订单', 0, NULL, '1.00', '0.95', '1.00', '0.03', 50, 29, 100566, 13, '大股东B的代理B1', 'demo125', 1, 1, 1, 1, 20, '0.02', 30, '2019-11-25 09:39:02', '2019-11-25 10:47:30', NULL, '2019-11-25 01:39:02', '2019-11-25 02:47:32', NULL, '0.01', '0.02', 23, 7, '0.05', 0, 50, 20, '0.02', 0, 11, '0.00', NULL, NULL, NULL, 0),
(36, 4, 'wap', 'tr_alipay', '20191125205316781590', '201911252052498868', '20191125205316781590定制订单', 0, NULL, '1.00', '0.95', '1.00', '0.03', 50, 36, 1005, 13, '大股东B的代理B1', 'demo271', 1, 1, 1, 1, 20, '0.02', 30, '2019-11-25 20:53:16', '2019-11-25 21:50:27', NULL, '2019-11-25 12:53:16', '2019-11-25 13:50:28', NULL, '0.00', '0.03', 30, 0, '0.05', 0, 50, 20, '0.02', 0, 11, '0.00', NULL, NULL, NULL, 0),
(39, 5, 'wap', 'tr_weixin', '20191125223713800497', '201911252237004209', '20191125223713800497定制订单', 0, NULL, '10.00', '9.48', '10.00', '0.32', 52, 39, 100828, 13, '大股东B的代理B1', 'demo619', 1, 1, 1, 1, 20, '0.20', 32, '2019-11-25 22:37:13', '2019-11-25 22:41:36', NULL, '2019-11-25 14:37:13', '2019-11-25 14:41:45', NULL, '0.18', '0.14', 14, 18, '0.52', 2, 50, 20, '0.20', 0, 11, '0.00', NULL, NULL, NULL, 0),
(43, 2, 'web', 'unionpay', '20191126184148839412', '201911261841374674', '20191126184148839412定制订单', 0, NULL, '111.00', '105.45', '111.00', '3.33', 50, 44, 100806, 13, '大股东B的代理B1', 'demo352', 1, 1, 1, 1, 20, '2.22', 30, '2019-11-26 18:41:48', '2019-11-26 18:46:47', NULL, '2019-11-26 10:41:48', '2019-11-26 10:46:52', NULL, '0.78', '2.55', 23, 7, '5.55', 0, 50, 20, '2.22', 0, 11, '0.00', NULL, NULL, NULL, 0),
(50, 2, 'web', 'alipay', '20191128002218948241', '201911280021539780', '20191128002218948241定制订单', 0, NULL, '100.00', '95.00', '100.00', '3.00', 50, 52, 100501, 13, '大股东B的代理B1', 'demo712', 1, 1, 1, 1, 20, '2.00', 30, '2019-11-28 00:22:18', '2019-11-28 01:33:21', NULL, '2019-11-27 16:22:18', '2019-11-27 17:33:23', NULL, '0.70', '2.30', 23, 7, '5.00', 0, 50, 20, '2.00', 0, 11, '0.00', NULL, NULL, NULL, 0),
(53, 2, 'web', 'alipay', '20191128093944740209', '201911280939222418', '20191128093944740209定制订单', 0, NULL, '1.00', '0.95', '1.00', '0.03', 50, 55, 100242, 13, '大股东B的代理B1', 'demo971', 1, 1, 1, 1, 20, '0.02', 30, '2019-11-28 09:39:44', '2019-11-28 09:45:52', NULL, '2019-11-28 01:39:44', '2019-11-28 01:45:53', NULL, '0.01', '0.02', 23, 7, '0.05', 0, 50, 20, '0.02', 0, 11, '0.00', NULL, NULL, NULL, 0),
(54, 2, 'web', 'alipay', '20191128094308132171', '201911280942505538', '20191128094308132171定制订单', 0, NULL, '111.00', '105.45', '111.00', '3.33', 50, 56, 100415, 13, '大股东B的代理B1', 'demo479', 1, 1, 1, 1, 20, '2.22', 30, '2019-11-28 09:43:08', '2019-11-28 09:45:39', NULL, '2019-11-28 01:43:08', '2019-11-28 01:45:45', NULL, '0.78', '2.55', 23, 7, '5.55', 0, 50, 20, '2.22', 0, 11, '0.00', NULL, NULL, NULL, 0),
(58, 2, 'web', 'alipay', '20191129144130425607', '201911291441098871', '20191129144130425607定制订单', 0, NULL, '100.00', '95.00', '100.00', '3.00', 50, 60, 10016, 13, '大股东B的代理B1', 'demo582', 1, 1, 1, 1, 20, '2.00', 30, '2019-11-29 14:41:30', '2019-11-29 14:45:53', NULL, '2019-11-29 06:41:30', '2019-11-29 06:45:56', NULL, '0.70', '2.30', 23, 7, '5.00', 0, 50, 20, '2.00', 0, 11, '0.00', NULL, NULL, NULL, 0),
(64, 2, 'web', 'alipay', '20191202140017602666', '201912021400034595', '20191202140017602666定制订单', 0, '2019120222001402241000048278', '88.00', '83.60', '88.00', '1.76', 50, 66, 100362, 13, '大股东B的代理B1', 'demo393', 1, 1, 1, 1, 30, '2.64', 20, '2019-12-02 14:00:17', '2019-12-02 14:01:35', NULL, '2019-12-02 06:00:17', '2019-12-02 06:01:35', NULL, '0.62', '1.14', 13, 7, '4.40', 0, 50, 30, '2.64', 0, 10, '0.00', NULL, NULL, NULL, 0),
(73, 3, 'web', 'tr_wxalbank', '20191205003737602899', '201912050036587017', '20191205003737602899定制订单', 0, NULL, '100.00', '95.00', '100.00', '2.00', 50, 75, 10078, 13, '大股东B的代理B1', 'demo365', 1, 1, 1, 1, 30, '3.00', 20, '2019-12-05 00:37:37', '2019-12-05 00:38:34', NULL, '2019-12-04 16:37:37', '2019-12-04 16:38:35', NULL, '1.50', '0.50', 5, 15, '5.00', 0, 50, 30, '3.00', 0, 10, '0.00', NULL, NULL, NULL, 0),
(82, 6, 'web', 'tr_wxal', '20191208222122749556', '201912082220431294', '20191208222122749556定制订单', 0, NULL, '1.00', '0.95', '1.00', '0.02', 50, 84, 100449, 13, '大股东B的代理B1', 'demo60', 1, 1, 1, 1, 30, '0.03', 20, '2019-12-08 22:21:22', '2019-12-08 22:23:00', NULL, '2019-12-08 14:21:22', '2019-12-08 14:23:03', NULL, '0.02', '0.00', 0, 20, '0.05', 0, 50, 30, '0.03', 0, 10, '0.00', 'ddd', 'test', NULL, 0),
(83, 2, 'web', 'alipay', '20191209034127371905', '201912090340279989', '20191209034127371905定制订单', 0, NULL, '1.00', '0.95', '0.00', '0.02', 50, 85, 100147, 13, '大股东B的代理B1', 'demo99', 3, 0, 0, 0, 30, '0.03', 20, '2019-12-09 03:41:27', NULL, NULL, '2019-12-08 19:41:27', '2019-12-09 01:20:44', NULL, '0.01', '0.01', 13, 7, '0.05', 0, 50, 30, '0.03', 0, 10, '0.00', NULL, NULL, NULL, 0),
(84, 2, 'wap', 'alipay', '20191209093919754873', '201912090939030862', '20191209093919754873定制订单', 0, NULL, '1.00', '0.95', '0.00', '0.02', 50, 88, 100217, 13, '大股东B的代理B1', 'demo133', 3, 0, 0, 0, 30, '0.03', 20, '2019-12-09 09:39:19', NULL, NULL, '2019-12-09 01:39:19', '2019-12-09 03:15:05', NULL, '0.01', '0.01', 13, 7, '0.05', 0, 50, 30, '0.03', 0, 10, '0.00', NULL, NULL, NULL, 0),
(85, 2, 'wap', 'alipay', '20191209094034478195', '201912090940261870', '20191209094034478195定制订单', 0, NULL, '1.00', '0.95', '0.00', '0.02', 50, 89, 100663, 13, '大股东B的代理B1', 'demo25', 3, 0, 0, 0, 30, '0.03', 20, '2019-12-09 09:40:34', NULL, NULL, '2019-12-09 01:40:34', '2019-12-09 03:15:05', NULL, '0.01', '0.01', 13, 7, '0.05', 0, 50, 30, '0.03', 0, 10, '0.00', NULL, NULL, NULL, 0),
(86, 2, 'web', 'tr_bank2', '20191209111335403428', '201912091113243491', '20191209111335403428定制订单', 0, NULL, '1.00', '0.95', '1.00', '0.02', 50, 90, 100601, 13, '大股东B的代理B1', 'demo222', 1, 1, 1, 1, 30, '0.03', 20, '2019-12-09 11:13:35', '2019-12-09 11:14:11', NULL, '2019-12-09 03:13:35', '2019-12-09 03:14:14', NULL, '0.01', '0.01', 13, 7, '0.05', 0, 50, 30, '0.03', 0, 10, '0.00', NULL, NULL, NULL, 0),
(87, 6, 'web', 'tr_wxal', '20191209111434496251', '201912091114220443', '20191209111434496251定制订单', 0, NULL, '1.00', '0.95', '0.00', '0.02', 50, 91, 100222, 13, '大股东B的代理B1', 'demo697', 3, 0, 0, 0, 30, '0.03', 20, '2019-12-09 11:14:34', NULL, NULL, '2019-12-09 03:14:34', '2019-12-09 05:37:58', NULL, '0.02', '0.00', 0, 20, '0.05', 0, 50, 30, '0.03', 0, 10, '0.00', NULL, NULL, NULL, 0),
(88, 2, 'web', 'alipay', '20191209112639215347', '201912091126248676', '20191209112639215347定制订单', 0, NULL, '100.00', '95.00', '0.00', '2.00', 50, 92, 100684, 13, '大股东B的代理B1', 'demo741', 3, 0, 0, 0, 30, '3.00', 20, '2019-12-09 11:26:39', NULL, NULL, '2019-12-09 03:26:39', '2019-12-09 05:37:58', NULL, '0.70', '1.30', 13, 7, '5.00', 0, 50, 30, '3.00', 0, 10, '0.00', NULL, NULL, NULL, 0),
(89, 6, 'web', 'tr_wxal', '20191209135652138318', '201912091356140504', '20191209135652138318定制订单', 0, NULL, '100.00', '95.00', '100.00', '2.00', 50, 93, 100617, 13, '大股东B的代理B1', 'demo904', 1, 1, 1, 1, 30, '3.00', 20, '2019-12-09 13:56:52', '2019-12-09 13:57:35', NULL, '2019-12-09 05:56:52', '2019-12-09 05:59:55', NULL, '2.00', '0.00', 0, 20, '5.00', 0, 50, 30, '3.00', 0, 10, '0.00', NULL, NULL, NULL, 0);
-- --------------------------------------------------------
--
-- 表的结构 `order_dels`
--
CREATE TABLE IF NOT EXISTS `order_dels` (
`id` int(10) unsigned NOT NULL,
`gateway_id` smallint(6) NOT NULL DEFAULT 1 COMMENT '通道id',
`gateway_method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '支付通道方法',
`pay_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '支付类型:微信,支付宝,银行',
`order_sn` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '订单编号',
`out_trade_sn` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '来源订单编号',
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '商品名称',
`goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id',
`pay_order_sn` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '支付接口流水号',
`order_money` decimal(10,2) NOT NULL COMMENT '支付金额',
`total_money` decimal(10,2) NOT NULL COMMENT '结算金额',
`pay_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '支付返回的金额',
`pay_rate` decimal(10,2) NOT NULL COMMENT '手续费',
`ratio` smallint(6) NOT NULL DEFAULT 12 COMMENT '扣点，1000单位，12表示12/1000=1.2%',
`local_user_id` int(10) unsigned DEFAULT NULL COMMENT '本站用户id',
`out_user_id` int(10) unsigned DEFAULT NULL COMMENT '外部用户id',
`merchant_id` int(11) NOT NULL DEFAULT 0 COMMENT '服务商id,0表示本站',
`merchant_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '服务器商名字',
`username` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '充值会员名字',
`status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '订单状态:1,交易成功,0,未支付，2,处理中,3交易失败',
`pay_status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '支付状态:1,支付成功,0,未支付，2,支付失败',
`notify_status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '支付回调状态:0还没回调，1回调成功，2回调失败',
`out_notify_status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '第三方回调状态:0还没回调，1回调成功，2回调失败',
`next_ratio` smallint(6) NOT NULL DEFAULT 0 COMMENT '上级结算佣金比例',
`next_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '上级计算佣金金额',
`system_ratio` smallint(6) NOT NULL DEFAULT 0 COMMENT '系统获得佣金比例',
`order_at` datetime DEFAULT NULL COMMENT '下单时间',
`pay_ok_at` datetime DEFAULT NULL COMMENT '支付成功时间',
`mark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`gateway_money` decimal(8,2) NOT NULL DEFAULT 0.00 COMMENT '通道成本资金',
`final_money` decimal(8,2) NOT NULL DEFAULT 0.00 COMMENT '扣除通道成本后的资金',
`final_ratio` smallint(6) NOT NULL DEFAULT 0 COMMENT '最后盈利费率',
`gateway_ratio` smallint(6) NOT NULL DEFAULT 0 COMMENT '通道费率',
`real_pate_money` decimal(8,2) NOT NULL DEFAULT 0.00 COMMENT '扣费商户金额',
`up_ratio` smallint(6) NOT NULL DEFAULT 0 COMMENT '上浮费率',
`original_ratio` smallint(6) NOT NULL DEFAULT 0 COMMENT '原始费率',
`top_ratio` smallint(6) NOT NULL DEFAULT 0 COMMENT '股东结算佣金比例',
`top_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '股东计算佣金金额',
`dali_id` int(11) NOT NULL DEFAULT 0 COMMENT '代理id,默认0表示没有',
`top_id` int(11) NOT NULL DEFAULT 0 COMMENT '股东id,默认0表示没有'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `order_del_infos`
--
CREATE TABLE IF NOT EXISTS `order_del_infos` (
`id` int(10) unsigned NOT NULL,
`merchant_id` int(11) NOT NULL DEFAULT 0 COMMENT '服务商id,0表示本站',
`merchant_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '服务商名字',
`order_id` int(10) unsigned DEFAULT NULL COMMENT '订单id',
`from_url` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '来源地址',
`from_ip` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '来源ip',
`from_order_sn` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '来源外部订单编号',
`sign` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '请求来的sign',
`money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '充值金额',
`return_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '同步地址',
`notify_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '异步地址',
`notify_data` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '异步返回参数',
`notify_status` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '异步回调结果:success表示成功,其他失败',
`username` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '充值会员名字',
`local_user_id` int(10) unsigned DEFAULT NULL COMMENT '本站用户id',
`out_user_id` int(10) unsigned DEFAULT NULL COMMENT '外部用户id',
`prodcut_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '请求过来商品名称',
`attach` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '附加数据',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`app_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '提交过来的app_id',
`gateway_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '通道名字'
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `order_del_infos`
--
INSERT INTO `order_del_infos` (`id`, `merchant_id`, `merchant_name`, `order_id`, `from_url`, `from_ip`, `from_order_sn`, `sign`, `money`, `return_url`, `notify_url`, `notify_data`, `notify_status`, `username`, `local_user_id`, `out_user_id`, `prodcut_name`, `attach`, `created_at`, `updated_at`, `app_id`, `gateway_name`) VALUES
(1, 13, '大股东B的代理B1', 1, 'http://zf2.kongqikeji.com/demo2/pay.php', '183.3.226.234', NULL, '8bfe46159f9e12a5272a4a57dcfc886a', '111.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo697', 1, 100387, '定制服务00983', 'json', NULL, NULL, '20190301115051YMBtuG', '固码支付'),
(2, 13, '大股东B的代理B1', 2, 'http://zf2.kongqikeji.com/demo2/pay.php', '183.3.226.234', NULL, '7d0a78036a492cf20e1b4f9b08badfb6', '20.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo199', 2, 100623, '定制服务00899', 'json', NULL, NULL, '20190301115051YMBtuG', '微信支付固码测试'),
(3, 13, '大股东B的代理B1', 3, 'http://zf2.kongqikeji.com/demo2/pay.php', '183.3.226.234', NULL, '05de66b91fa2535150fbbbf3287422bf', '30.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo456', 3, 100184, '定制服务00454', 'json', NULL, NULL, '20190301115051YMBtuG', '测试支付宝固码支付'),
(4, 13, '大股东B的代理B1', 4, 'http://zf2.kongqikeji.com/demo2/pay.php', '120.235.126.53', NULL, '0cca3b634b96c766a3b25d6043c32877', '222.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo117', 4, 100989, '定制服务00671', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(5, 13, '大股东B的代理B1', 6, 'http://zf2.kongqikeji.com/demo2/pay.php', '110.87.66.52', NULL, 'ac395c744fae37f754c3b3e554809a7e', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo555', 6, 100173, '定制服务00946', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(6, 13, '大股东B的代理B1', 7, 'http://zf2.kongqikeji.com/demo2/pay.php', '110.87.66.52', NULL, '38d6ad4dab4174aea2db32fdaaad8222', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo596', 7, 100901, '定制服务00975', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(7, 13, '大股东B的代理B1', 8, 'http://zf2.kongqikeji.com/demo2/pay.php', '222.128.6.36', NULL, '767afa334153fb197d52125732072328', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo384', 8, 100651, '定制服务00285', 'json', NULL, NULL, '20190301115051YMBtuG', '测试支付宝固码支付'),
(8, 13, '大股东B的代理B1', 9, 'http://zf2.kongqikeji.com/demo2/pay.php', '183.156.54.149', NULL, '34efe5394602bc4442e6d74f17e5abab', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo926', 9, 100621, '定制服务00454', 'json', NULL, NULL, '20190301115051YMBtuG', '微信支付固码测试'),
(9, 13, '大股东B的代理B1', 11, 'http://zf2.kongqikeji.com/demo2/pay.php', '103.216.43.146', NULL, 'dcfc3592dfb45e5870d4ceda1a13c15f', '100.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo956', 11, 10089, '定制服务00703', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(10, 13, '大股东B的代理B1', 13, 'http://zf2.kongqikeji.com/demo2/pay.php', '1.198.19.250', NULL, '87b517cef104980cc06caeca25c39f58', '15.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo373', 10, 100180, '定制服务00524', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(11, 13, '大股东B的代理B1', 14, 'http://zf2.kongqikeji.com/demo2/pay.php', '183.62.22.202', NULL, 'a254969e64bf1ce04d4514b2ea7c5344', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo995', 13, 100934, '定制服务00983', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(12, 13, '大股东B的代理B1', 15, 'http://zf2.kongqikeji.com/demo2/pay.php', '117.132.195.151', NULL, '247f2a9636c24cafc8a5cd0ebf110256', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo291', 14, 100619, '定制服务00926', 'json', NULL, NULL, '20190301115051YMBtuG', '微信支付宝二合一固码支付'),
(13, 13, '大股东B的代理B1', 16, 'http://zf2.kongqikeji.com/demo2/pay.php', '222.82.207.252', NULL, 'ea5a29db1d57ea14b7f505cef848c183', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo857', 15, 100474, '定制服务00618', 'json', NULL, NULL, '20190301115051YMBtuG', '微信支付宝二合一固码支付'),
(14, 13, '大股东B的代理B1', 17, 'http://zf2.kongqikeji.com/demo2/pay.php', '47.240.1.111', NULL, '7a8a6a9d8eafe2aa90c5e826ec2d169f', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo923', 16, 100941, '定制服务00588', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(15, 13, '大股东B的代理B1', 18, 'http://zf2.kongqikeji.com/demo2/pay.php', '223.157.159.238', NULL, '7de1a118751489844680f57ffbf7ff2f', '100.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo708', 17, 100351, '定制服务00913', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(16, 13, '大股东B的代理B1', 19, 'http://zf2.kongqikeji.com/demo2/pay.php', '49.81.174.210', NULL, '18521359e60429abfc39226425d209c0', '100.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo515', 18, 100674, '定制服务00463', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(17, 13, '大股东B的代理B1', 20, 'http://zf2.kongqikeji.com/demo2/pay.php', '39.128.13.244', NULL, 'f7cc3fc4d3c32875aba41363e0addf42', '5.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo315', 19, 100855, '定制服务00356', 'json', NULL, NULL, '20190301115051YMBtuG', '微信支付宝二合一固码支付'),
(18, 13, '大股东B的代理B1', 21, 'http://zf2.kongqikeji.com/demo2/pay.php', '125.41.133.67', NULL, 'dd127d7113615fb6113ae62554677e48', '15000.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo264', 20, 100321, '定制服务00465', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(19, 13, '大股东B的代理B1', 25, 'http://zf2.kongqikeji.com/demo2/pay.php', '115.190.202.151', NULL, '21b445375824ad6890ef46b12bdacad5', '10.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo930', 24, 100538, '定制服务00329', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(20, 13, '大股东B的代理B1', 26, 'http://zf2.kongqikeji.com/demo2/pay.php', '118.113.97.68', NULL, 'bb7313b508b459195bb03a2d319b992d', '100.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo305', 25, 100479, '定制服务00169', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(21, 0, '本站', 27, 'http://zf2.kongqikeji.com/order?id=7', '39.182.85.59', NULL, NULL, '8000.00', NULL, NULL, NULL, NULL, '', 26, NULL, 'CRM客户系统定制开发', '', NULL, NULL, NULL, '沙箱2016092500592678'),
(22, 13, '大股东B的代理B1', 28, 'http://zf2.kongqikeji.com/demo2/pay.php', '117.30.56.80', NULL, '4c959b3c413b166b49dc1c9cbef4662b', '111.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo639', 27, 100899, '定制服务00684', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(23, 13, '大股东B的代理B1', 29, 'http://zf2.kongqikeji.com/demo2/pay.php', '110.87.118.223', NULL, 'e098439cb1f20474a0ccc66c5af5cd69', '11.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo402', 28, 100579, '定制服务00343', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(24, 13, '大股东B的代理B1', 31, 'http://zf2.kongqikeji.com/demo2/pay.php', '171.83.4.123', NULL, '05ac10f204ea344557d838810d9e4e78', '12.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo239', 30, 100696, '定制服务00287', 'json', NULL, NULL, '20190301115051YMBtuG', '测试支付宝固码支付'),
(25, 13, '大股东B的代理B1', 32, 'http://zf2.kongqikeji.com/demo2/pay.php', '14.106.229.108', NULL, 'e18c3d6a950ba2db527b372fbcc39830', '100.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo687', 31, 10021, '定制服务00276', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(26, 13, '大股东B的代理B1', 33, 'http://zf2.kongqikeji.com/demo2/pay.php', '101.226.225.85', NULL, '48cea9cca1b92e69f05ddf8c3973bfe4', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo458', 32, 100807, '定制服务00112', 'json', NULL, NULL, '20190301115051YMBtuG', '微信支付固码测试'),
(27, 13, '大股东B的代理B1', 34, 'http://zf2.kongqikeji.com/demo2/pay.php', '171.44.166.55', NULL, '32d5e1ca05d669d97349b347ff9289c2', '10.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo607', 33, 100979, '定制服务00875', 'json', NULL, NULL, '20190301115051YMBtuG', '微信支付固码测试'),
(28, 13, '大股东B的代理B1', 35, 'http://zf2.kongqikeji.com/demo2/pay.php', '27.41.92.167', NULL, 'a34968ff514e611c44a80c42895614c0', '10.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo248', 34, 100357, '定制服务00987', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(29, 13, '大股东B的代理B1', 37, 'http://zf2.kongqikeji.com/demo2/pay.php', '123.1.184.251', NULL, '746fffcad191b838746aa471fc963cd1', '10.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo243', 37, 100943, '定制服务00765', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(30, 13, '大股东B的代理B1', 38, 'http://zf2.kongqikeji.com/demo2/pay.php', '123.1.184.251', NULL, 'fe9ca4a9db76c98ab1f5f9de6658b981', '10.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo409', 38, 1006, '定制服务00729', 'json', NULL, NULL, '20190301115051YMBtuG', '微信支付固码测试'),
(31, 13, '大股东B的代理B1', 40, 'http://zf2.kongqikeji.com/demo2/pay.php', '59.109.155.59', NULL, '8a1f202f7ffc8b7ec9bd254d5a6b17c8', '999.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo151', 40, 100411, '定制服务00988', 'json', NULL, NULL, '20190301115051YMBtuG', '固码支付'),
(32, 13, '大股东B的代理B1', 41, 'http://zf2.kongqikeji.com/demo2/pay.php', '113.140.249.12', NULL, 'baf430bde2d309cf3b04608ed34e7977', '111.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo886', 42, 100341, '定制服务00266', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(33, 13, '大股东B的代理B1', 42, 'http://zf2.kongqikeji.com/demo2/pay.php', '110.184.161.113', NULL, '5a295e3eba6e43c1984a3822fe12175a', '11111.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo996', 43, 100421, '定制服务00444', 'json', NULL, NULL, '20190301115051YMBtuG', '微信支付固码测试'),
(34, 13, '大股东B的代理B1', 44, 'http://zf2.kongqikeji.com/demo2/pay.php', '59.41.65.222', NULL, 'fd62406d022de86357892f1f7201eba1', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo232', 45, 100467, '定制服务00926', 'json', NULL, NULL, '20190301115051YMBtuG', '微信支付宝二合一固码支付'),
(35, 13, '大股东B的代理B1', 45, 'http://zf2.kongqikeji.com/demo2/pay.php', '58.19.95.133', NULL, 'e67f41312e1c6f58982271c6e661dec5', '2.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo974', 46, 100984, '定制服务00529', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(36, 13, '大股东B的代理B1', 46, 'http://zf2.kongqikeji.com/demo2/pay.php', '113.185.40.35', NULL, '8474478b05eeedb7885f459f29b4d806', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo299', 47, 100346, '定制服务00125', 'json', NULL, NULL, '20190301115051YMBtuG', '测试支付宝固码支付'),
(37, 13, '大股东B的代理B1', 47, 'http://zf2.kongqikeji.com/demo2/pay.php', '113.118.112.231', NULL, '9d263d74fb0bc231570c655e6a8765d3', '10.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo943', 48, 100166, '定制服务00789', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(38, 13, '大股东B的代理B1', 48, 'http://zf2.kongqikeji.com/demo2/pay.php', '113.87.195.14', NULL, 'b973ff438753d400173378f1a58b65fe', '1300.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo777', 49, 100285, '定制服务00937', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(39, 13, '大股东B的代理B1', 49, 'http://zf2.kongqikeji.com/demo2/pay.php', '60.176.149.245', NULL, '172414fdd8e22e31fd92d01e9387c163', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo889', 51, 100956, '定制服务00486', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(40, 13, '大股东B的代理B1', 51, 'http://zf2.kongqikeji.com/demo2/pay.php', '110.184.65.24', NULL, '3439b09cdaa60072b0a770faf6533d3d', '33333.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo747', 53, 100125, '定制服务00687', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(41, 13, '大股东B的代理B1', 52, 'http://zf2.kongqikeji.com/demo2/pay.php', '113.98.117.33', NULL, 'ee8505c0bc573ba974ee5855dde546be', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo605', 54, 100571, '定制服务00287', 'json', NULL, NULL, '20190301115051YMBtuG', '微信支付宝二合一固码支付'),
(42, 13, '大股东B的代理B1', 55, 'http://zf2.kongqikeji.com/demo2/pay.php', '120.197.20.160', NULL, '2e13c36d1c23e4dd4d1e0ff286d34b2a', '100.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo660', 57, 10055, '定制服务00798', 'json', NULL, NULL, '20190301115051YMBtuG', '微信支付固码测试'),
(43, 13, '大股东B的代理B1', 56, 'http://zf2.kongqikeji.com/demo2/pay.php', '61.52.17.200', NULL, 'db72be1b4d920be5bbb68f933b7b030a', '100.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo891', 58, 100803, '定制服务00525', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(44, 13, '大股东B的代理B1', 57, 'http://zf2.kongqikeji.com/demo2/pay.php', '123.186.127.96', NULL, '2537a2d0d0108aab79386c8ae53c930d', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo466', 59, 100981, '定制服务00854', 'json', NULL, NULL, '20190301115051YMBtuG', '微信支付固码测试'),
(45, 13, '大股东B的代理B1', 59, 'http://zf2.kongqikeji.com/demo2/pay.php', '138.19.130.249', NULL, '65101f341701b1edffd0dad4b5a4b7dd', '11.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo818', 61, 100952, '定制服务00899', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(46, 13, '大股东B的代理B1', 60, 'http://zf2.kongqikeji.com/demo2/pay.php', '180.142.152.138', NULL, 'ec49ac715fb603c22d3ea003bcebdd03', '10.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo881', 62, 100671, '定制服务00878', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(47, 13, '大股东B的代理B1', 61, 'http://zf2.kongqikeji.com/demo2/pay.php', '123.117.17.148', NULL, 'd62de781794c4cf9fdfe063c2f00bb46', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo477', 63, 10034, '定制服务00173', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(48, 13, '大股东B的代理B1', 62, 'http://zf2.kongqikeji.com/demo2/pay.php', '113.104.228.128', NULL, '6c3aef13feec5a77ce75b2747805ac1a', '100.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo204', 64, 100879, '定制服务00171', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(49, 13, '大股东B的代理B1', 63, 'http://zf2.kongqikeji.com/demo2/pay.php', '117.181.198.205', NULL, '2ec259f0e739a16ffb3f675b89b3ae75', '100.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo719', 65, 100808, '定制服务00315', 'json', NULL, NULL, '20190301115051YMBtuG', '微信支付宝二合一固码支付'),
(50, 13, '大股东B的代理B1', 65, 'http://zf2.kongqikeji.com/demo2/pay.php', '117.28.246.18', NULL, '4e481f096033eefec2e67ab64500962e', '100.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo948', 68, 100870, '定制服务00401', 'json', NULL, NULL, '20190301115051YMBtuG', '微信支付宝二合一固码支付'),
(51, 13, '大股东B的代理B1', 66, 'http://zf2.kongqikeji.com/demo2/pay.php', '125.70.229.227', NULL, 'bd9e10a122c198ac0bb9e0fe137ec316', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo89', 69, 100504, '定制服务00449', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(52, 13, '大股东B的代理B1', 67, 'http://zf2.kongqikeji.com/demo2/pay.php', '124.6.177.130', NULL, '1d3df56abb6b9f73a5929d07fcfab5fc', '9.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo704', 70, 100337, '定制服务00660', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(53, 13, '大股东B的代理B1', 68, 'http://zf2.kongqikeji.com/demo2/pay.php', '27.38.37.82', NULL, 'f4d0fe2bbb773b881004150f2f52cb55', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo929', 71, 100273, '定制服务00814', 'json', NULL, NULL, '20190301115051YMBtuG', '微信支付固码测试'),
(54, 13, '大股东B的代理B1', 69, 'http://zf2.kongqikeji.com/demo2/pay.php', '58.216.203.98', NULL, '26c67803292a93b4cd58970c622bd0e5', '1.35', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo887', 72, 100234, '定制服务00575', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(55, 13, '大股东B的代理B1', 70, 'http://zf2.kongqikeji.com/demo2/pay.php', '113.118.85.104', NULL, '2b8d77be4d635ef42e9b1d053fbfaa4c', '10.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo684', 73, 10011, '定制服务00957', 'json', NULL, NULL, '20190301115051YMBtuG', '微信支付宝二合一固码支付'),
(56, 13, '大股东B的代理B1', 71, 'http://zf2.kongqikeji.com/demo2/pay.php', '183.67.49.149', NULL, '85d9847dc8f7b56e0ebf5ecaa7aca856', '100.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo120', 64, 100879, '定制服务00175', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(57, 13, '大股东B的代理B1', 72, 'http://zf2.kongqikeji.com/demo2/pay.php', '211.162.236.62', NULL, 'b3d0a1ea2d009cda3196a11a527fc65f', '90.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo905', 74, 100657, '定制服务00205', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(58, 13, '大股东B的代理B1', 74, 'http://zf2.kongqikeji.com/demo2/pay.php', '113.99.127.130', NULL, 'f32bedc345342c2d8d6dcdbdf2fee756', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo177', 76, 10085, '定制服务00600', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(59, 13, '大股东B的代理B1', 75, 'http://zf2.kongqikeji.com/demo2/pay.php', '183.236.87.106', NULL, '69e708f1b3afb8649e45ae1a1879bd69', '100.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo929', 77, 100982, '定制服务00241', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(60, 13, '大股东B的代理B1', 76, 'http://zf2.kongqikeji.com/demo2/pay.php', '61.148.245.246', NULL, '151175a609b898d175a06779dad9c0c4', '3.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo816', 63, 10034, '定制服务00868', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(61, 13, '大股东B的代理B1', 77, 'http://zf2.kongqikeji.com/demo2/pay.php', '113.247.139.154', NULL, 'a12e477c333f90e383644b6ea6c0adf1', '10.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo599', 79, 100927, '定制服务00316', 'json', NULL, NULL, '20190301115051YMBtuG', '微信支付宝二合一固码支付'),
(62, 13, '大股东B的代理B1', 78, 'http://zf2.kongqikeji.com/demo2/pay.php', '110.87.117.255', NULL, 'e951d86c8a9706a949ab28d736d6b6ae', '10.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo37', 80, 100249, '定制服务00680', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(63, 13, '大股东B的代理B1', 79, 'http://zf2.kongqikeji.com/demo2/pay.php', '61.132.128.11', NULL, '79521481fcb4d280c797daab629d6e0b', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo768', 81, 100790, '定制服务00906', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(64, 13, '大股东B的代理B1', 80, 'http://zf2.kongqikeji.com/demo2/pay.php', '106.86.209.234', NULL, 'bc7a10d0ecfc10bc7c33a8e9c76dadad', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo12', 82, 100412, '定制服务00275', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(65, 13, '大股东B的代理B1', 81, 'http://zf2.kongqikeji.com/demo2/pay.php', '39.91.107.231', NULL, 'b63ee2f52e7d3dcae6ce6c37d1d35fd3', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo425', 83, 100329, '定制服务00823', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678');
-- --------------------------------------------------------
--
-- 表的结构 `order_handle_logs`
--
CREATE TABLE IF NOT EXISTS `order_handle_logs` (
`id` int(10) unsigned NOT NULL,
`order_id` int(10) unsigned NOT NULL COMMENT '订单ID',
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '操作事件名称',
`from_status` tinyint(4) NOT NULL DEFAULT -1 COMMENT '订单开始状态',
`to_status` tinyint(4) NOT NULL DEFAULT -1 COMMENT '订单当前状态',
`mark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
`handle_user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT '操作人id',
`handle_user_name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '操作人姓名',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`handle_user_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '操作用户类型'
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `order_handle_logs`
--
INSERT INTO `order_handle_logs` (`id`, `order_id`, `name`, `from_status`, `to_status`, `mark`, `handle_user_id`, `handle_user_name`, `created_at`, `updated_at`, `handle_user_type`) VALUES
(1, 10, '完成订单支付操作', 0, 2, NULL, 1, 'kongqi', '2019-11-22 02:24:47', '2019-11-22 02:24:47', 'admin'),
(2, 12, '完成订单支付操作', 0, 2, NULL, 1, 'kongqi', '2019-11-22 07:27:14', '2019-11-22 07:27:14', 'admin'),
(3, 22, '完成订单支付操作', 0, 2, NULL, 1, 'kongqi', '2019-11-23 15:15:31', '2019-11-23 15:15:31', 'admin'),
(4, 23, '完成订单支付操作', 0, 2, NULL, 1, 'kongqi', '2019-11-23 15:15:34', '2019-11-23 15:15:34', 'admin'),
(5, 24, '完成订单支付操作', 0, 2, NULL, 1, 'kongqi', '2019-11-23 18:43:37', '2019-11-23 18:43:37', 'admin'),
(6, 30, '完成订单支付操作', 0, 2, NULL, 1, 'kongqi', '2019-11-25 02:47:32', '2019-11-25 02:47:32', 'admin'),
(7, 36, '完成订单支付操作', 0, 2, NULL, 1, 'kongqi', '2019-11-25 13:50:28', '2019-11-25 13:50:28', 'admin'),
(8, 39, '完成订单支付操作', 0, 2, NULL, 1, 'kongqi', '2019-11-25 14:41:45', '2019-11-25 14:41:45', 'admin'),
(9, 43, '完成订单支付操作', 0, 2, NULL, 1, 'kongqi', '2019-11-26 10:46:51', '2019-11-26 10:46:51', 'admin'),
(10, 50, '完成订单支付操作', 0, 2, NULL, 1, 'kongqi', '2019-11-27 17:33:23', '2019-11-27 17:33:23', 'admin'),
(11, 54, '完成订单支付操作', 0, 2, NULL, 1, 'kongqi', '2019-11-28 01:45:45', '2019-11-28 01:45:45', 'admin'),
(12, 53, '完成订单支付操作', 0, 2, NULL, 1, 'kongqi', '2019-11-28 01:45:53', '2019-11-28 01:45:53', 'admin'),
(13, 58, '完成订单支付操作', 0, 2, NULL, 1, 'kongqi', '2019-11-29 06:45:55', '2019-11-29 06:45:55', 'admin'),
(14, 73, '完成订单支付操作', 0, 2, NULL, 1, 'kongqi', '2019-12-04 16:38:35', '2019-12-04 16:38:35', 'admin'),
(15, 82, '完成订单支付操作', 0, 2, NULL, 1, 'kongqi', '2019-12-08 14:23:02', '2019-12-08 14:23:02', 'admin'),
(16, 86, '完成订单支付操作', 0, 2, NULL, 1, 'kongqi', '2019-12-09 03:14:14', '2019-12-09 03:14:14', 'admin'),
(17, 89, '完成订单支付操作', 0, 2, NULL, 1, 'kongqi', '2019-12-09 05:59:55', '2019-12-09 05:59:55', 'admin');
-- --------------------------------------------------------
--
-- 表的结构 `order_infos`
--
CREATE TABLE IF NOT EXISTS `order_infos` (
`id` int(10) unsigned NOT NULL,
`merchant_id` int(11) NOT NULL DEFAULT 0 COMMENT '服务商id,0表示本站',
`merchant_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '服务商名字',
`order_id` int(10) unsigned DEFAULT NULL COMMENT '订单id',
`from_url` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '来源地址',
`from_ip` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '来源ip',
`from_order_sn` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '来源外部订单编号',
`sign` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '请求来的sign',
`money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '充值金额',
`return_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '同步地址',
`notify_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '异步地址',
`notify_data` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '异步返回参数',
`notify_status` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '异步回调结果:success表示成功,其他失败',
`username` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '充值会员名字',
`local_user_id` int(10) unsigned DEFAULT NULL COMMENT '本站用户id',
`out_user_id` int(10) unsigned DEFAULT NULL COMMENT '外部用户id',
`prodcut_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '请求过来商品名称',
`attach` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '附加数据',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`app_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '提交过来的app_id',
`gateway_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '通道名字'
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `order_infos`
--
INSERT INTO `order_infos` (`id`, `merchant_id`, `merchant_name`, `order_id`, `from_url`, `from_ip`, `from_order_sn`, `sign`, `money`, `return_url`, `notify_url`, `notify_data`, `notify_status`, `username`, `local_user_id`, `out_user_id`, `prodcut_name`, `attach`, `created_at`, `updated_at`, `app_id`, `gateway_name`) VALUES
(5, 13, '大股东B的代理B1', 5, 'http://zf2.kongqikeji.com/demo2/pay.php', '120.235.126.53', NULL, '72c6723541f40a26e879caebdf3b9ed2', '4444.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', '{"pay_money":"4444.00","money":"4444.00","order_sn":"20191121172019937449","out_trade_sn":"201911211718057942","pay_order_sn":"2019112122001402241000040833","sign":"e1bf6cf65531741e00a5e6964cdf9070","attach":"json","return_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/payreturn.php","notify_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/paynotify.php"}', 'success', 'demo242', 5, 100460, '定制服务00245', 'json', NULL, '2019-11-21 09:20:40', '20190301115051YMBtuG', '沙箱2016092500592678'),
(10, 13, '大股东B的代理B1', 10, 'http://zf2.kongqikeji.com/demo2/pay.php', '47.74.188.240', NULL, '513e7aab947c4b0cfac13a86920da7dc', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', '{"pay_money":"1.00","money":"1.00","order_sn":"20191122100405726528","out_trade_sn":"201911221003432842","pay_order_sn":null,"sign":"2135d97bc05130b610b1850058f89bca","attach":"json","return_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/payreturn.php","notify_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/paynotify.php"}', 'success', 'demo142', 10, 100180, '定制服务00359', 'json', NULL, '2019-11-22 02:24:47', '20190301115051YMBtuG', '沙箱2016092500592678'),
(12, 13, '大股东B的代理B1', 12, 'http://zf2.kongqikeji.com/demo2/pay.php', '113.118.192.17', NULL, '01fb688e0598f39d17cddb629742eefc', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', '{"pay_money":"1.00","money":"1.00","order_sn":"20191122152602853111","out_trade_sn":"201911221525494409","pay_order_sn":null,"sign":"db25cf375a5eaf57c769b400a729a50b","attach":"json","return_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/payreturn.php","notify_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/paynotify.php"}', 'success', 'demo718', 12, 100948, '定制服务00783', 'json', NULL, '2019-11-22 07:27:14', '20190301115051YMBtuG', '沙箱2016092500592678'),
(22, 13, '大股东B的代理B1', 22, 'http://zf2.kongqikeji.com/demo2/pay.php', '103.136.110.19', NULL, '3548dbb3916fea3b16dbf715fdd10490', '100.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', '{"pay_money":"100.00","money":"100.00","order_sn":"20191123200550973265","out_trade_sn":"201911232005275233","pay_order_sn":null,"sign":"8be3e5ae573f2c074147bdeb5500ca99","attach":"json","return_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/payreturn.php","notify_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/paynotify.php"}', 'success', 'demo879', 21, 100690, '定制服务00335', 'json', NULL, '2019-11-23 15:15:31', '20190301115051YMBtuG', '沙箱2016092500592678'),
(23, 13, '大股东B的代理B1', 23, 'http://zf2.kongqikeji.com/demo2/pay.php', '103.136.110.19', NULL, '65bdd0ed8e856342021d467bd783ca82', '100.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', '{"pay_money":"100.00","money":"100.00","order_sn":"20191123200837327969","out_trade_sn":"201911232007457531","pay_order_sn":null,"sign":"78af08a22cefff8c1b7260b9bacae408","attach":"json","return_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/payreturn.php","notify_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/paynotify.php"}', 'success', 'demo9', 22, 100358, '定制服务00645', 'json', NULL, '2019-11-23 15:15:34', '20190301115051YMBtuG', '测试支付宝固码支付'),
(24, 13, '大股东B的代理B1', 24, 'http://zf2.kongqikeji.com/demo2/pay.php', '123.139.114.87', NULL, '8896307efdca007cb07db43422cce463', '180.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', '{"pay_money":"180.00","money":"180.00","order_sn":"20191124001501199969","out_trade_sn":"201911240014463819","pay_order_sn":null,"sign":"c624546d271e32d274bf4e01c9ed78cd","attach":"json","return_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/payreturn.php","notify_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/paynotify.php"}', 'success', 'demo531', 23, 100869, '定制服务00284', 'json', NULL, '2019-11-23 18:43:38', '20190301115051YMBtuG', '微信支付固码测试'),
(30, 13, '大股东B的代理B1', 30, 'http://zf2.kongqikeji.com/demo2/pay.php', '114.240.116.50', NULL, '29f0f1d85b8f0954ffc716ec34e0aa57', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', '{"pay_money":"1.00","money":"1.00","order_sn":"20191125093902915363","out_trade_sn":"201911250938440102","pay_order_sn":null,"sign":"4788f013811eefe97019df6eaf05ef7e","attach":"json","return_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/payreturn.php","notify_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/paynotify.php"}', 'success', 'demo125', 29, 100566, '定制服务00575', 'json', NULL, '2019-11-25 02:47:32', '20190301115051YMBtuG', '沙箱2016092500592678'),
(36, 13, '大股东B的代理B1', 36, 'http://zf2.kongqikeji.com/demo2/pay.php', '180.191.154.172', NULL, '5b91a1600f83ec05f9a5ecb72f1f4936', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', '{"pay_money":"1.00","money":"1.00","order_sn":"20191125205316781590","out_trade_sn":"201911252052498868","pay_order_sn":null,"sign":"08818a61b361c988fe6b5e4f0919461e","attach":"json","return_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/payreturn.php","notify_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/paynotify.php"}', 'success', 'demo271', 36, 1005, '定制服务00515', 'json', NULL, '2019-11-25 13:50:28', '20190301115051YMBtuG', '测试支付宝固码支付'),
(39, 13, '大股东B的代理B1', 39, 'http://zf2.kongqikeji.com/demo2/pay.php', '123.1.184.251', NULL, '68b5818f657b5d50741d5160e46a842b', '10.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', '{"pay_money":"10.00","money":"10.00","order_sn":"20191125223713800497","out_trade_sn":"201911252237004209","pay_order_sn":null,"sign":"a78e6c09c0499f67c6ec84bcd4039053","attach":"json","return_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/payreturn.php","notify_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/paynotify.php"}', 'success', 'demo619', 39, 100828, '定制服务00607', 'json', NULL, '2019-11-25 14:41:45', '20190301115051YMBtuG', '微信支付固码测试'),
(43, 13, '大股东B的代理B1', 43, 'http://zf2.kongqikeji.com/demo2/pay.php', '115.171.85.71', NULL, '2fc8003d26b7e85dd5a41edd45657ac2', '111.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', '{"pay_money":"111.00","money":"111.00","order_sn":"20191126184148839412","out_trade_sn":"201911261841374674","pay_order_sn":null,"sign":"ac41d8e58a82b16d59a807f10900d043","attach":"json","return_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/payreturn.php","notify_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/paynotify.php"}', 'success', 'demo352', 44, 100806, '定制服务00919', 'json', NULL, '2019-11-26 10:46:52', '20190301115051YMBtuG', '沙箱2016092500592678'),
(50, 13, '大股东B的代理B1', 50, 'http://zf2.kongqikeji.com/demo2/pay.php', '113.87.15.83', NULL, '4be80c3c6f6b640cf4d4f5b30e8c170c', '100.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', '{"pay_money":"100.00","money":"100.00","order_sn":"20191128002218948241","out_trade_sn":"201911280021539780","pay_order_sn":null,"sign":"3337de9209553f79bcea4d7a7e3e012a","attach":"json","return_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/payreturn.php","notify_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/paynotify.php"}', 'success', 'demo712', 52, 100501, '定制服务00220', 'json', NULL, '2019-11-27 17:33:23', '20190301115051YMBtuG', '沙箱2016092500592678'),
(53, 13, '大股东B的代理B1', 53, 'http://zf2.kongqikeji.com/demo2/pay.php', '1.202.169.226', NULL, 'b61c2a5b08f320638bb08ef364176e19', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', '{"pay_money":"1.00","money":"1.00","order_sn":"20191128093944740209","out_trade_sn":"201911280939222418","pay_order_sn":null,"sign":"5816bf519984fcc51ebffc9c2562c8d5","attach":"json","return_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/payreturn.php","notify_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/paynotify.php"}', 'success', 'demo971', 55, 100242, '定制服务00874', 'json', NULL, '2019-11-28 01:45:53', '20190301115051YMBtuG', '沙箱2016092500592678'),
(54, 13, '大股东B的代理B1', 54, 'http://zf2.kongqikeji.com/demo2/pay.php', '125.122.191.235', NULL, '4181481cce5a4ab4b1d9193f9dff36dd', '111.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', '{"pay_money":"111.00","money":"111.00","order_sn":"20191128094308132171","out_trade_sn":"201911280942505538","pay_order_sn":null,"sign":"283a55d9158c8642a2994d75dc6af408","attach":"json","return_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/payreturn.php","notify_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/paynotify.php"}', 'success', 'demo479', 56, 100415, '定制服务00439', 'json', NULL, '2019-11-28 01:45:45', '20190301115051YMBtuG', '沙箱2016092500592678'),
(58, 13, '大股东B的代理B1', 58, 'http://zf2.kongqikeji.com/demo2/pay.php', '110.53.228.12', NULL, '6f083485663960b0f8e382f51dc64ed3', '100.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', '{"pay_money":"100.00","money":"100.00","order_sn":"20191129144130425607","out_trade_sn":"201911291441098871","pay_order_sn":null,"sign":"9d877ff9b9a4ddc0778bc9c7345e30a0","attach":"json","return_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/payreturn.php","notify_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/paynotify.php"}', 'success', 'demo582', 60, 10016, '定制服务00771', 'json', NULL, '2019-11-29 06:45:56', '20190301115051YMBtuG', '沙箱2016092500592678'),
(64, 13, '大股东B的代理B1', 64, 'http://zf2.kongqikeji.com/demo2/pay.php', '121.237.143.36', NULL, 'b8b87110aeda86ea7254d10cb0c53871', '88.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', '{"pay_money":"88.00","money":"88.00","order_sn":"20191202140017602666","out_trade_sn":"201912021400034595","pay_order_sn":"2019120222001402241000048278","sign":"93fec3277d2405b860e35e6021983161","attach":"json","return_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/payreturn.php","notify_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/paynotify.php"}', 'success', 'demo393', 66, 100362, '定制服务00449', 'json', NULL, '2019-12-02 06:01:35', '20190301115051YMBtuG', '沙箱2016092500592678'),
(73, 13, '大股东B的代理B1', 73, 'http://zf2.kongqikeji.com/demo2/pay.php', '113.99.127.130', NULL, '90196cff2a1b7ae2884a9fe783ece0b6', '100.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', '{"pay_money":"100.00","money":"100.00","order_sn":"20191205003737602899","out_trade_sn":"201912050036587017","pay_order_sn":null,"sign":"946f12a2fc21c7114316ca0c83ed158c","attach":"json","return_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/payreturn.php","notify_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/paynotify.php"}', 'success', 'demo365', 75, 10078, '定制服务00102', 'json', NULL, '2019-12-04 16:38:35', '20190301115051YMBtuG', '固码支付'),
(82, 13, '大股东B的代理B1', 82, 'http://zf2.kongqikeji.com/demo2/pay.php', '220.176.214.49', NULL, '0412cd241a4170a9a0f61c170bc338a3', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', '{"pay_money":"1.00","money":"1.00","order_sn":"20191208222122749556","out_trade_sn":"201912082220431294","pay_order_sn":null,"sign":"cd28a6145f4f3aacd8fb3884f1e6da47","attach":"json","return_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/payreturn.php","notify_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/paynotify.php"}', 'success', 'demo60', 84, 100449, '定制服务00667', 'json', NULL, '2019-12-08 14:23:03', '20190301115051YMBtuG', '微信支付宝二合一固码支付'),
(83, 13, '大股东B的代理B1', 83, 'http://zf2.kongqikeji.com/demo2/pay.php', '103.89.179.146', NULL, 'fcff99b100e5758b311ee4c7374288b4', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo99', 85, 100147, '定制服务00258', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(84, 13, '大股东B的代理B1', 84, 'http://zf2.kongqikeji.com/demo2/pay.php', '119.86.44.220', NULL, '5645c5c57c06442a4a33cac268c2f8a2', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo133', 88, 100217, '定制服务00566', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(85, 13, '大股东B的代理B1', 85, 'http://zf2.kongqikeji.com/demo2/pay.php', '119.84.153.195', NULL, '8f2e8bb2e9fedc00c5c970cc780afdac', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo25', 89, 100663, '定制服务00143', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(86, 13, '大股东B的代理B1', 86, 'http://zf2.kongqikeji.com/demo2/pay.php', '223.71.234.66', NULL, '6d84372797c7e555b275660c9ca217d8', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', '{"pay_money":"1.00","money":"1.00","order_sn":"20191209111335403428","out_trade_sn":"201912091113243491","pay_order_sn":null,"sign":"4660b472d4aca581b36dddbe561ebfc5","attach":"json","return_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/payreturn.php","notify_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/paynotify.php"}', 'success', 'demo222', 90, 100601, '定制服务00762', 'json', NULL, '2019-12-09 03:14:14', '20190301115051YMBtuG', '沙箱2016092500592678'),
(87, 13, '大股东B的代理B1', 87, 'http://zf2.kongqikeji.com/demo2/pay.php', '121.32.183.243', NULL, '1412c10b0f24b79796f8fa9137d23b3d', '1.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo697', 91, 100222, '定制服务00358', 'json', NULL, NULL, '20190301115051YMBtuG', '微信支付宝二合一固码支付'),
(88, 13, '大股东B的代理B1', 88, 'http://zf2.kongqikeji.com/demo2/pay.php', '45.144.243.158', NULL, '56bb96f05270136b729e62f7d5360701', '100.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', NULL, NULL, 'demo741', 92, 100684, '定制服务00802', 'json', NULL, NULL, '20190301115051YMBtuG', '沙箱2016092500592678'),
(89, 13, '大股东B的代理B1', 89, 'http://zf2.kongqikeji.com/demo2/pay.php', '183.250.89.190', NULL, 'cde02bc70daf3f8176b175b1fd2bc931', '100.00', 'http://zf2.kongqikeji.com/demo2/payreturn.php', 'http://zf2.kongqikeji.com/demo2/paynotify.php', '{"pay_money":"100.00","money":"100.00","order_sn":"20191209135652138318","out_trade_sn":"201912091356140504","pay_order_sn":null,"sign":"4f83f42c1ba90453d8bc5f2e260174f9","attach":"json","return_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/payreturn.php","notify_url":"http:\\/\\/zf2.kongqikeji.com\\/demo2\\/paynotify.php"}', 'success', 'demo904', 93, 100617, '定制服务00800', 'json', NULL, '2019-12-09 05:59:55', '20190301115051YMBtuG', '微信支付宝二合一固码支付');
-- --------------------------------------------------------
--
-- 表的结构 `pay_for_logs`
--
CREATE TABLE IF NOT EXISTS `pay_for_logs` (
`id` int(10) unsigned NOT NULL,
`order_id` int(11) NOT NULL DEFAULT 0 COMMENT '订单id',
`order_sn` int(11) NOT NULL DEFAULT 0 COMMENT '订单编号',
`admin_id` int(11) NOT NULL DEFAULT 0 COMMENT '结算人id',
`admin_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '结算人名字',
`money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '结算金额',
`status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '结算状态',
`success_at` datetime DEFAULT NULL COMMENT '结算时间',
`out_trade_sn` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '来源订单编号',
`mark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `pay_logs`
--
CREATE TABLE IF NOT EXISTS `pay_logs` (
`id` int(10) unsigned NOT NULL,
`order_sn` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '订单编号',
`pay_order_sn` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '支付流水号',
`pay_status` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '支付状态',
`pay_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '充值金额',
`pay_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '充值类型类型:微信,支付宝,银行',
`data` varchar(2000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '返回数据',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `pay_logs`
--
INSERT INTO `pay_logs` (`id`, `order_sn`, `pay_order_sn`, `pay_status`, `pay_money`, `pay_type`, `data`, `created_at`, `updated_at`) VALUES
(1, '20191121172019937449', '2019112122001402241000040833', '1', '4444.00', 'alipay', '{"gmt_create":"2019-11-21 17:20:29","charset":"GBK","gmt_payment":"2019-11-21 17:20:38","notify_time":"2019-11-21 17:20:39","subject":"20191121172019937449\\u5b9a\\u5236","sign":"pa7mVNUPZfyDCq3\\/tgJH4nAWln7LxE\\/pkoi\\/2hR8vR69KD41qIvzY715U7pq1VQVYbRLcQV1ijlpgaqqBZTFhGe1o\\/f1yGmQvI24aVkTeZuii2oVKaVaRm\\/ek6eDXg7oKLL+FbG9fMEJAjQcrLKYrFSDkmkp1ly5vpYsaNcuBmlDD+mLV3dkgEaX3+0Y0naYhV6JwCGLewa9RUPxW6Z0my4E2NUESCJBnEBM1Ch2DXmdjr6yWHFw4vU0m6\\/BYeDIMTp+YZUe1k\\/eyYLxwWXv65cSpP7E8XWRm8OEF6m4VzNI4j7lO\\/Ko389osBLGIusSRwq9IJrHI9oikhdeiMeL5w==","buyer_id":"2088102179102241","invoice_amount":"4444.00","version":"1.0","notify_id":"2019112100222172039002241000595084","fund_bill_list":"[{\\"amount\\":\\"4444.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","out_trade_no":"20191121172019937449","total_amount":"4444.00","trade_status":"TRADE_SUCCESS","trade_no":"2019112122001402241000040833","auth_app_id":"2016092500592678","receipt_amount":"4444.00","point_amount":"0.00","app_id":"2016092500592678","buyer_pay_amount":"4444.00","sign_type":"RSA2","seller_id":"2088102177197621"}', '2019-11-21 09:20:40', NULL),
(2, '20191202140017602666', '2019120222001402241000048278', '1', '88.00', 'alipay', '{"gmt_create":"2019-12-02 14:01:25","charset":"GBK","gmt_payment":"2019-12-02 14:01:33","notify_time":"2019-12-02 14:01:34","subject":"20191202140017602666\\u5b9a\\u5236","sign":"cNCswmu94\\/dmm4hLjh41AzxJeepHyxsrfytspGf6wJ41BGvgjKOk2g5Wz8zlQgL2\\/tfVvNWNSq72mttDsANS7uHf9LBi9p2ckuUqLRX9MumNdEOJTrxBvTPT+sbMhiomQl+b8kIoLG6rgd0vK9TiW3OZjB0HiqzWA9wJZsBDtvqU8Nuw+av2WkaOSLlgf69pS8p4nc2swq+CbvkEJ1urnUGK+WHiQ3idxdArnRkEI\\/NpGE4ct3UWi+JXCUuGEai6Np\\/Ipq6sqZAzk07qveXdbGOo76XNlg\\/7+e5zmDR6iWv55vba4aT2MrYZxHQjEyeaENa3\\/+HM0Gl7ujC1\\/DL4Rg==","buyer_id":"2088102179102241","invoice_amount":"88.00","version":"1.0","notify_id":"2019120200222140134002241000603446","fund_bill_list":"[{\\"amount\\":\\"88.00\\",\\"fundChannel\\":\\"ALIPAYACCOUNT\\"}]","notify_type":"trade_status_sync","out_trade_no":"20191202140017602666","total_amount":"88.00","trade_status":"TRADE_SUCCESS","trade_no":"2019120222001402241000048278","auth_app_id":"2016092500592678","receipt_amount":"88.00","point_amount":"0.00","app_id":"2016092500592678","buyer_pay_amount":"88.00","sign_type":"RSA2","seller_id":"2088102177197621"}', '2019-12-02 06:01:35', NULL);
-- --------------------------------------------------------
--
-- 表的结构 `permissions`
--
CREATE TABLE IF NOT EXISTS `permissions` (
`id` int(10) unsigned NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '权限页面路径,控制器名字',
`cname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '中文名',
`guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '使用的类型admin,user',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `roles`
--
CREATE TABLE IF NOT EXISTS `roles` (
`id` int(10) unsigned NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色名称',
`guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '使用的类型admin,user',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `role_has_permissions`
--
CREATE TABLE IF NOT EXISTS `role_has_permissions` (
`permission_id` int(10) unsigned NOT NULL,
`role_id` int(10) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `system_commissions`
--
CREATE TABLE IF NOT EXISTS `system_commissions` (
`id` int(10) unsigned NOT NULL,
`merchant_id` int(11) NOT NULL COMMENT '商户id',
`gateway_id` int(11) NOT NULL COMMENT '通道id',
`order_id` int(10) unsigned NOT NULL COMMENT '订单ID',
`order_sn` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '订单号',
`order_money` decimal(8,2) NOT NULL COMMENT '订单价格',
`pay_money` decimal(8,2) NOT NULL COMMENT '支付价格',
`payfor_money` decimal(8,2) NOT NULL COMMENT '结算价格',
`ratio` int(11) NOT NULL DEFAULT 6 COMMENT '佣金比率',
`money` decimal(8,2) NOT NULL COMMENT '佣金',
`name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '佣金来源描述',
`data` varchar(5000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '其他信息',
`order_at` datetime DEFAULT NULL COMMENT '下单时间',
`pay_ok_at` datetime DEFAULT NULL COMMENT '支付成功时间',
`status` tinyint(4) NOT NULL DEFAULT 2 COMMENT '佣金状态:1交易成功,2处理中,3交易失败',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`gateway_money` decimal(8,2) NOT NULL DEFAULT 0.00 COMMENT '通道成本资金',
`final_money` decimal(8,2) NOT NULL DEFAULT 0.00 COMMENT '扣除通道成本后的资金',
`gateway_ratio` smallint(6) NOT NULL DEFAULT 6 COMMENT '通道费率',
`final_ratio` smallint(6) NOT NULL DEFAULT 6 COMMENT '最后盈利费率'
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `system_commissions`
--
INSERT INTO `system_commissions` (`id`, `merchant_id`, `gateway_id`, `order_id`, `order_sn`, `order_money`, `pay_money`, `payfor_money`, `ratio`, `money`, `name`, `data`, `order_at`, `pay_ok_at`, `status`, `created_at`, `updated_at`, `gateway_money`, `final_money`, `gateway_ratio`, `final_ratio`) VALUES
(1, 13, 2, 5, '20191121172019937449', '4444.00', '4444.00', '4221.80', 30, '133.32', '大股东B的代理B1的订单佣金', NULL, '2019-11-21 17:20:19', '2019-11-21 17:20:40', 1, '2019-11-21 09:20:40', '2019-11-21 09:20:40', '31.11', '102.21', 7, 23),
(2, 13, 2, 10, '20191122100405726528', '1.00', '1.00', '0.95', 30, '0.03', '大股东B的代理B1的订单佣金', NULL, '2019-11-22 10:04:05', '2019-11-22 10:24:43', 1, '2019-11-22 02:24:47', '2019-11-22 02:24:47', '0.01', '0.02', 7, 23),
(3, 13, 2, 12, '20191122152602853111', '1.00', '1.00', '0.95', 30, '0.03', '大股东B的代理B1的订单佣金', NULL, '2019-11-22 15:26:02', '2019-11-22 15:27:11', 1, '2019-11-22 07:27:14', '2019-11-22 07:27:14', '0.01', '0.02', 7, 23),
(4, 13, 2, 22, '20191123200550973265', '100.00', '100.00', '95.00', 30, '3.00', '大股东B的代理B1的订单佣金', NULL, '2019-11-23 20:05:50', '2019-11-23 23:15:28', 1, '2019-11-23 15:15:31', '2019-11-23 15:15:31', '0.70', '2.30', 7, 23),
(5, 13, 4, 23, '20191123200837327969', '100.00', '100.00', '95.00', 30, '3.00', '大股东B的代理B1的订单佣金', NULL, '2019-11-23 20:08:37', '2019-11-23 23:15:33', 1, '2019-11-23 15:15:34', '2019-11-23 15:15:34', '0.00', '3.00', 0, 30),
(6, 13, 5, 24, '20191124001501199969', '180.00', '180.00', '170.64', 32, '5.76', '大股东B的代理B1的订单佣金', NULL, '2019-11-24 00:15:01', '2019-11-24 02:43:34', 1, '2019-11-23 18:43:37', '2019-11-23 18:43:37', '3.24', '2.52', 18, 14),
(7, 13, 2, 30, '20191125093902915363', '1.00', '1.00', '0.95', 30, '0.03', '大股东B的代理B1的订单佣金', NULL, '2019-11-25 09:39:02', '2019-11-25 10:47:30', 1, '2019-11-25 02:47:32', '2019-11-25 02:47:32', '0.01', '0.02', 7, 23),
(8, 13, 4, 36, '20191125205316781590', '1.00', '1.00', '0.95', 30, '0.03', '大股东B的代理B1的订单佣金', NULL, '2019-11-25 20:53:16', '2019-11-25 21:50:27', 1, '2019-11-25 13:50:28', '2019-11-25 13:50:28', '0.00', '0.03', 0, 30),
(9, 13, 5, 39, '20191125223713800497', '10.00', '10.00', '9.48', 32, '0.32', '大股东B的代理B1的订单佣金', NULL, '2019-11-25 22:37:13', '2019-11-25 22:41:36', 1, '2019-11-25 14:41:45', '2019-11-25 14:41:45', '0.18', '0.14', 18, 14),
(10, 13, 2, 43, '20191126184148839412', '111.00', '111.00', '105.45', 30, '3.33', '大股东B的代理B1的订单佣金', NULL, '2019-11-26 18:41:48', '2019-11-26 18:46:47', 1, '2019-11-26 10:46:51', '2019-11-26 10:46:51', '0.78', '2.55', 7, 23),
(11, 13, 2, 50, '20191128002218948241', '100.00', '100.00', '95.00', 30, '3.00', '大股东B的代理B1的订单佣金', NULL, '2019-11-28 00:22:18', '2019-11-28 01:33:21', 1, '2019-11-27 17:33:23', '2019-11-27 17:33:23', '0.70', '2.30', 7, 23),
(12, 13, 2, 54, '20191128094308132171', '111.00', '111.00', '105.45', 30, '3.33', '大股东B的代理B1的订单佣金', NULL, '2019-11-28 09:43:08', '2019-11-28 09:45:39', 1, '2019-11-28 01:45:45', '2019-11-28 01:45:45', '0.78', '2.55', 7, 23),
(13, 13, 2, 53, '20191128093944740209', '1.00', '1.00', '0.95', 30, '0.03', '大股东B的代理B1的订单佣金', NULL, '2019-11-28 09:39:44', '2019-11-28 09:45:52', 1, '2019-11-28 01:45:53', '2019-11-28 01:45:53', '0.01', '0.02', 7, 23),
(14, 13, 2, 58, '20191129144130425607', '100.00', '100.00', '95.00', 30, '3.00', '大股东B的代理B1的订单佣金', NULL, '2019-11-29 14:41:30', '2019-11-29 14:45:53', 1, '2019-11-29 06:45:55', '2019-11-29 06:45:55', '0.70', '2.30', 7, 23),
(15, 13, 2, 64, '20191202140017602666', '88.00', '88.00', '83.60', 20, '1.76', '大股东B的代理B1的订单佣金', NULL, '2019-12-02 14:00:17', '2019-12-02 14:01:35', 1, '2019-12-02 06:01:35', '2019-12-02 06:01:35', '0.62', '1.14', 7, 13),
(16, 13, 3, 73, '20191205003737602899', '100.00', '100.00', '95.00', 20, '2.00', '大股东B的代理B1的订单佣金', NULL, '2019-12-05 00:37:37', '2019-12-05 00:38:34', 1, '2019-12-04 16:38:35', '2019-12-04 16:38:35', '1.50', '0.50', 15, 5),
(17, 13, 6, 82, '20191208222122749556', '1.00', '1.00', '0.95', 20, '0.02', '大股东B的代理B1的订单佣金', NULL, '2019-12-08 22:21:22', '2019-12-08 22:23:00', 1, '2019-12-08 14:23:02', '2019-12-08 14:23:02', '0.02', '0.00', 20, 0),
(18, 13, 2, 86, '20191209111335403428', '1.00', '1.00', '0.95', 20, '0.02', '大股东B的代理B1的订单佣金', NULL, '2019-12-09 11:13:35', '2019-12-09 11:14:11', 1, '2019-12-09 03:14:14', '2019-12-09 03:14:14', '0.01', '0.01', 7, 13),
(19, 13, 6, 89, '20191209135652138318', '100.00', '100.00', '95.00', 20, '2.00', '大股东B的代理B1的订单佣金', NULL, '2019-12-09 13:56:52', '2019-12-09 13:57:35', 1, '2019-12-09 05:59:55', '2019-12-09 05:59:55', '2.00', '0.00', 20, 0);
-- --------------------------------------------------------
--
-- 表的结构 `system_update_logs`
--
CREATE TABLE IF NOT EXISTS `system_update_logs` (
`id` int(10) unsigned NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '更新名称',
`intro` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '更新描述',
`type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`is_top` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否置顶',
`sort` smallint(6) NOT NULL DEFAULT 0 COMMENT '排序',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(10) unsigned NOT NULL,
`merchant_id` int(11) NOT NULL DEFAULT 0 COMMENT '服务商id,0表示本站',
`from_user_id` int(11) NOT NULL DEFAULT 0 COMMENT '外站来源uid',
`nickname` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '昵称',
`mobile` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '手机',
`email` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮箱',
`alipay_account` varchar(220) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '支付宝账号手机/邮箱',
`weixin_account` varchar(220) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信账号openid',
`password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '密码',
`login_status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '登陆状态:1启用，0禁用',
`last_number` int(11) NOT NULL DEFAULT 0 COMMENT '登陆次数',
`ip` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '登陆IP',
`host` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '来源域名',
`from_ip` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '注册IP',
`last_time` datetime DEFAULT NULL COMMENT '最后登陆时间',
`remember_token` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '记录登陆',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `users`
--
INSERT INTO `users` (`id`, `merchant_id`, `from_user_id`, `nickname`, `mobile`, `email`, `alipay_account`, `weixin_account`, `password`, `login_status`, `last_number`, `ip`, `host`, `from_ip`, `last_time`, `remember_token`, `created_at`, `updated_at`, `deleted_at`) VALUES
(2, 13, 100623, 'demo199', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '183.3.226.234', NULL, NULL, '2019-11-18 06:59:39', '2019-11-18 06:59:39', NULL),
(3, 13, 100184, 'demo456', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '183.3.226.234', NULL, NULL, '2019-11-18 07:00:23', '2019-11-18 07:00:23', NULL),
(4, 13, 100989, 'demo117', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '120.235.126.53', NULL, NULL, '2019-11-21 09:17:54', '2019-11-21 09:17:54', NULL),
(5, 13, 100460, 'demo242', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '120.235.126.53', NULL, NULL, '2019-11-21 09:20:19', '2019-11-21 09:20:19', NULL),
(6, 13, 100173, 'demo555', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '110.87.66.52', NULL, NULL, '2019-11-21 09:24:34', '2019-11-21 09:24:34', NULL),
(7, 13, 100901, 'demo596', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '110.87.66.52', NULL, NULL, '2019-11-21 09:27:13', '2019-11-21 09:27:13', NULL),
(8, 13, 100651, 'demo384', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '222.128.6.36', NULL, NULL, '2019-11-21 10:18:19', '2019-11-21 10:18:19', NULL),
(9, 13, 100621, 'demo926', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '183.156.54.149', NULL, NULL, '2019-11-22 01:18:45', '2019-11-22 01:18:45', NULL),
(10, 13, 100180, 'demo142', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '47.74.188.240', NULL, NULL, '2019-11-22 02:04:05', '2019-11-22 02:04:05', NULL),
(11, 13, 10089, 'demo956', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '103.216.43.146', NULL, NULL, '2019-11-22 02:29:13', '2019-11-22 02:29:13', NULL),
(12, 13, 100948, 'demo718', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '113.118.192.17', NULL, NULL, '2019-11-22 07:26:02', '2019-11-22 07:26:02', NULL),
(13, 13, 100934, 'demo995', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '183.62.22.202', NULL, NULL, '2019-11-22 08:09:59', '2019-11-22 08:09:59', NULL),
(14, 13, 100619, 'demo291', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '117.132.195.151', NULL, NULL, '2019-11-22 08:47:22', '2019-11-22 08:47:22', NULL),
(15, 13, 100474, 'demo857', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '222.82.207.252', NULL, NULL, '2019-11-22 08:48:57', '2019-11-22 08:48:57', NULL),
(16, 13, 100941, 'demo923', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '47.240.1.111', NULL, NULL, '2019-11-22 19:49:30', '2019-11-22 19:49:30', NULL),
(17, 13, 100351, 'demo708', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '223.157.159.238', NULL, NULL, '2019-11-23 01:23:24', '2019-11-23 01:23:24', NULL),
(18, 13, 100674, 'demo515', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '49.81.174.210', NULL, NULL, '2019-11-23 03:46:31', '2019-11-23 03:46:31', NULL),
(19, 13, 100855, 'demo315', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '39.128.13.244', NULL, NULL, '2019-11-23 04:11:24', '2019-11-23 04:11:24', NULL),
(20, 13, 100321, 'demo264', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '125.41.133.67', NULL, NULL, '2019-11-23 07:31:06', '2019-11-23 07:31:06', NULL),
(21, 13, 100690, 'demo879', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '103.136.110.19', NULL, NULL, '2019-11-23 12:05:50', '2019-11-23 12:05:50', NULL),
(22, 13, 100358, 'demo9', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '103.136.110.19', NULL, NULL, '2019-11-23 12:08:37', '2019-11-23 12:08:37', NULL),
(23, 13, 100869, 'demo531', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '123.139.114.87', NULL, NULL, '2019-11-23 16:15:01', '2019-11-23 16:15:01', NULL),
(24, 13, 100538, 'demo930', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '115.190.202.151', NULL, NULL, '2019-11-24 05:46:15', '2019-11-24 05:46:15', NULL),
(25, 13, 100479, 'demo305', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '118.113.97.68', NULL, NULL, '2019-11-24 06:45:12', '2019-11-24 06:45:12', NULL),
(26, 0, 0, 'asdas', NULL, NULL, NULL, NULL, '$2y$10$svU6dhzdQzJDiyGB/ZUQAeEW4UtqSsNdW5lmmuNNVWCis92JCV7si', 1, 0, '', NULL, NULL, NULL, NULL, '2019-11-24 07:51:27', '2019-11-24 07:51:27', NULL),
(27, 13, 100899, 'demo639', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '117.30.56.80', NULL, NULL, '2019-11-25 00:58:23', '2019-11-25 00:58:23', NULL),
(28, 13, 100579, 'demo402', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '110.87.118.223', NULL, NULL, '2019-11-25 00:59:48', '2019-11-25 00:59:48', NULL),
(29, 13, 100566, 'demo125', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '114.240.116.50', NULL, NULL, '2019-11-25 01:39:02', '2019-11-25 01:39:02', NULL),
(30, 13, 100696, 'demo239', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '171.83.4.123', NULL, NULL, '2019-11-25 03:44:03', '2019-11-25 03:44:03', NULL),
(31, 13, 10021, 'demo687', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '14.106.229.108', NULL, NULL, '2019-11-25 03:51:42', '2019-11-25 03:51:42', NULL),
(32, 13, 100807, 'demo458', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '101.226.225.85', NULL, NULL, '2019-11-25 09:09:57', '2019-11-25 09:09:57', NULL),
(33, 13, 100979, 'demo607', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '171.44.166.55', NULL, NULL, '2019-11-25 09:14:32', '2019-11-25 09:14:32', NULL),
(34, 13, 100357, 'demo248', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '27.41.92.167', NULL, NULL, '2019-11-25 09:34:38', '2019-11-25 09:34:38', NULL),
(35, 0, 0, 'admin', NULL, NULL, NULL, NULL, '$2y$10$sUJLZJajAf/QoIBAdCis/e5WsE3SZ67y71GEDawbTJFoeUj1XgO1u', 1, 0, '', NULL, NULL, NULL, NULL, '2019-11-25 09:36:49', '2019-11-25 09:36:49', NULL),
(36, 13, 1005, 'demo271', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '180.191.154.172', NULL, NULL, '2019-11-25 12:53:16', '2019-11-25 12:53:16', NULL),
(37, 13, 100943, 'demo243', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '123.1.184.251', NULL, NULL, '2019-11-25 14:34:29', '2019-11-25 14:34:29', NULL),
(38, 13, 1006, 'demo409', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '123.1.184.251', NULL, NULL, '2019-11-25 14:35:47', '2019-11-25 14:35:47', NULL),
(39, 13, 100828, 'demo619', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '123.1.184.251', NULL, NULL, '2019-11-25 14:37:13', '2019-11-25 14:37:13', NULL),
(40, 13, 100411, 'demo151', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '59.109.155.59', NULL, NULL, '2019-11-25 16:19:32', '2019-11-25 16:19:32', NULL),
(41, 0, 0, 'tttt', NULL, NULL, NULL, NULL, '$2y$10$bM6zzZyYajYzJgh1jTkh6.oTIvEV6s/ANiSCWniBbX.BSKTnTc7gW', 1, 0, '', NULL, NULL, NULL, 'dXIzInZHmCq8Q0F2BS9bx9UFCiOAaYYSSSdcEfLW0TTZJWy3n4UfOwcakcCP', '2019-11-25 21:55:57', '2019-11-25 21:55:57', NULL),
(42, 13, 100341, 'demo886', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '113.140.249.12', NULL, NULL, '2019-11-26 08:21:23', '2019-11-26 08:21:23', NULL),
(43, 13, 100421, 'demo996', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '110.184.161.113', NULL, NULL, '2019-11-26 09:42:25', '2019-11-26 09:42:25', NULL),
(44, 13, 100806, 'demo352', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '115.171.85.71', NULL, NULL, '2019-11-26 10:41:48', '2019-11-26 10:41:48', NULL),
(45, 13, 100467, 'demo232', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '59.41.65.222', NULL, NULL, '2019-11-26 10:48:10', '2019-11-26 10:48:10', NULL),
(46, 13, 100984, 'demo974', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '58.19.95.133', NULL, NULL, '2019-11-26 16:13:08', '2019-11-26 16:13:08', NULL),
(47, 13, 100346, 'demo299', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '113.185.40.35', NULL, NULL, '2019-11-26 18:58:04', '2019-11-26 18:58:04', NULL),
(48, 13, 100166, 'demo943', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '113.118.112.231', NULL, NULL, '2019-11-27 04:01:22', '2019-11-27 04:01:22', NULL),
(49, 13, 100285, 'demo777', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '113.87.195.14', NULL, NULL, '2019-11-27 06:56:54', '2019-11-27 06:56:54', NULL),
(50, 0, 0, '11', '333', '223', NULL, NULL, '$2y$10$xg5A3Yt5BQpQ8OKUaRKhOuEJbHo7v3aSDVVApgrl9PvYadV4FoZAK', 1, 0, '113.70.218.92', NULL, NULL, NULL, NULL, '2019-11-27 13:01:47', '2019-11-27 13:01:47', NULL),
(51, 13, 100956, 'demo889', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '60.176.149.245', NULL, NULL, '2019-11-27 16:04:47', '2019-11-27 16:04:47', NULL),
(52, 13, 100501, 'demo712', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '113.87.15.83', NULL, NULL, '2019-11-27 16:22:18', '2019-11-27 16:22:18', NULL),
(53, 13, 100125, 'demo747', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '110.184.65.24', NULL, NULL, '2019-11-28 00:59:45', '2019-11-28 00:59:45', NULL),
(54, 13, 100571, 'demo605', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '113.98.117.33', NULL, NULL, '2019-11-28 01:00:51', '2019-11-28 01:00:51', NULL),
(55, 13, 100242, 'demo971', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '1.202.169.226', NULL, NULL, '2019-11-28 01:39:44', '2019-11-28 01:39:44', NULL),
(56, 13, 100415, 'demo479', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '125.122.191.235', NULL, NULL, '2019-11-28 01:43:08', '2019-11-28 01:43:08', NULL),
(57, 13, 10055, 'demo660', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '120.197.20.160', NULL, NULL, '2019-11-28 03:59:47', '2019-11-28 03:59:47', NULL),
(58, 13, 100803, 'demo891', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '61.52.17.200', NULL, NULL, '2019-11-28 06:17:38', '2019-11-28 06:17:38', NULL),
(59, 13, 100981, 'demo466', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '123.186.127.96', NULL, NULL, '2019-11-28 13:15:34', '2019-11-28 13:15:34', NULL),
(60, 13, 10016, 'demo582', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '110.53.228.12', NULL, NULL, '2019-11-29 06:41:30', '2019-11-29 06:41:30', NULL),
(61, 13, 100952, 'demo818', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '138.19.130.249', NULL, NULL, '2019-11-29 08:13:29', '2019-11-29 08:13:29', NULL),
(62, 13, 100671, 'demo881', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '180.142.152.138', NULL, NULL, '2019-11-29 09:53:18', '2019-11-29 09:53:18', NULL),
(63, 13, 10034, 'demo477', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '123.117.17.148', NULL, NULL, '2019-11-29 11:45:48', '2019-11-29 11:45:48', NULL),
(64, 13, 100879, 'demo204', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '113.104.228.128', NULL, NULL, '2019-11-30 07:36:39', '2019-11-30 07:36:39', NULL),
(65, 13, 100808, 'demo719', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '117.181.198.205', NULL, NULL, '2019-11-30 18:30:11', '2019-11-30 18:30:11', NULL),
(66, 13, 100362, 'demo393', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '121.237.143.36', NULL, NULL, '2019-12-02 06:00:17', '2019-12-02 06:00:17', NULL),
(67, 0, 0, 'test123', '', '', NULL, NULL, '$2y$10$ZO9/28KucWekyEtJK/.tn.Rh4QF/YWMeTyQh4pgAuG2i.5r2MT/Ri', 1, 0, '117.28.246.18', NULL, NULL, NULL, NULL, '2019-12-02 07:35:55', '2019-12-02 07:35:55', NULL),
(68, 13, 100870, 'demo948', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '117.28.246.18', NULL, NULL, '2019-12-02 07:38:11', '2019-12-02 07:38:11', NULL),
(69, 13, 100504, 'demo89', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '125.70.229.227', NULL, NULL, '2019-12-02 07:43:09', '2019-12-02 07:43:09', NULL),
(70, 13, 100337, 'demo704', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '124.6.177.130', NULL, NULL, '2019-12-02 09:26:59', '2019-12-02 09:26:59', NULL),
(71, 13, 100273, 'demo929', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '27.38.37.82', NULL, NULL, '2019-12-02 12:10:05', '2019-12-02 12:10:05', NULL),
(72, 13, 100234, 'demo887', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '58.216.203.98', NULL, NULL, '2019-12-03 01:47:17', '2019-12-03 01:47:17', NULL),
(73, 13, 10011, 'demo684', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '113.118.85.104', NULL, NULL, '2019-12-04 03:20:28', '2019-12-04 03:20:28', NULL),
(74, 13, 100657, 'demo905', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '211.162.236.62', NULL, NULL, '2019-12-04 16:12:40', '2019-12-04 16:12:40', NULL),
(75, 13, 10078, 'demo365', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '113.99.127.130', NULL, NULL, '2019-12-04 16:37:37', '2019-12-04 16:37:37', NULL),
(76, 13, 10085, 'demo177', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '113.99.127.130', NULL, NULL, '2019-12-04 16:41:50', '2019-12-04 16:41:50', NULL),
(77, 13, 100982, 'demo929', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '183.236.87.106', NULL, NULL, '2019-12-06 07:58:45', '2019-12-06 07:58:45', NULL),
(78, 0, 0, 'kongqi', NULL, NULL, NULL, NULL, '$2y$10$EfUomXXkfTl5S9t0ffaMTOJbz9jGmVZDbNaKtaMuqcpoYkG8aiRSq', 1, 0, '', NULL, NULL, NULL, 'pk2oqTMm2xCyjWhamXew97MPEHyEu3r75nHYtSX2FB1B9YmlSWAQ2qqNyGic', '2019-12-06 09:27:41', '2019-12-06 09:27:41', NULL),
(79, 13, 100927, 'demo599', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '113.247.139.154', NULL, NULL, '2019-12-07 00:42:44', '2019-12-07 00:42:44', NULL),
(80, 13, 100249, 'demo37', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '110.87.117.255', NULL, NULL, '2019-12-07 06:17:35', '2019-12-07 06:17:35', NULL),
(81, 13, 100790, 'demo768', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '61.132.128.11', NULL, NULL, '2019-12-07 12:01:31', '2019-12-07 12:01:31', NULL),
(82, 13, 100412, 'demo12', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '106.86.209.234', NULL, NULL, '2019-12-07 14:18:48', '2019-12-07 14:18:48', NULL),
(83, 13, 100329, 'demo425', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '39.91.107.231', NULL, NULL, '2019-12-07 15:42:34', '2019-12-07 15:42:34', NULL),
(84, 13, 100449, 'demo60', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '220.176.214.49', NULL, NULL, '2019-12-08 14:21:22', '2019-12-08 14:21:22', NULL),
(85, 13, 100147, 'demo99', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '103.89.179.146', NULL, NULL, '2019-12-08 19:41:27', '2019-12-08 19:41:27', NULL),
(86, 0, 0, 'wfl1225', NULL, NULL, NULL, NULL, '$2y$10$586ctfTkPWYQH2zsswU0RuvcLgPU.TjtS6cXJ/4apysKJ/d3nja6G', 1, 0, '', NULL, NULL, NULL, 'UiuLFNVfcsFMPjOtppzTBp861IUsOI6DxGbg4PU2irEiGOiIcPapZFXCIBDq', '2019-12-08 20:29:16', '2019-12-08 20:29:16', NULL),
(87, 0, 0, 'zjcadmin', NULL, NULL, NULL, NULL, '$2y$10$LkJX/BnDzZLclZrN26R2rutAinTuxLc4BbxxIBg6Clhp8o3VDqyai', 1, 0, '', NULL, NULL, NULL, 'qPrt0fpmqflXpPiD7ks2mxq3Otj8LjR3NkGjQ6BzoOXWjq1EdOyB0iAmMVyy', '2019-12-08 20:35:18', '2019-12-08 20:35:18', NULL),
(88, 13, 100217, 'demo133', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '119.86.44.220', NULL, NULL, '2019-12-09 01:39:19', '2019-12-09 01:39:19', NULL),
(89, 13, 100663, 'demo25', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '119.84.153.195', NULL, NULL, '2019-12-09 01:40:34', '2019-12-09 01:40:34', NULL),
(90, 13, 100601, 'demo222', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '223.71.234.66', NULL, NULL, '2019-12-09 03:13:35', '2019-12-09 03:13:35', NULL),
(91, 13, 100222, 'demo697', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '121.32.183.243', NULL, NULL, '2019-12-09 03:14:34', '2019-12-09 03:14:34', NULL),
(92, 13, 100684, 'demo741', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '45.144.243.158', NULL, NULL, '2019-12-09 03:26:39', '2019-12-09 03:26:39', NULL),
(93, 13, 100617, 'demo904', NULL, NULL, NULL, NULL, NULL, 1, 0, '', NULL, '183.250.89.190', NULL, NULL, '2019-12-09 05:56:52', '2019-12-09 05:56:52', NULL);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `admin_logs`
--
ALTER TABLE `admin_logs`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `articles`
--
ALTER TABLE `articles`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `banks`
--
ALTER TABLE `banks`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `bank_rels`
--
ALTER TABLE `bank_rels`
ADD PRIMARY KEY (`id`),
ADD KEY `bank_rels_model_type_model_id_index` (`model_type`,`model_id`);
--
-- Indexes for table `banners`
--
ALTER TABLE `banners`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
ADD PRIMARY KEY (`id`),
ADD KEY `categories_type_index` (`type`),
ADD KEY `categories_ename_index` (`ename`),
ADD KEY `categories_parent_id_index` (`parent_id`);
--
-- Indexes for table `configs`
--
ALTER TABLE `configs`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `configs_ename_unique` (`ename`);
--
-- Indexes for table `draw_moneys`
--
ALTER TABLE `draw_moneys`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `draw_sets`
--
ALTER TABLE `draw_sets`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `files`
--
ALTER TABLE `files`
ADD PRIMARY KEY (`id`),
ADD KEY `files_user_type_user_id_index` (`user_type`,`user_id`);
--
-- Indexes for table `gateways`
--
ALTER TABLE `gateways`
ADD PRIMARY KEY (`id`),
ADD KEY `gateways_ename_index` (`ename`);
--
-- Indexes for table `gateway_winds`
--
ALTER TABLE `gateway_winds`
ADD PRIMARY KEY (`id`),
ADD KEY `gateway_winds_gateway_id_day_index` (`gateway_id`,`day`);
--
-- Indexes for table `goods`
--
ALTER TABLE `goods`
ADD PRIMARY KEY (`id`),
ADD KEY `goods_category_id_index` (`category_id`);
--
-- Indexes for table `hande_do_logs`
--
ALTER TABLE `hande_do_logs`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `merchants`
--
ALTER TABLE `merchants`
ADD PRIMARY KEY (`id`),
ADD KEY `merchants_app_key_index` (`app_key`),
ADD KEY `merchants_token_index` (`token`);
--
-- Indexes for table `merchant_commissions`
--
ALTER TABLE `merchant_commissions`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `merchant_logs`
--
ALTER TABLE `merchant_logs`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `merchant_money_logs`
--
ALTER TABLE `merchant_money_logs`
ADD PRIMARY KEY (`id`),
ADD KEY `merchant_money_logs_merchant_id_index` (`merchant_id`),
ADD KEY `merchant_money_logs_order_type_index` (`order_type`);
--
-- Indexes for table `merchant_orders`
--
ALTER TABLE `merchant_orders`
ADD PRIMARY KEY (`id`),
ADD KEY `merchant_orders_order_sn_index` (`order_sn`);
--
-- Indexes for table `merchant_ratios`
--
ALTER TABLE `merchant_ratios`
ADD PRIMARY KEY (`id`),
ADD KEY `merchant_ratios_parent_id_merchant_id_index` (`parent_id`,`merchant_id`);
--
-- Indexes for table `merchant_regists`
--
ALTER TABLE `merchant_regists`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `merchant_regist_tokens`
--
ALTER TABLE `merchant_regist_tokens`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `merchant_regist_tokens_regist_token_unique` (`regist_token`);
--
-- Indexes for table `merchant_wallets`
--
ALTER TABLE `merchant_wallets`
ADD PRIMARY KEY (`id`),
ADD KEY `merchant_wallets_merchant_id_index` (`merchant_id`);
--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
ADD KEY `model_has_permissions_model_type_model_id_index` (`model_type`,`model_id`);
--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
ADD KEY `model_has_roles_model_type_model_id_index` (`model_type`,`model_id`);
--
-- Indexes for table `notice_articles`
--
ALTER TABLE `notice_articles`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `notify_logs`
--
ALTER TABLE `notify_logs`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
ADD PRIMARY KEY (`id`),
ADD KEY `orders_merchant_id_index` (`merchant_id`),
ADD KEY `orders_out_trade_sn_index` (`out_trade_sn`),
ADD KEY `orders_order_sn_index` (`order_sn`),
ADD KEY `orders_pay_ok_at_index` (`pay_ok_at`),
ADD KEY `orders_order_at_index` (`order_at`),
ADD KEY `orders_notify_status_index` (`notify_status`),
ADD KEY `orders_pay_ok_at_pay_status_notify_status_index` (`pay_ok_at`,`pay_status`,`notify_status`);
--
-- Indexes for table `order_dels`
--
ALTER TABLE `order_dels`
ADD PRIMARY KEY (`id`),
ADD KEY `order_dels_merchant_id_index` (`merchant_id`),
ADD KEY `order_dels_out_trade_sn_index` (`out_trade_sn`),
ADD KEY `order_dels_order_sn_index` (`order_sn`),
ADD KEY `order_dels_pay_ok_at_index` (`pay_ok_at`),
ADD KEY `order_dels_order_at_index` (`order_at`),
ADD KEY `order_dels_notify_status_index` (`notify_status`),
ADD KEY `order_dels_pay_ok_at_pay_status_notify_status_index` (`pay_ok_at`,`pay_status`,`notify_status`);
--
-- Indexes for table `order_del_infos`
--
ALTER TABLE `order_del_infos`
ADD PRIMARY KEY (`id`),
ADD KEY `order_del_infos_order_id_index` (`order_id`),
ADD KEY `order_del_infos_merchant_id_index` (`merchant_id`);
--
-- Indexes for table `order_handle_logs`
--
ALTER TABLE `order_handle_logs`
ADD PRIMARY KEY (`id`),
ADD KEY `order_handle_logs_order_id_index` (`order_id`);
--
-- Indexes for table `order_infos`
--
ALTER TABLE `order_infos`
ADD PRIMARY KEY (`id`),
ADD KEY `order_infos_order_id_index` (`order_id`),
ADD KEY `order_infos_merchant_id_index` (`merchant_id`);
--
-- Indexes for table `pay_for_logs`
--
ALTER TABLE `pay_for_logs`
ADD PRIMARY KEY (`id`),
ADD KEY `pay_for_logs_order_id_index` (`order_id`),
ADD KEY `pay_for_logs_admin_id_index` (`admin_id`),
ADD KEY `pay_for_logs_order_sn_index` (`order_sn`);
--
-- Indexes for table `pay_logs`
--
ALTER TABLE `pay_logs`
ADD PRIMARY KEY (`id`),
ADD KEY `pay_logs_order_sn_index` (`order_sn`);
--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
ADD PRIMARY KEY (`permission_id`,`role_id`),
ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);
--
-- Indexes for table `system_commissions`
--
ALTER TABLE `system_commissions`
ADD PRIMARY KEY (`id`),
ADD KEY `system_commissions_merchant_id_index` (`merchant_id`),
ADD KEY `system_commissions_order_id_index` (`order_id`);
--
-- Indexes for table `system_update_logs`
--
ALTER TABLE `system_update_logs`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`),
ADD KEY `users_merchant_id_index` (`merchant_id`),
ADD KEY `users_nickname_index` (`nickname`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `admin_logs`
--
ALTER TABLE `admin_logs`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=75;
--
-- AUTO_INCREMENT for table `articles`
--
ALTER TABLE `articles`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `banks`
--
ALTER TABLE `banks`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `bank_rels`
--
ALTER TABLE `bank_rels`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `banners`
--
ALTER TABLE `banners`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `configs`
--
ALTER TABLE `configs`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=63;
--
-- AUTO_INCREMENT for table `draw_moneys`
--
ALTER TABLE `draw_moneys`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `draw_sets`
--
ALTER TABLE `draw_sets`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `files`
--
ALTER TABLE `files`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `gateways`
--
ALTER TABLE `gateways`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `gateway_winds`
--
ALTER TABLE `gateway_winds`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `goods`
--
ALTER TABLE `goods`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `hande_do_logs`
--
ALTER TABLE `hande_do_logs`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `merchants`
--
ALTER TABLE `merchants`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT for table `merchant_commissions`
--
ALTER TABLE `merchant_commissions`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT for table `merchant_logs`
--
ALTER TABLE `merchant_logs`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `merchant_money_logs`
--
ALTER TABLE `merchant_money_logs`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=39;
--
-- AUTO_INCREMENT for table `merchant_orders`
--
ALTER TABLE `merchant_orders`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `merchant_ratios`
--
ALTER TABLE `merchant_ratios`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=23;
--
-- AUTO_INCREMENT for table `merchant_regists`
--
ALTER TABLE `merchant_regists`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `merchant_regist_tokens`
--
ALTER TABLE `merchant_regist_tokens`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `merchant_wallets`
--
ALTER TABLE `merchant_wallets`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=69;
--
-- AUTO_INCREMENT for table `notice_articles`
--
ALTER TABLE `notice_articles`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `notify_logs`
--
ALTER TABLE `notify_logs`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=90;
--
-- AUTO_INCREMENT for table `order_dels`
--
ALTER TABLE `order_dels`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `order_del_infos`
--
ALTER TABLE `order_del_infos`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=66;
--
-- AUTO_INCREMENT for table `order_handle_logs`
--
ALTER TABLE `order_handle_logs`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `order_infos`
--
ALTER TABLE `order_infos`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=90;
--
-- AUTO_INCREMENT for table `pay_for_logs`
--
ALTER TABLE `pay_for_logs`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pay_logs`
--
ALTER TABLE `pay_logs`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `system_commissions`
--
ALTER TABLE `system_commissions`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT for table `system_update_logs`
--
ALTER TABLE `system_update_logs`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=94;
--
-- 限制导出的表
--
--
-- 限制表 `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;
--
-- 限制表 `model_has_roles`
--
ALTER TABLE `model_has_roles`
ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
--
-- 限制表 `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
/*!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 */;
Reference in New Issue View Git Blame Copy Permalink