-- phpMyAdmin SQL Dump -- version 4.8.3 -- https://www.phpmyadmin.net/ -- -- 主机： web-mysql -- 生成日期： 2022-04-15 13:35:22 -- 服务器版本： 10.1.32-MariaDB -- PHP 版本： 7.3.22 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; 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 */; -- -- 数据库： `churen` -- CREATE DATABASE IF NOT EXISTS `churen` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; USE `churen`; -- -------------------------------------------------------- -- -- 表的结构 `churen_option_account` -- DROP TABLE IF EXISTS `churen_option_account`; CREATE TABLE `churen_option_account` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `mid` int(11) NOT NULL DEFAULT '0' COMMENT '姓名', `is_email` tinyint(1) NOT NULL DEFAULT '2' COMMENT '邮箱认证', `send_email` tinyint(1) NOT NULL DEFAULT '2' COMMENT '是否发送邮件', `email` varchar(150) DEFAULT NULL COMMENT '邮箱', `is_idcard` tinyint(1) NOT NULL DEFAULT '2' COMMENT '身份证资料', `idcard_front` varchar(150) DEFAULT NULL COMMENT '身份证正面', `idcard_back` varchar(150) DEFAULT NULL COMMENT '身份证背面', `audit` tinyint(1) NOT NULL DEFAULT '1' COMMENT '审核状况', `audit_desc` varchar(500) DEFAULT NULL COMMENT '审核备注', `audit_date` int(11) NOT NULL DEFAULT '0' COMMENT '审核时间', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `stype` int(11) NOT NULL DEFAULT '-1' COMMENT '类型-仅用于展示类型', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_option_account` -- INSERT INTO `churen_option_account` (`id`, `mid`, `is_email`, `send_email`, `email`, `is_idcard`, `idcard_front`, `idcard_back`, `audit`, `audit_desc`, `audit_date`, `status`, `stype`, `state`, `cdate`) VALUES (1, 1, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (2, 2, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (3, 3, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (4, 4, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (5, 5, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (6, 6, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (7, 7, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (8, 8, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (9, 9, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (10, 10, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (11, 11, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (12, 12, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (13, 13, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (14, 14, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (15, 15, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (16, 16, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (17, 17, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (18, 18, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (19, 19, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (20, 20, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (21, 21, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (22, 22, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (23, 23, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (24, 24, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (25, 25, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (26, 26, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (27, 27, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (28, 28, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (29, 29, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (30, 30, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (31, 31, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (32, 32, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (33, 34, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (34, 35, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (35, 36, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (36, 37, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (37, 38, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (38, 39, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (39, 40, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (40, 41, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (41, 42, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (42, 43, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (43, 44, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (44, 45, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (45, 46, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (46, 47, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (47, 48, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (48, 49, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (49, 50, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (50, 51, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (51, 52, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (52, 53, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (53, 204, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668), (54, 225, 2, 2, NULL, 2, NULL, NULL, 1, NULL, 0, 1, -1, 1, 1650029668); -- -------------------------------------------------------- -- -- 表的结构 `churen_option_agreement` -- DROP TABLE IF EXISTS `churen_option_agreement`; CREATE TABLE `churen_option_agreement` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `aid` int(11) NOT NULL DEFAULT '-1' COMMENT '手机号', `order_num` varchar(100) DEFAULT NULL COMMENT '合同编号', `agreement_id` int(11) NOT NULL DEFAULT '0' COMMENT '合同模板ID', `agreement_name` varchar(500) DEFAULT NULL COMMENT '合同名称', `jiaofu_date` int(11) NOT NULL DEFAULT '0' COMMENT '交付时间', `jiaofu_total` float(11,2) NOT NULL DEFAULT '0.00' COMMENT '交付的总额', `jiaofu_qiquan` float(11,2) NOT NULL DEFAULT '0.00' COMMENT '交付的期权价值', `jiaofu_yuanshi` float(11,2) NOT NULL DEFAULT '0.00' COMMENT '交付的原始期权价值', `sign` varchar(150) DEFAULT NULL COMMENT '合同签名', `name` varchar(100) DEFAULT NULL COMMENT '姓名', `mobile` bigint(11) NOT NULL DEFAULT '0' COMMENT '手机号', `idcard` varchar(32) DEFAULT NULL COMMENT '身份证号码', `idcard_front` varchar(150) DEFAULT NULL COMMENT '身份证正面', `idcard_back` varchar(150) DEFAULT NULL COMMENT '身份证背面', `address` varchar(800) DEFAULT NULL COMMENT '地址', `qdate` int(11) NOT NULL DEFAULT '0' COMMENT '协议签订时间', `sdate` int(11) NOT NULL DEFAULT '0' COMMENT '有效期开始时间', `edate` int(11) NOT NULL DEFAULT '0' COMMENT '有效期结束时间', `udate` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间', `content` text COMMENT '合同内容', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '合同状态', `audit` tinyint(1) NOT NULL DEFAULT '1' COMMENT '审核状态', `audit_desc` varchar(500) DEFAULT NULL COMMENT '审核备注', `audit_date` int(11) NOT NULL DEFAULT '0' COMMENT '审核时间', `audit_admin` int(11) NOT NULL DEFAULT '0' COMMENT '操作人', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '操作时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- 表的结构 `churen_option_bill_duifu` -- DROP TABLE IF EXISTS `churen_option_bill_duifu`; CREATE TABLE `churen_option_bill_duifu` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `order_num` varchar(100) DEFAULT NULL COMMENT '流水号', `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '交易类型', `aid` int(11) NOT NULL DEFAULT '-1' COMMENT '主账号手机号', `mid` int(11) NOT NULL DEFAULT '-1' COMMENT '子账号手机号', `cash` float(11,2) NOT NULL DEFAULT '0.00' COMMENT '兑付价值', `yue` float(11,2) NOT NULL DEFAULT '0.00' COMMENT '兑付后价值', `status` tinyint(1) NOT NULL DEFAULT '2' COMMENT '是否生效', `audit` tinyint(1) NOT NULL DEFAULT '1' COMMENT '审核', `audit_desc` varchar(500) DEFAULT NULL COMMENT '备注', `audit_date` int(11) NOT NULL DEFAULT '0' COMMENT '审核时间', `audit_admin` int(11) NOT NULL DEFAULT '0' COMMENT '操作人', `desc` varchar(500) DEFAULT NULL COMMENT '备注说明', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '处理时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- 表的结构 `churen_option_bill_fafang` -- DROP TABLE IF EXISTS `churen_option_bill_fafang`; CREATE TABLE `churen_option_bill_fafang` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `order_num` varchar(100) DEFAULT NULL COMMENT '流水号', `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '交易类型', `aid` int(11) NOT NULL DEFAULT '-1' COMMENT '主账号手机号', `mid` int(11) NOT NULL DEFAULT '-1' COMMENT '子账号手机号', `cash` float(11,2) NOT NULL DEFAULT '0.00' COMMENT '发放价值', `yue` float(11,2) NOT NULL DEFAULT '0.00' COMMENT '发放后价值', `status` tinyint(1) NOT NULL DEFAULT '2' COMMENT '是否生效', `audit` tinyint(1) NOT NULL DEFAULT '1' COMMENT '审核', `audit_desc` varchar(500) DEFAULT NULL COMMENT '备注', `audit_date` int(11) NOT NULL DEFAULT '0' COMMENT '审核时间', `audit_admin` int(11) NOT NULL DEFAULT '0' COMMENT '操作人', `desc` varchar(500) DEFAULT NULL COMMENT '备注说明', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '处理时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- 表的结构 `churen_option_bill_jiaofu` -- DROP TABLE IF EXISTS `churen_option_bill_jiaofu`; CREATE TABLE `churen_option_bill_jiaofu` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `order_num` varchar(100) DEFAULT NULL COMMENT '流水号', `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '交易类型', `aid` int(11) NOT NULL DEFAULT '-1' COMMENT '主账号手机号', `mid` int(11) NOT NULL DEFAULT '-1' COMMENT '子账号手机号', `cash` float(11,2) NOT NULL DEFAULT '0.00' COMMENT '期权操作', `sign` varchar(150) DEFAULT NULL COMMENT '签字', `agreement_id` int(11) NOT NULL DEFAULT '0' COMMENT '合同ID', `status` tinyint(1) NOT NULL DEFAULT '2' COMMENT '交付确认', `audit` tinyint(1) NOT NULL DEFAULT '1' COMMENT '审核', `audit_desc` varchar(500) DEFAULT NULL COMMENT '审核备注', `audit_date` int(11) NOT NULL DEFAULT '0' COMMENT '审核时间', `audit_admin` int(11) NOT NULL DEFAULT '0' COMMENT '操作人', `desc` varchar(500) DEFAULT NULL COMMENT '备注说明', `qdate` int(11) NOT NULL DEFAULT '0' COMMENT '确认时间', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '处理时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_option_bill_jiaofu` -- INSERT INTO `churen_option_bill_jiaofu` (`id`, `order_num`, `type`, `aid`, `mid`, `cash`, `sign`, `agreement_id`, `status`, `audit`, `audit_desc`, `audit_date`, `audit_admin`, `desc`, `qdate`, `state`, `cdate`) VALUES (1, 'J202204152967213054389094', 1, 1, 1, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '创服代理商', 0, 1, 1650029672), (2, 'J202204152967215203132685', 1, 2, 2, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '创服代理商', 0, 1, 1650029672), (3, 'J202204152967215660431044', 1, 3, 3, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '创服代理商', 0, 1, 1650029672), (4, 'J202204152967216122338652', 1, 4, 4, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '创服代理商', 0, 1, 1650029672), (5, 'J202204152967216580700177', 1, 5, 5, 40000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (6, 'J202204152967217103543325', 1, 6, 6, 188750.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (7, 'J202204152967217591986591', 1, 7, 7, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (8, 'J202204152967218107750409', 1, 8, 8, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (9, 'J202204152967218669604501', 1, 9, 9, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (10, 'J202204152967219156457511', 1, 10, 10, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '创服代理商', 0, 1, 1650029672), (11, 'J202204152967219709236462', 1, 11, 11, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (12, 'J202204152967220264252158', 1, 12, 12, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (13, 'J202204152967220708846756', 1, 13, 13, 300000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (14, 'J202204152967221197892940', 1, 14, 14, 50000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (15, 'J202204152967221636704030', 1, 15, 15, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (16, 'J202204152967222079356984', 1, 16, 16, 100000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (17, 'J202204152967222526586434', 1, 17, 17, 50000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (18, 'J202204152967222972911646', 1, 18, 18, 600000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (19, 'J202204152967223475603550', 1, 19, 19, 36000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (20, 'J202204152967223919910181', 1, 20, 20, 36000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (21, 'J202204152967224386499749', 1, 21, 21, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (22, 'J202204152967224841683858', 1, 22, 22, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (23, 'J202204152967225295505804', 1, 23, 23, 50000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (24, 'J202204152967225735276532', 1, 24, 24, 35000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (25, 'J202204152967226171145418', 1, 25, 25, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '创服代理商', 0, 1, 1650029672), (26, 'J202204152967226656751303', 1, 26, 26, 50000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (27, 'J202204152967227105166054', 1, 27, 27, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (28, 'J202204152967227584212196', 1, 28, 28, 40000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (29, 'J202204152967228026349549', 1, 29, 29, 1000000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (30, 'J202204152967228469493210', 1, 30, 30, 50000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (31, 'J202204152967228907970810', 1, 31, 31, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (32, 'J202204152967229343295144', 1, 32, 32, 150000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (33, 'J202204152967229837977546', 1, 33, 34, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '创服代理商', 0, 1, 1650029672), (34, 'J202204152967230289168798', 1, 34, 35, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (35, 'J202204152967230742522501', 1, 35, 36, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '创服代理商', 0, 1, 1650029672), (36, 'J202204152967231181598053', 1, 36, 37, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '创服代理商', 0, 1, 1650029672), (37, 'J202204152967231623765684', 1, 37, 38, 300000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (38, 'J202204152967232075224801', 1, 38, 39, 56000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (39, 'J202204152967232565622136', 1, 39, 40, 55000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (40, 'J202204152967233063487801', 1, 40, 41, 100000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (41, 'J202204152967233497540704', 1, 41, 42, 300000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (42, 'J202204152967233973436884', 1, 42, 43, 200000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (43, 'J202204152967234423461395', 1, 43, 44, 180000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (44, 'J202204152967234910350147', 1, 44, 45, 56000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (45, 'J202204152967235384477930', 1, 45, 46, 271000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (46, 'J202204152967235897680700', 1, 46, 47, 56000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (47, 'J202204152967236350423423', 1, 47, 48, 300000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (48, 'J202204152967236837938916', 1, 48, 49, 55000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (49, 'J202204152967237278429657', 1, 49, 50, 300000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (50, 'J202204152967237727675234', 1, 51, 52, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '创服代理商', 0, 1, 1650029672), (51, 'J202204152967238171244365', 1, 52, 53, 150000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (52, 'J202204152967238656503446', 1, 47, 54, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (53, 'J202204152967239123721357', 1, 47, 55, 300000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (54, 'J202204152967239565135220', 1, 47, 56, 50000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (55, 'J202204152967240031204059', 1, 47, 57, 2500.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (56, 'J202204152967240479972228', 1, 7, 58, 25000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (57, 'J202204152967240941467130', 1, 7, 59, 140000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (58, 'J202204152967241442180097', 1, 7, 60, 25000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (59, 'J202204152967241900476927', 1, 7, 61, 105000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (60, 'J202204152967242344916066', 1, 7, 62, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (61, 'J202204152967242817643170', 1, 7, 63, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (62, 'J202204152967243324701298', 1, 7, 64, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (63, 'J202204152967243840314746', 1, 7, 65, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (64, 'J202204152967244302352567', 1, 7, 66, 140000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (65, 'J202204152967244785231021', 1, 7, 67, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (66, 'J202204152967245263331613', 1, 7, 68, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (67, 'J202204152967245735721491', 1, 7, 69, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (68, 'J202204152967246238483874', 1, 7, 70, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (69, 'J202204152967246720224703', 1, 7, 71, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (70, 'J202204152967247180481458', 1, 7, 75, 36000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (71, 'J202204152967247646304040', 1, 7, 76, 60000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (72, 'J202204152967248123232443', 1, 7, 77, 60000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (73, 'J202204152967248590960528', 1, 7, 78, 400000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (74, 'J202204152967249112944236', 1, 7, 79, 60000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (75, 'J202204152967249597819799', 1, 7, 80, 60000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (76, 'J202204152967250107567176', 1, 7, 81, 60000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (77, 'J202204152967250590797033', 1, 7, 82, 60000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (78, 'J202204152967251092227626', 1, 7, 83, 60000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (79, 'J202204152967251562123614', 1, 7, 84, 60000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (80, 'J202204152967252064291188', 1, 7, 85, 400000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (81, 'J202204152967252535262446', 1, 7, 86, 400000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (82, 'J202204152967253113317819', 1, 7, 87, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (83, 'J202204152967253597495954', 1, 7, 88, 60000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (84, 'J202204152967254060189013', 1, 7, 89, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (85, 'J202204152967254574537419', 1, 7, 90, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (86, 'J202204152967255101848843', 1, 7, 91, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (87, 'J202204152967255583416938', 1, 7, 92, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (88, 'J202204152967256054167864', 1, 7, 93, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (89, 'J202204152967256520848498', 1, 7, 94, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (90, 'J202204152967256973761106', 1, 7, 95, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (91, 'J202204152967257469382499', 1, 7, 96, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (92, 'J202204152967257943636058', 1, 7, 97, 2500.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (93, 'J202204152967258421609626', 1, 7, 98, 2500.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (94, 'J202204152967258891832692', 1, 44, 99, 2500.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (95, 'J202204152967259368846571', 1, 44, 100, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (96, 'J202204152967259887464581', 1, 35, 101, 60000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (97, 'J202204152967260367902336', 1, 35, 102, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (98, 'J202204152967260858595838', 1, 35, 103, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (99, 'J202204152967261355726310', 1, 35, 104, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (100, 'J202204152967261887994562', 1, 35, 105, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (101, 'J202204152967262380938571', 1, 35, 106, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (102, 'J202204152967262889320049', 1, 35, 107, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (103, 'J202204152967263405986326', 1, 35, 108, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (104, 'J202204152967263942939557', 1, 35, 109, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (105, 'J202204152967264414834297', 1, 35, 110, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (106, 'J202204152967264958295866', 1, 35, 111, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (107, 'J202204152967265534161681', 1, 35, 112, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (108, 'J202204152967266031277907', 1, 35, 113, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (109, 'J202204152967266537686593', 1, 35, 114, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (110, 'J202204152967267095816311', 1, 35, 115, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (111, 'J202204152967267602604022', 1, 35, 116, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (112, 'J202204152967268091615116', 1, 35, 117, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (113, 'J202204152967268649264834', 1, 35, 118, 50000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (114, 'J202204152967269151741147', 1, 20, 119, 200000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (115, 'J202204152967269651331533', 1, 20, 120, 40000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (116, 'J202204152967270183568082', 1, 20, 121, 40000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (117, 'J202204152967270729346768', 1, 20, 122, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (118, 'J202204152967271215700891', 1, 10, 123, 150000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (119, 'J202204152967271720770435', 1, 8, 124, 50000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (120, 'J202204152967272277211666', 1, 36, 125, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '创服代理商', 0, 1, 1650029672), (121, 'J202204152967272773401041', 1, 36, 126, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '创服代理商', 0, 1, 1650029672), (122, 'J202204152967273278788810', 1, 18, 127, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '创服代理商', 0, 1, 1650029672), (123, 'J202204152967273768431861', 1, 46, 128, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (124, 'J202204152967274297219868', 1, 48, 129, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '创服代理商', 0, 1, 1650029672), (125, 'J202204152967274828780892', 1, 48, 130, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '创服代理商', 0, 1, 1650029672), (126, 'J202204152967275343449483', 1, 48, 131, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (127, 'J202204152967275910850762', 1, 22, 132, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (128, 'J202204152967276401532679', 1, 24, 133, 2500.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (129, 'J202204152967276880233186', 1, 24, 134, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (130, 'J202204152967277431100075', 1, 24, 135, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (131, 'J202204152967277983977201', 1, 31, 136, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (132, 'J202204152967278471892804', 1, 4, 137, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (133, 'J202204152967278949273716', 1, 4, 138, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (134, 'J202204152967279495185216', 1, 15, 139, 35000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (135, 'J202204152967279969365321', 1, 52, 140, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (136, 'J202204152967280437656503', 1, 52, 141, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '创服代理商', 0, 1, 1650029672), (137, 'J202204152967280930759026', 1, 52, 142, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (138, 'J202204152967281447685012', 1, 43, 143, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '创服代理商', 0, 1, 1650029672), (139, 'J202204152967281947851788', 1, 43, 144, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '创服代理商', 0, 1, 1650029672), (140, 'J202204152967282465759350', 1, 40, 145, 36000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (141, 'J202204152967282967896190', 1, 40, 146, 900000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (142, 'J202204152967283525178552', 1, 32, 147, 100000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (143, 'J202204152967284009726119', 1, 27, 148, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (144, 'J202204152967284522841283', 1, 27, 149, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (145, 'J202204152967285036428055', 1, 27, 150, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (146, 'J202204152967285512588256', 1, 27, 151, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (147, 'J202204152967285991584542', 1, 27, 152, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (148, 'J202204152967286461825200', 1, 27, 153, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (149, 'J202204152967286932192632', 1, 27, 154, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (150, 'J202204152967287470124956', 1, 27, 155, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (151, 'J202204152967287970143211', 1, 27, 156, 25000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (152, 'J202204152967288659176695', 1, 27, 157, 60000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (153, 'J202204152967289552330029', 1, 6, 158, 55000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (154, 'J202204152967290063692802', 1, 6, 160, 60000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (155, 'J202204152967290636518119', 1, 6, 161, 163750.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (156, 'J202204152967291179898493', 1, 21, 162, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (157, 'J202204152967291695680571', 1, 21, 163, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (158, 'J202204152967292265782322', 1, 21, 164, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (159, 'J202204152967292763406353', 1, 21, 165, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (160, 'J202204152967293272196456', 1, 23, 166, 300000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (161, 'J202204152967293786951021', 1, 23, 168, 100000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (162, 'J202204152967294348393206', 1, 3, 169, 600000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (163, 'J202204152967294855775579', 1, 14, 170, 56000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (164, 'J202204152967295363190093', 1, 14, 171, 60000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (165, 'J202204152967296267339088', 1, 17, 172, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (166, 'J202204152967296756674936', 1, 17, 173, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (167, 'J202204152967297256670771', 1, 38, 174, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (168, 'J202204152967297785706056', 1, 38, 175, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (169, 'J202204152967298317111903', 1, 38, 176, 60000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (170, 'J202204152967298821190834', 1, 38, 177, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (171, 'J202204152967299353634041', 1, 38, 178, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (172, 'J202204152967299892728413', 1, 38, 179, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (173, 'J202204152967300461358899', 1, 2, 180, 1000000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (174, 'J202204152967300994528326', 1, 29, 181, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '创服代理商', 0, 1, 1650029672), (175, 'J202204152967301568582623', 1, 29, 182, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '创服代理商', 0, 1, 1650029672), (176, 'J202204152967302128151425', 1, 1, 183, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (177, 'J202204152967302712672043', 1, 1, 184, 100000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (178, 'J202204152967303263161688', 1, 1, 185, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (179, 'J202204152967303797107129', 1, 1, 186, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (180, 'J202204152967304422662102', 1, 1, 187, 36000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (181, 'J202204152967304922617497', 1, 1, 188, 100000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (182, 'J202204152967305491194173', 1, 1, 189, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (183, 'J202204152967306005162638', 1, 1, 190, 60000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (184, 'J202204152967306522768699', 1, 1, 191, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (185, 'J202204152967307083654719', 1, 1, 192, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (186, 'J202204152967307645190428', 1, 1, 193, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (187, 'J202204152967308164128262', 1, 25, 194, 2500.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (188, 'J202204152967308743422913', 1, 25, 195, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (189, 'J202204152967309267990115', 1, 25, 196, 40000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (190, 'J202204152967309783503784', 1, 25, 197, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (191, 'J202204152967310376148535', 1, 25, 198, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (192, 'J202204152967310914723099', 1, 25, 199, 50000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (193, 'J202204152967311536842663', 1, 25, 200, 50000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (194, 'J202204152967312077201082', 1, 25, 201, 2500.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (195, 'J202204152967312677444629', 1, 25, 202, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (196, 'J202204152967313209172514', 1, 51, 203, 60000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (197, 'J202204152967313718984578', 1, 53, 204, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (198, 'J202204152967314274889976', 1, 33, 205, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (199, 'J202204152967314808577179', 1, 33, 206, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (200, 'J202204152967315346883726', 1, 12, 207, 300000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (201, 'J202204152967315912357033', 1, 50, 208, 600000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (202, 'J202204152967316422859830', 1, 41, 209, 36000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (203, 'J202204152967316956968655', 1, 41, 210, 3000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (204, 'J202204152967317535358081', 1, 41, 211, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (205, 'J202204152967318062158977', 1, 41, 212, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (206, 'J202204152967318567622789', 1, 41, 213, 50000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (207, 'J202204152967319250264969', 1, 41, 214, 50000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (208, 'J202204152967319808632540', 1, 41, 215, 56000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (209, 'J202204152967320420876124', 1, 41, 216, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (210, 'J202204152967320968186394', 1, 41, 217, 300000.00, NULL, 0, 2, 1, NULL, 0, 0, '区县代理商', 0, 1, 1650029672), (211, 'J202204152967321544160239', 1, 11, 218, 40000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672), (212, 'J202204152967322055617631', 1, 11, 219, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '创服代理商', 0, 1, 1650029672), (213, 'J202204152967322563661620', 1, 11, 220, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '创服代理商', 0, 1, 1650029672), (214, 'J202204152967323134211001', 1, 11, 221, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '创客代理商', 0, 1, 1650029672), (215, 'J202204152967323633751476', 2, 7, 7, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (216, 'J202204152967324131167161', 2, 7, 88, 1000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (217, 'J202204152967324739490504', 2, 7, 88, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (218, 'J202204152967325142734668', 2, 7, 66, 120000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (219, 'J202204152967325665427427', 2, 7, 75, 20000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (220, 'J202204152967326191552719', 2, 7, 86, 20000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (221, 'J202204152967326771561273', 2, 7, 78, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (222, 'J202204152967327277401500', 2, 7, 79, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (223, 'J202204152967327882615685', 2, 7, 81, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (224, 'J202204152967328449969422', 2, 7, 83, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (225, 'J202204152967329114810891', 2, 7, 88, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (226, 'J202204152967329655873332', 2, 7, 88, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (227, 'J202204152967330061618040', 2, 7, 61, 90000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (228, 'J202204152967330563862589', 2, 7, 88, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (229, 'J202204152967330959641110', 2, 7, 81, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (230, 'J202204152967331374451913', 2, 7, 84, 1000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (231, 'J202204152967331969858704', 2, 7, 59, 120000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (232, 'J202204152967332547554721', 2, 7, 58, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (233, 'J202204152967333137199730', 2, 7, 60, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (234, 'J202204152967333677370064', 2, 7, 84, 22000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (235, 'J202204152967334098207672', 2, 7, 7, 1000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (236, 'J202204152967334513556326', 2, 7, 82, 9000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (237, 'J202204152967335092908139', 2, 7, 82, 6000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (238, 'J202204152967335519447586', 2, 41, 217, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (239, 'J202204152967336061427646', 2, 41, 42, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (240, 'J202204152967336650307150', 2, 41, 42, 20000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (241, 'J202204152967337074572319', 2, 41, 211, 2000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (242, 'J202204152967337607642524', 2, 41, 42, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (243, 'J202204152967338029168494', 2, 41, 217, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (244, 'J202204152967338459363152', 2, 41, 211, 2000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (245, 'J202204152967338888149999', 2, 41, 42, 42000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (246, 'J202204152967339322335679', 2, 41, 42, 80000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (247, 'J202204152967339747703617', 2, 1, 1, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (248, 'J202204152967340358510237', 2, 1, 190, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (249, 'J202204152967340881505929', 2, 1, 189, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (250, 'J202204152967341373234078', 2, 1, 193, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (251, 'J202204152967341909523135', 2, 1, 1, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (252, 'J202204152967342301807428', 2, 1, 1, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (253, 'J202204152967342698532285', 2, 1, 184, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (254, 'J202204152967343221252971', 2, 1, 1, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (255, 'J202204152967343618611135', 2, 23, 23, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (256, 'J202204152967344119945144', 2, 23, 23, 20000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (257, 'J202204152967344573430159', 2, 23, 23, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (258, 'J202204152967345072338119', 2, 23, 23, 100000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (259, 'J202204152967345527569591', 2, 27, 27, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (260, 'J202204152967346174524248', 2, 27, 27, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (261, 'J202204152967346576406582', 2, 27, 27, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (262, 'J202204152967347072532749', 2, 27, 27, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (263, 'J202204152967347557883331', 2, 45, 46, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (264, 'J202204152967348082900254', 2, 45, 46, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (265, 'J202204152967348541697729', 2, 45, 46, 70000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (266, 'J202204152967348953615406', 2, 45, 46, 2000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (267, 'J202204152967349363411783', 2, 38, 39, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (268, 'J202204152967349931809694', 2, 38, 39, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (269, 'J202204152967350376924411', 2, 38, 39, 23000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (270, 'J202204152967350793122579', 2, 39, 40, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (271, 'J202204152967351308648224', 2, 39, 40, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (272, 'J202204152967351720277465', 2, 39, 40, 2000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (273, 'J202204152967352145511633', 2, 25, 25, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (274, 'J202204152967352741575624', 2, 25, 25, 20000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (275, 'J202204152967353186409143', 2, 25, 201, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (276, 'J202204152967353767793026', 2, 47, 57, 1000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (277, 'J202204152967354400217286', 2, 47, 48, 20000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (278, 'J202204152967354965290328', 2, 47, 222, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (279, 'J202204152967355615375947', 2, 15, 15, 25000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (280, 'J202204152967356203438079', 2, 15, 139, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (281, 'J202204152967356771774202', 2, 15, 15, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (282, 'J202204152967357194215197', 2, 44, 45, 20000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (283, 'J202204152967357725234485', 2, 44, 45, 20000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (284, 'J202204152967358156426281', 2, 44, 45, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (285, 'J202204152967358575284615', 2, 35, 36, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (286, 'J202204152967359149184169', 2, 35, 101, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (287, 'J202204152967359676407838', 2, 35, 103, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (288, 'J202204152967360242835985', 2, 32, 32, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (289, 'J202204152967360771151380', 2, 32, 32, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (290, 'J202204152967361186205816', 2, 32, 32, 50000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (291, 'J202204152967361619335148', 2, 6, 161, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (292, 'J202204152967362174660497', 2, 6, 161, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (293, 'J202204152967362583296799', 2, 6, 161, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (294, 'J202204152967362987966034', 2, 17, 17, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (295, 'J202204152967363571905472', 2, 17, 17, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (296, 'J202204152967364010525259', 2, 17, 17, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (297, 'J202204152967364457196361', 2, 6, 6, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (298, 'J202204152967364993332346', 2, 6, 6, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (299, 'J202204152967365452126331', 2, 40, 41, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (300, 'J202204152967365977463588', 2, 40, 41, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (301, 'J202204152967366417898774', 2, 20, 20, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (302, 'J202204152967366941479459', 2, 20, 20, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (303, 'J202204152967367371780827', 2, 24, 24, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (304, 'J202204152967367982109909', 2, 24, 134, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (305, 'J202204152967368504449273', 2, 52, 53, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (306, 'J202204152967369065435722', 2, 52, 53, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (307, 'J202204152967369477539029', 2, 46, 47, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (308, 'J202204152967369988747730', 2, 16, 16, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (309, 'J202204152967370525879838', 2, 34, 223, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (310, 'J202204152967371084258928', 2, 5, 5, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (311, 'J202204152967371618988442', 2, 22, 224, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (312, 'J202204152967372136716912', 2, 11, 11, 20000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (313, 'J202204152967372927854278', 2, 12, 12, 25000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (314, 'J202204152967373519418606', 2, 48, 49, 20000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (315, 'J202204152967374131533469', 2, 53, 204, 15000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (316, 'J202204152967374729977166', 2, 30, 30, 15000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (317, 'J202204152967375299955788', 2, 18, 18, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (318, 'J202204152967375942253378', 2, 9, 9, 6000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (319, 'J202204152967376512247345', 2, 19, 19, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (320, 'J202204152967377110642710', 2, 42, 43, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (321, 'J202204152967377888232481', 2, 36, 37, 5000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (322, 'J202204152967378455725397', 2, 37, 38, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (323, 'J202204152967379128138684', 2, 28, 28, 10000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (324, 'J202204152967379700664797', 2, 43, 44, 30000.00, NULL, 0, 2, 1, NULL, 0, 0, '购买软件服务', 0, 1, 1650029672), (325, 'J202204152967380296136476', 1, 46, 47, 6000.00, NULL, 0, 2, 1, NULL, 0, 0, '体验店', 0, 1, 1650029672), (326, 'J202204152967380725550813', 1, 47, 48, 4000.00, NULL, 0, 2, 1, NULL, 0, 0, '体验店', 0, 1, 1650029672), (327, 'J202204152967381157858964', 1, 29, 182, 2000.00, NULL, 0, 2, 1, NULL, 0, 0, '体验店', 0, 1, 1650029672), (328, 'J202204152967381588972080', 1, 54, 225, 36000.00, NULL, 0, 2, 1, NULL, 0, 0, '街道代理商', 0, 1, 1650029672); -- -------------------------------------------------------- -- -- 表的结构 `churen_option_cash` -- DROP TABLE IF EXISTS `churen_option_cash`; CREATE TABLE `churen_option_cash` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '类型', `aid` int(11) NOT NULL DEFAULT '-1' COMMENT '主账号手机号', `mid` int(11) NOT NULL DEFAULT '-1' COMMENT '子账号手机号', `daijiaofu_date` int(11) NOT NULL DEFAULT '0' COMMENT '最新的交付时间', `daijiaofu` float(11,2) NOT NULL DEFAULT '0.00' COMMENT '待交付额度', `jiaofu` float(11,2) NOT NULL DEFAULT '0.00' COMMENT '已交付额度', `fafang` float(11,2) NOT NULL DEFAULT '0.00' COMMENT '发放额度', `duifu` float(11,2) NOT NULL DEFAULT '0.00' COMMENT '兑付额度', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_option_cash` -- INSERT INTO `churen_option_cash` (`id`, `type`, `aid`, `mid`, `daijiaofu_date`, `daijiaofu`, `jiaofu`, `fafang`, `duifu`, `state`, `cdate`) VALUES (1, 1, 1, 1, 1650029672, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (2, 1, 2, 2, 1650029672, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (3, 1, 3, 3, 1650029672, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (4, 1, 4, 4, 1650029672, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (5, 1, 5, 5, 1650029672, 40000.00, 0.00, 0.00, 0.00, 1, 1650029672), (6, 1, 6, 6, 1650029672, 188750.00, 0.00, 0.00, 0.00, 1, 1650029672), (7, 1, 7, 7, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (8, 1, 8, 8, 1650029672, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (9, 1, 9, 9, 1650029672, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (10, 1, 10, 10, 1650029672, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (11, 1, 11, 11, 1650029672, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (12, 1, 12, 12, 1650029672, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (13, 1, 13, 13, 1650029672, 300000.00, 0.00, 0.00, 0.00, 1, 1650029672), (14, 1, 14, 14, 1650029672, 50000.00, 0.00, 0.00, 0.00, 1, 1650029672), (15, 1, 15, 15, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (16, 1, 16, 16, 1650029672, 100000.00, 0.00, 0.00, 0.00, 1, 1650029672), (17, 1, 17, 17, 1650029672, 50000.00, 0.00, 0.00, 0.00, 1, 1650029672), (18, 1, 18, 18, 1650029672, 600000.00, 0.00, 0.00, 0.00, 1, 1650029672), (19, 1, 19, 19, 1650029672, 36000.00, 0.00, 0.00, 0.00, 1, 1650029672), (20, 1, 20, 20, 1650029672, 36000.00, 0.00, 0.00, 0.00, 1, 1650029672), (21, 1, 21, 21, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (22, 1, 22, 22, 1650029672, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (23, 1, 23, 23, 1650029672, 50000.00, 0.00, 0.00, 0.00, 1, 1650029672), (24, 1, 24, 24, 1650029672, 35000.00, 0.00, 0.00, 0.00, 1, 1650029672), (25, 1, 25, 25, 1650029672, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (26, 1, 26, 26, 1650029672, 50000.00, 0.00, 0.00, 0.00, 1, 1650029672), (27, 1, 27, 27, 1650029672, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (28, 1, 28, 28, 1650029672, 40000.00, 0.00, 0.00, 0.00, 1, 1650029672), (29, 1, 29, 29, 1650029672, 1000000.00, 0.00, 0.00, 0.00, 1, 1650029672), (30, 1, 30, 30, 1650029672, 50000.00, 0.00, 0.00, 0.00, 1, 1650029672), (31, 1, 31, 31, 1650029672, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (32, 1, 32, 32, 1650029672, 150000.00, 0.00, 0.00, 0.00, 1, 1650029672), (33, 1, 33, 34, 1650029672, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (34, 1, 34, 35, 1650029672, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (35, 1, 35, 36, 1650029672, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (36, 1, 36, 37, 1650029672, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (37, 1, 37, 38, 1650029672, 300000.00, 0.00, 0.00, 0.00, 1, 1650029672), (38, 1, 38, 39, 1650029672, 56000.00, 0.00, 0.00, 0.00, 1, 1650029672), (39, 1, 39, 40, 1650029672, 55000.00, 0.00, 0.00, 0.00, 1, 1650029672), (40, 1, 40, 41, 1650029672, 100000.00, 0.00, 0.00, 0.00, 1, 1650029672), (41, 1, 41, 42, 1650029672, 300000.00, 0.00, 0.00, 0.00, 1, 1650029672), (42, 1, 42, 43, 1650029672, 200000.00, 0.00, 0.00, 0.00, 1, 1650029672), (43, 1, 43, 44, 1650029672, 180000.00, 0.00, 0.00, 0.00, 1, 1650029672), (44, 1, 44, 45, 1650029672, 56000.00, 0.00, 0.00, 0.00, 1, 1650029672), (45, 1, 45, 46, 1650029672, 271000.00, 0.00, 0.00, 0.00, 1, 1650029672), (46, 1, 46, 47, 1650029673, 62000.00, 0.00, 0.00, 0.00, 1, 1650029672), (47, 1, 47, 48, 1650029673, 304000.00, 0.00, 0.00, 0.00, 1, 1650029672), (48, 1, 48, 49, 1650029672, 55000.00, 0.00, 0.00, 0.00, 1, 1650029672), (49, 1, 49, 50, 1650029672, 300000.00, 0.00, 0.00, 0.00, 1, 1650029672), (50, 1, 51, 52, 1650029672, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (51, 1, 52, 53, 1650029672, 150000.00, 0.00, 0.00, 0.00, 1, 1650029672), (52, 1, 47, 54, 1650029672, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (53, 1, 47, 55, 1650029672, 300000.00, 0.00, 0.00, 0.00, 1, 1650029672), (54, 1, 47, 56, 1650029672, 50000.00, 0.00, 0.00, 0.00, 1, 1650029672), (55, 1, 47, 57, 1650029672, 2500.00, 0.00, 0.00, 0.00, 1, 1650029672), (56, 1, 7, 58, 1650029672, 25000.00, 0.00, 0.00, 0.00, 1, 1650029672), (57, 1, 7, 59, 1650029672, 140000.00, 0.00, 0.00, 0.00, 1, 1650029672), (58, 1, 7, 60, 1650029672, 25000.00, 0.00, 0.00, 0.00, 1, 1650029672), (59, 1, 7, 61, 1650029672, 105000.00, 0.00, 0.00, 0.00, 1, 1650029672), (60, 1, 7, 62, 1650029672, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (61, 1, 7, 63, 1650029672, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (62, 1, 7, 64, 1650029672, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (63, 1, 7, 65, 1650029672, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (64, 1, 7, 66, 1650029672, 140000.00, 0.00, 0.00, 0.00, 1, 1650029672), (65, 1, 7, 67, 1650029672, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (66, 1, 7, 68, 1650029672, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (67, 1, 7, 69, 1650029672, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (68, 1, 7, 70, 1650029672, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (69, 1, 7, 71, 1650029672, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (70, 1, 7, 75, 1650029672, 36000.00, 0.00, 0.00, 0.00, 1, 1650029672), (71, 1, 7, 76, 1650029672, 60000.00, 0.00, 0.00, 0.00, 1, 1650029672), (72, 1, 7, 77, 1650029672, 60000.00, 0.00, 0.00, 0.00, 1, 1650029672), (73, 1, 7, 78, 1650029672, 400000.00, 0.00, 0.00, 0.00, 1, 1650029672), (74, 1, 7, 79, 1650029672, 60000.00, 0.00, 0.00, 0.00, 1, 1650029672), (75, 1, 7, 80, 1650029672, 60000.00, 0.00, 0.00, 0.00, 1, 1650029672), (76, 1, 7, 81, 1650029672, 60000.00, 0.00, 0.00, 0.00, 1, 1650029672), (77, 1, 7, 82, 1650029672, 60000.00, 0.00, 0.00, 0.00, 1, 1650029672), (78, 1, 7, 83, 1650029672, 60000.00, 0.00, 0.00, 0.00, 1, 1650029672), (79, 1, 7, 84, 1650029672, 60000.00, 0.00, 0.00, 0.00, 1, 1650029672), (80, 1, 7, 85, 1650029672, 400000.00, 0.00, 0.00, 0.00, 1, 1650029672), (81, 1, 7, 86, 1650029672, 400000.00, 0.00, 0.00, 0.00, 1, 1650029672), (82, 1, 7, 87, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (83, 1, 7, 88, 1650029672, 60000.00, 0.00, 0.00, 0.00, 1, 1650029672), (84, 1, 7, 89, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (85, 1, 7, 90, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (86, 1, 7, 91, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (87, 1, 7, 92, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (88, 1, 7, 93, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (89, 1, 7, 94, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (90, 1, 7, 95, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (91, 1, 7, 96, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (92, 1, 7, 97, 1650029672, 2500.00, 0.00, 0.00, 0.00, 1, 1650029672), (93, 1, 7, 98, 1650029672, 2500.00, 0.00, 0.00, 0.00, 1, 1650029672), (94, 1, 44, 99, 1650029672, 2500.00, 0.00, 0.00, 0.00, 1, 1650029672), (95, 1, 44, 100, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (96, 1, 35, 101, 1650029672, 60000.00, 0.00, 0.00, 0.00, 1, 1650029672), (97, 1, 35, 102, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (98, 1, 35, 103, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (99, 1, 35, 104, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (100, 1, 35, 105, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (101, 1, 35, 106, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (102, 1, 35, 107, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (103, 1, 35, 108, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (104, 1, 35, 109, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (105, 1, 35, 110, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (106, 1, 35, 111, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (107, 1, 35, 112, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (108, 1, 35, 113, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (109, 1, 35, 114, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (110, 1, 35, 115, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (111, 1, 35, 116, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (112, 1, 35, 117, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (113, 1, 35, 118, 1650029672, 50000.00, 0.00, 0.00, 0.00, 1, 1650029672), (114, 1, 20, 119, 1650029672, 200000.00, 0.00, 0.00, 0.00, 1, 1650029672), (115, 1, 20, 120, 1650029672, 40000.00, 0.00, 0.00, 0.00, 1, 1650029672), (116, 1, 20, 121, 1650029672, 40000.00, 0.00, 0.00, 0.00, 1, 1650029672), (117, 1, 20, 122, 1650029672, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (118, 1, 10, 123, 1650029672, 150000.00, 0.00, 0.00, 0.00, 1, 1650029672), (119, 1, 8, 124, 1650029672, 50000.00, 0.00, 0.00, 0.00, 1, 1650029672), (120, 1, 36, 125, 1650029672, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (121, 1, 36, 126, 1650029672, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (122, 1, 18, 127, 1650029672, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (123, 1, 46, 128, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (124, 1, 48, 129, 1650029672, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (125, 1, 48, 130, 1650029672, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (126, 1, 48, 131, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (127, 1, 22, 132, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (128, 1, 24, 133, 1650029672, 2500.00, 0.00, 0.00, 0.00, 1, 1650029672), (129, 1, 24, 134, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (130, 1, 24, 135, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (131, 1, 31, 136, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (132, 1, 4, 137, 1650029672, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (133, 1, 4, 138, 1650029672, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (134, 1, 15, 139, 1650029672, 35000.00, 0.00, 0.00, 0.00, 1, 1650029672), (135, 1, 52, 140, 1650029672, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (136, 1, 52, 141, 1650029672, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (137, 1, 52, 142, 1650029672, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (138, 1, 43, 143, 1650029672, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (139, 1, 43, 144, 1650029672, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (140, 1, 40, 145, 1650029672, 36000.00, 0.00, 0.00, 0.00, 1, 1650029672), (141, 1, 40, 146, 1650029672, 900000.00, 0.00, 0.00, 0.00, 1, 1650029672), (142, 1, 32, 147, 1650029672, 100000.00, 0.00, 0.00, 0.00, 1, 1650029672), (143, 1, 27, 148, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (144, 1, 27, 149, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (145, 1, 27, 150, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (146, 1, 27, 151, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (147, 1, 27, 152, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (148, 1, 27, 153, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (149, 1, 27, 154, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (150, 1, 27, 155, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (151, 1, 27, 156, 1650029672, 25000.00, 0.00, 0.00, 0.00, 1, 1650029672), (152, 1, 27, 157, 1650029672, 60000.00, 0.00, 0.00, 0.00, 1, 1650029672), (153, 1, 6, 158, 1650029672, 55000.00, 0.00, 0.00, 0.00, 1, 1650029672), (154, 1, 6, 160, 1650029672, 60000.00, 0.00, 0.00, 0.00, 1, 1650029672), (155, 1, 6, 161, 1650029672, 163750.00, 0.00, 0.00, 0.00, 1, 1650029672), (156, 1, 21, 162, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (157, 1, 21, 163, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (158, 1, 21, 164, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (159, 1, 21, 165, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (160, 1, 23, 166, 1650029672, 300000.00, 0.00, 0.00, 0.00, 1, 1650029672), (161, 1, 23, 168, 1650029672, 100000.00, 0.00, 0.00, 0.00, 1, 1650029672), (162, 1, 3, 169, 1650029672, 600000.00, 0.00, 0.00, 0.00, 1, 1650029672), (163, 1, 14, 170, 1650029672, 56000.00, 0.00, 0.00, 0.00, 1, 1650029672), (164, 1, 14, 171, 1650029672, 60000.00, 0.00, 0.00, 0.00, 1, 1650029672), (165, 1, 17, 172, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (166, 1, 17, 173, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (167, 1, 38, 174, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (168, 1, 38, 175, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (169, 1, 38, 176, 1650029672, 60000.00, 0.00, 0.00, 0.00, 1, 1650029672), (170, 1, 38, 177, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (171, 1, 38, 178, 1650029672, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (172, 1, 38, 179, 1650029673, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (173, 1, 2, 180, 1650029673, 1000000.00, 0.00, 0.00, 0.00, 1, 1650029672), (174, 1, 29, 181, 1650029673, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (175, 1, 29, 182, 1650029673, 12000.00, 0.00, 0.00, 0.00, 1, 1650029672), (176, 1, 1, 183, 1650029673, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (177, 1, 1, 184, 1650029673, 100000.00, 0.00, 0.00, 0.00, 1, 1650029672), (178, 1, 1, 185, 1650029673, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (179, 1, 1, 186, 1650029673, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (180, 1, 1, 187, 1650029673, 36000.00, 0.00, 0.00, 0.00, 1, 1650029672), (181, 1, 1, 188, 1650029673, 100000.00, 0.00, 0.00, 0.00, 1, 1650029672), (182, 1, 1, 189, 1650029673, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (183, 1, 1, 190, 1650029673, 60000.00, 0.00, 0.00, 0.00, 1, 1650029672), (184, 1, 1, 191, 1650029673, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (185, 1, 1, 192, 1650029673, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (186, 1, 1, 193, 1650029673, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (187, 1, 25, 194, 1650029673, 2500.00, 0.00, 0.00, 0.00, 1, 1650029672), (188, 1, 25, 195, 1650029673, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (189, 1, 25, 196, 1650029673, 40000.00, 0.00, 0.00, 0.00, 1, 1650029672), (190, 1, 25, 197, 1650029673, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (191, 1, 25, 198, 1650029673, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (192, 1, 25, 199, 1650029673, 50000.00, 0.00, 0.00, 0.00, 1, 1650029672), (193, 1, 25, 200, 1650029673, 50000.00, 0.00, 0.00, 0.00, 1, 1650029672), (194, 1, 25, 201, 1650029673, 2500.00, 0.00, 0.00, 0.00, 1, 1650029672), (195, 1, 25, 202, 1650029673, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (196, 1, 51, 203, 1650029673, 60000.00, 0.00, 0.00, 0.00, 1, 1650029672), (197, 1, 53, 204, 1650029673, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (198, 1, 33, 205, 1650029673, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (199, 1, 33, 206, 1650029673, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (200, 1, 12, 207, 1650029673, 300000.00, 0.00, 0.00, 0.00, 1, 1650029672), (201, 1, 50, 208, 1650029673, 600000.00, 0.00, 0.00, 0.00, 1, 1650029672), (202, 1, 41, 209, 1650029673, 36000.00, 0.00, 0.00, 0.00, 1, 1650029672), (203, 1, 41, 210, 1650029673, 3000.00, 0.00, 0.00, 0.00, 1, 1650029672), (204, 1, 41, 211, 1650029673, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (205, 1, 41, 212, 1650029673, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (206, 1, 41, 213, 1650029673, 50000.00, 0.00, 0.00, 0.00, 1, 1650029672), (207, 1, 41, 214, 1650029673, 50000.00, 0.00, 0.00, 0.00, 1, 1650029672), (208, 1, 41, 215, 1650029673, 56000.00, 0.00, 0.00, 0.00, 1, 1650029672), (209, 1, 41, 216, 1650029673, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (210, 1, 41, 217, 1650029673, 300000.00, 0.00, 0.00, 0.00, 1, 1650029672), (211, 1, 11, 218, 1650029673, 40000.00, 0.00, 0.00, 0.00, 1, 1650029672), (212, 1, 11, 219, 1650029673, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (213, 1, 11, 220, 1650029673, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (214, 1, 11, 221, 1650029673, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (215, 2, 7, 7, 1650029673, 31000.00, 0.00, 0.00, 0.00, 1, 1650029672), (216, 2, 7, 88, 1650029673, 41000.00, 0.00, 0.00, 0.00, 1, 1650029672), (217, 2, 7, 66, 1650029673, 120000.00, 0.00, 0.00, 0.00, 1, 1650029672), (218, 2, 7, 75, 1650029673, 20000.00, 0.00, 0.00, 0.00, 1, 1650029672), (219, 2, 7, 86, 1650029673, 20000.00, 0.00, 0.00, 0.00, 1, 1650029672), (220, 2, 7, 78, 1650029673, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (221, 2, 7, 79, 1650029673, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (222, 2, 7, 81, 1650029673, 60000.00, 0.00, 0.00, 0.00, 1, 1650029672), (223, 2, 7, 83, 1650029673, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (224, 2, 7, 61, 1650029673, 90000.00, 0.00, 0.00, 0.00, 1, 1650029672), (225, 2, 7, 84, 1650029673, 23000.00, 0.00, 0.00, 0.00, 1, 1650029672), (226, 2, 7, 59, 1650029673, 120000.00, 0.00, 0.00, 0.00, 1, 1650029672), (227, 2, 7, 58, 1650029673, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (228, 2, 7, 60, 1650029673, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (229, 2, 7, 82, 1650029673, 15000.00, 0.00, 0.00, 0.00, 1, 1650029672), (230, 2, 41, 217, 1650029673, 40000.00, 0.00, 0.00, 0.00, 1, 1650029672), (231, 2, 41, 42, 1650029673, 182000.00, 0.00, 0.00, 0.00, 1, 1650029672), (232, 2, 41, 211, 1650029673, 4000.00, 0.00, 0.00, 0.00, 1, 1650029672), (233, 2, 1, 1, 1650029673, 60000.00, 0.00, 0.00, 0.00, 1, 1650029672), (234, 2, 1, 190, 1650029673, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (235, 2, 1, 189, 1650029673, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (236, 2, 1, 193, 1650029673, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (237, 2, 1, 184, 1650029673, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (238, 2, 23, 23, 1650029673, 160000.00, 0.00, 0.00, 0.00, 1, 1650029672), (239, 2, 27, 27, 1650029673, 100000.00, 0.00, 0.00, 0.00, 1, 1650029672), (240, 2, 45, 46, 1650029673, 132000.00, 0.00, 0.00, 0.00, 1, 1650029672), (241, 2, 38, 39, 1650029673, 43000.00, 0.00, 0.00, 0.00, 1, 1650029672), (242, 2, 39, 40, 1650029673, 42000.00, 0.00, 0.00, 0.00, 1, 1650029672), (243, 2, 25, 25, 1650029673, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (244, 2, 25, 201, 1650029673, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (245, 2, 47, 57, 1650029673, 1000.00, 0.00, 0.00, 0.00, 1, 1650029672), (246, 2, 47, 48, 1650029673, 20000.00, 0.00, 0.00, 0.00, 1, 1650029672), (247, 2, 47, 222, 1650029673, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (248, 2, 15, 15, 1650029673, 55000.00, 0.00, 0.00, 0.00, 1, 1650029672), (249, 2, 15, 139, 1650029673, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (250, 2, 44, 45, 1650029673, 45000.00, 0.00, 0.00, 0.00, 1, 1650029672), (251, 2, 35, 36, 1650029673, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (252, 2, 35, 101, 1650029673, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (253, 2, 35, 103, 1650029673, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (254, 2, 32, 32, 1650029673, 90000.00, 0.00, 0.00, 0.00, 1, 1650029672), (255, 2, 6, 161, 1650029673, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (256, 2, 17, 17, 1650029673, 70000.00, 0.00, 0.00, 0.00, 1, 1650029672), (257, 2, 6, 6, 1650029673, 20000.00, 0.00, 0.00, 0.00, 1, 1650029672), (258, 2, 40, 41, 1650029673, 40000.00, 0.00, 0.00, 0.00, 1, 1650029672), (259, 2, 20, 20, 1650029673, 60000.00, 0.00, 0.00, 0.00, 1, 1650029672), (260, 2, 24, 24, 1650029673, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (261, 2, 24, 134, 1650029673, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (262, 2, 52, 53, 1650029673, 40000.00, 0.00, 0.00, 0.00, 1, 1650029672), (263, 2, 46, 47, 1650029673, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (264, 2, 16, 16, 1650029673, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (265, 2, 34, 223, 1650029673, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (266, 2, 5, 5, 1650029673, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (267, 2, 22, 224, 1650029673, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (268, 2, 11, 11, 1650029673, 20000.00, 0.00, 0.00, 0.00, 1, 1650029672), (269, 2, 12, 12, 1650029673, 25000.00, 0.00, 0.00, 0.00, 1, 1650029672), (270, 2, 48, 49, 1650029673, 20000.00, 0.00, 0.00, 0.00, 1, 1650029672), (271, 2, 53, 204, 1650029673, 15000.00, 0.00, 0.00, 0.00, 1, 1650029672), (272, 2, 30, 30, 1650029673, 15000.00, 0.00, 0.00, 0.00, 1, 1650029672), (273, 2, 18, 18, 1650029673, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (274, 2, 9, 9, 1650029673, 6000.00, 0.00, 0.00, 0.00, 1, 1650029672), (275, 2, 19, 19, 1650029673, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (276, 2, 42, 43, 1650029673, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (277, 2, 36, 37, 1650029673, 5000.00, 0.00, 0.00, 0.00, 1, 1650029672), (278, 2, 37, 38, 1650029673, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (279, 2, 28, 28, 1650029673, 10000.00, 0.00, 0.00, 0.00, 1, 1650029672), (280, 2, 43, 44, 1650029673, 30000.00, 0.00, 0.00, 0.00, 1, 1650029672), (281, 1, 54, 225, 1650029673, 36000.00, 0.00, 0.00, 0.00, 1, 1650029672); -- -------------------------------------------------------- -- -- 表的结构 `churen_option_member` -- DROP TABLE IF EXISTS `churen_option_member`; CREATE TABLE `churen_option_member` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `main` tinyint(1) NOT NULL DEFAULT '1' COMMENT '账号类型', `key` int(11) NOT NULL DEFAULT '0' COMMENT '账户索引-通过账户索引来判断同一个人', `aid` int(11) NOT NULL DEFAULT '-1' COMMENT '期权登录账户', `name` varchar(100) DEFAULT NULL COMMENT '姓名', `mobile` bigint(11) NOT NULL DEFAULT '0' COMMENT '手机号', `idcard` varchar(32) DEFAULT NULL COMMENT '身份证号码', `idcard_bind` tinyint(1) NOT NULL DEFAULT '2' COMMENT '身份证是否绑定', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '添加方式', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_option_member` -- INSERT INTO `churen_option_member` (`id`, `main`, `key`, `aid`, `name`, `mobile`, `idcard`, `idcard_bind`, `status`, `state`, `cdate`) VALUES (1, 1, 1, 1, '安艳娟', 13581829319, '110109197812301221 ', 2, 2, 1, 1650029668), (2, 1, 2, 2, '安燕玲', 13701398869, '110108197402032720 ', 2, 2, 1, 1650029668), (3, 1, 3, 3, '曾韩英', 13480478948, '432503197712205507 ', 2, 2, 1, 1650029668), (4, 1, 4, 4, '崔亮', 17711572473, '152801198406298355 ', 2, 2, 1, 1650029668), (5, 1, 5, 5, '崔利红', 18647146364, '152634198102182122 ', 2, 2, 1, 1650029668), (6, 1, 6, 6, '丁凝一', 15868555282, '330302195701024063 ', 2, 2, 1, 1650029668), (7, 1, 7, 7, '杜彩丽', 15524599853, '372523198005019223 ', 2, 2, 1, 1650029668), (8, 1, 8, 8, '李丽', 17732606567, '230822197304267326 ', 2, 2, 1, 1650029668), (9, 1, 9, 9, '冯丽萍', 13847412925, '152628196010310223 ', 2, 2, 1, 1650029668), (10, 1, 10, 10, '高志亮', 15548801085, '150207196110251034 ', 2, 2, 1, 1650029668), (11, 1, 11, 11, '葛济广', 13191449719, '410728196912256534 ', 2, 2, 1, 1650029668), (12, 1, 12, 12, '黄京红', 15652681213, '110102196302072773 ', 2, 2, 1, 1650029668), (13, 1, 13, 13, '胡晓杭', 13858925929, '330722198609156419 ', 2, 2, 1, 1650029668), (14, 1, 14, 14, '姜清华', 13616666588, '33032119680914065X ', 2, 2, 1, 1650029668), (15, 1, 15, 15, '蒋利香', 15900666556, '51253519810915232X ', 2, 2, 1, 1650029668), (16, 1, 16, 16, '金键', 15021255046, '522401198210093531 ', 2, 2, 1, 1650029668), (17, 1, 17, 17, '廖光明', 13858805560, '330329197107290026 ', 2, 2, 1, 1650029668), (18, 1, 18, 18, '刘荣', 13811599995, '130930198305162442 ', 2, 2, 1, 1650029668), (19, 1, 19, 19, '刘玉玲', 15598324967, '150203196802072728 ', 2, 2, 1, 1650029668), (20, 1, 20, 20, '刘周明', 18635222633, '140202196202073032 ', 2, 2, 1, 1650029668), (21, 1, 21, 21, '李维真', 19518133679, '330321196803214224 ', 2, 2, 1, 1650029668), (22, 1, 22, 22, '李卓莹', 18614289414, '130204198203063629 ', 2, 2, 1, 1650029668), (23, 1, 23, 23, '罗子忠', 13958982965, '330329197501094939 ', 2, 2, 1, 1650029668), (24, 1, 24, 24, '马杰', 15041233335, '210106196304054420 ', 2, 2, 1, 1650029668), (25, 1, 25, 25, '马连胜', 15510003697, '11010519601028153X ', 2, 2, 1, 1650029668), (26, 1, 26, 26, '梅玉昌', 15501041313, '342623197012134954 ', 2, 2, 1, 1650029668), (27, 1, 27, 27, '舒兰玲', 13907166876, '422301197009240540 ', 2, 2, 1, 1650029668), (28, 1, 28, 28, '孙颢彬', 18265876575, '370302200211064215 ', 2, 2, 1, 1650029668), (29, 1, 29, 29, '孙立波', 15313630088, '220123197002267116 ', 2, 2, 1, 1650029668), (30, 1, 30, 30, '汪大伟', 13322286178, '21022119501125065X ', 2, 2, 1, 1650029668), (31, 1, 31, 31, '王海霞', 18946511376, '140427198104024445 ', 2, 2, 1, 1650029668), (32, 1, 32, 32, '王秀丽', 15578911668, '140402195910200449 ', 2, 2, 1, 1650029668), (33, 2, 33, 53, '王英', 13671283943, '511124198206073226 ', 2, 2, 1, 1650029668), (34, 1, 34, 33, '王玉环', 18911475662, '341221197303058706 ', 2, 2, 1, 1650029668), (35, 1, 35, 34, '武俊林', 15035732699, '142636197808224714 ', 2, 2, 1, 1650029668), (36, 1, 36, 35, '徐冬英', 13706759595, '330623197102242963 ', 2, 2, 1, 1650029668), (37, 1, 37, 36, '薛雪妹', 17751193849, '320521196807186725 ', 2, 2, 1, 1650029668), (38, 1, 38, 37, '赵娟', 17733283259, '152601199306103120 ', 2, 2, 1, 1650029668), (39, 1, 39, 38, '徐小玲', 18968883810, '330302196207163628 ', 2, 2, 1, 1650029668), (40, 1, 40, 39, '徐小珑', 15805871676, '330302196207173623 ', 2, 2, 1, 1650029668), (41, 1, 41, 40, '徐京梅', 18801330099, '11010119740426052X ', 2, 2, 1, 1650029668), (42, 1, 42, 41, '杨素华', 18678958371, '370206196110274820 ', 2, 2, 1, 1650029668), (43, 1, 43, 42, '杨文金', 15326910302, '15020319680311255X ', 2, 2, 1, 1650029668), (44, 1, 44, 43, '杨艳蓉', 13948128011, '15010219540402154x ', 2, 2, 1, 1650029668), (45, 1, 45, 44, '张春玲', 18304637959, '230229196806051223 ', 2, 2, 1, 1650029668), (46, 1, 46, 45, '张欢呼', 13857791955, '330302196712280825 ', 2, 2, 1, 1650029668), (47, 1, 47, 46, '张明扣', 18601603066, '342601196405150012 ', 2, 2, 1, 1650029668), (48, 1, 48, 47, '赵淑荣', 13889490121, '230229197201053669 ', 2, 2, 1, 1650029668), (49, 1, 49, 48, '周素兰', 13604204217, '210311196811300325 ', 2, 2, 1, 1650029668), (50, 1, 50, 49, '周晓霞', 18636654858, '140511197806264726 ', 2, 2, 1, 1650029668), (51, 1, 51, 50, '周兆兰', 15313533399, '110224196509161013 ', 2, 2, 1, 1650029668), (52, 1, 52, 51, '庄丽容', 15711544119, '350628197205232528 ', 2, 2, 1, 1650029668), (53, 1, 53, 52, '李秀英', 13722115666, '150102195802023022 ', 2, 2, 1, 1650029668), (54, 2, 48, 47, '赵淑荣', 15714117699, '230229197201053669 ', 2, 2, 1, 1650029668), (55, 2, 48, 47, '赵淑荣', 13716261113, '230229197201053669 ', 2, 2, 1, 1650029668), (56, 2, 48, 47, '耿钰书', 15042417212, '230229199606293619 ', 2, 2, 1, 1650029668), (57, 2, 48, 47, '赵淑荣', 18941111832, '230229197201053669 ', 2, 2, 1, 1650029668), (58, 2, 7, 7, '杜彩丽', 13591777189, '372523198005019223 ', 2, 2, 1, 1650029668), (59, 2, 7, 7, '杜彩丽', 15524835133, '372523198005019223 ', 2, 2, 1, 1650029668), (60, 2, 7, 7, '杜彩丽', 17896218728, '372523198005019223 ', 2, 2, 1, 1650029668), (61, 2, 7, 7, '杜彩丽', 15640969254, '372523198005019223 ', 2, 2, 1, 1650029668), (62, 2, 7, 7, '杜彩丽', 19524728692, '372523198005019223 ', 2, 2, 1, 1650029668), (63, 2, 7, 7, '杜彩丽', 13909867744, '372523198005019223 ', 2, 2, 1, 1650029668), (64, 2, 7, 7, '杜彩丽', 15945433336, '372523198005019223 ', 2, 2, 1, 1650029668), (65, 2, 7, 7, '杜彩丽', 15541171179, '372523198005019223 ', 2, 2, 1, 1650029668), (66, 2, 7, 7, '杜彩丽', 15945879771, '372523198005019223 ', 2, 2, 1, 1650029668), (67, 2, 7, 7, '杜彩丽', 13019430914, '372523198005019223 ', 2, 2, 1, 1650029668), (68, 2, 7, 7, '杜彩丽', 13898681263, '372523198005019223 ', 2, 2, 1, 1650029668), (69, 2, 7, 7, '杜彩丽', 13940870568, '372523198005019223 ', 2, 2, 1, 1650029668), (70, 2, 7, 7, '杜彩丽', 18940827316, '372523198005019223 ', 2, 2, 1, 1650029668), (71, 2, 7, 7, '杜彩丽', 15541142368, '372523198005019223 ', 2, 2, 1, 1650029668), (72, 2, 7, 7, '杜彩丽', 15382299853, '372523198005019223 ', 2, 2, 1, 1650029668), (73, 2, 7, 7, '杜彩丽', 15734169853, '372523198005019223 ', 2, 2, 1, 1650029668), (74, 2, 7, 7, '杜彩丽', 18141169853, '372523198005019223 ', 2, 2, 1, 1650029668), (75, 2, 7, 7, '杜彩丽', 13604946853, '372523198005019223 ', 2, 2, 1, 1650029668), (76, 2, 7, 7, '杜彩丽', 15140669853, '372523198005019223 ', 2, 2, 1, 1650029668), (77, 2, 7, 7, '杜彩丽', 13164548938, '372523198005019223 ', 2, 2, 1, 1650029668), (78, 2, 7, 7, '杜彩丽', 15542679853, '372523198005019223 ', 2, 2, 1, 1650029668), (79, 2, 7, 7, '杜彩丽', 13352296923, '372523198005019223 ', 2, 2, 1, 1650029668), (80, 2, 7, 7, '杜彩丽', 13387899853, '372523198005019223 ', 2, 2, 1, 1650029668), (81, 2, 7, 7, '杜彩丽', 15040599853, '372523198005019223 ', 2, 2, 1, 1650029668), (82, 2, 7, 7, '杜彩丽', 13842671257, '372523198005019223 ', 2, 2, 1, 1650029668), (83, 2, 7, 7, '杜彩丽', 15141199853, '372523198005019223 ', 2, 2, 1, 1650029668), (84, 2, 7, 7, '杜彩丽', 13390029328, '372523198005019223 ', 2, 2, 1, 1650029668), (85, 2, 7, 7, '杜彩丽', 15524869853, '372523198005019223 ', 2, 2, 1, 1650029668), (86, 2, 7, 7, '杜彩丽', 18141799853, '372523198005019223 ', 2, 2, 1, 1650029668), (87, 2, 7, 7, '杜彩丽', 15382169853, '372523198005019223 ', 2, 2, 1, 1650029668), (88, 2, 7, 7, '杜彩丽', 15524799853, '372523198005019223 ', 2, 2, 1, 1650029668), (89, 2, 7, 7, '刘长柱', 18264537139, '372523196603079235 ', 2, 2, 1, 1650029668), (90, 2, 7, 7, '刘山瑞', 17865630863, '371522199506209217 ', 2, 2, 1, 1650029668), (91, 2, 7, 7, '黄晓旭', 13478657844, '210281198807284038 ', 2, 2, 1, 1650029668), (92, 2, 7, 7, '刘泽龙', 17600615428, '371522199303089219 ', 2, 2, 1, 1650029668), (93, 2, 7, 7, '刘世印', 15275850828, '37252319640316921X ', 2, 2, 1, 1650029668), (94, 2, 7, 7, '吴婧雯', 15640912256, '211382199406130422 ', 2, 2, 1, 1650029668), (95, 2, 7, 7, '刘利', 15020676825, '371522198605149243 ', 2, 2, 1, 1650029668), (96, 2, 7, 7, '刘恋', 13591125551, '210211198711272922 ', 2, 2, 1, 1650029668), (97, 2, 7, 7, '刁琰', 15502626531, '211382198312260440 ', 2, 2, 1, 1650029668), (98, 2, 7, 7, '张睿新', 18104098888, '232331198211160410 ', 2, 2, 1, 1650029668), (99, 2, 45, 44, '张春玲', 18941334319, '230229196806051223 ', 2, 2, 1, 1650029668), (100, 2, 45, 44, '张春玲', 18645237959, '230229196909283916 ', 2, 2, 1, 1650029668), (101, 2, 36, 35, '徐冬英', 13706759090, '330623197102242963 ', 2, 2, 1, 1650029668), (102, 2, 36, 35, '徐冬英', 13605753208, '330623197102242963 ', 2, 2, 1, 1650029668), (103, 2, 36, 35, '徐冬英', 18305852873, '330623197102242963 ', 2, 2, 1, 1650029668), (104, 2, 36, 35, '徐冬英', 13646757373, '330623197102242963 ', 2, 2, 1, 1650029668), (105, 2, 36, 35, '吴迎宾', 15286826668, '410423197903292636 ', 2, 2, 1, 1650029668), (106, 2, 36, 35, '徐明', 13858558285, '330623197103048513 ', 2, 2, 1, 1650029668), (107, 2, 36, 35, '谢育红', 17600880863, '610323197705016843 ', 2, 2, 1, 1650029668), (108, 2, 36, 35, '徐鑫', 15824228309, '330623197609098518 ', 2, 2, 1, 1650029668), (109, 2, 36, 35, '邱海春', 18888712377, '360730198407111429 ', 2, 2, 1, 1650029668), (110, 2, 36, 35, '徐东亮', 13906758852, '330623197705082970 ', 2, 2, 1, 1650029668), (111, 2, 36, 35, '邱海春', 13587369797, '360730198407111429 ', 2, 2, 1, 1650029668), (112, 2, 36, 35, '吴迪兴', 17382219817, '512226197503263514 ', 2, 2, 1, 1650029668), (113, 2, 36, 35, '徐桂莲', 13067951848, '330623197211288522 ', 2, 2, 1, 1650029668), (114, 2, 36, 35, '吴曼', 18696880244, '500236200105127449 ', 2, 2, 1, 1650029668), (115, 2, 36, 35, '徐明', 13655758385, '330623197103048513 ', 2, 2, 1, 1650029668), (116, 2, 36, 35, '王丹', 18323658991, '512226197212177448 ', 2, 2, 1, 1650029668), (117, 2, 36, 35, '吴梦', 18506815320, '500236199610307445 ', 2, 2, 1, 1650029668), (118, 2, 36, 35, '丁启欣', 18267532578, '330623195608211516 ', 2, 2, 1, 1650029668), (119, 2, 20, 20, '刘周明', 13353522028, '140202196202073032 ', 2, 2, 1, 1650029668), (120, 2, 20, 20, '李阳', 13903526204, '14020219610526251X ', 2, 2, 1, 1650029668), (121, 2, 20, 20, '刘极峰', 16728683199, '140202196305013067 ', 2, 2, 1, 1650029668), (122, 2, 20, 20, '刘极峰', 13620621283, '140202196305013067 ', 2, 2, 1, 1650029668), (123, 2, 10, 10, '高志亮', 18647206315, '150207196110251034 ', 2, 2, 1, 1650029668), (124, 2, 8, 8, '杜永生', 17716516111, '230822197701127319 ', 2, 2, 1, 1650029668), (125, 2, 37, 36, '薛建明', 13815292991, '320521195412186718 ', 2, 2, 1, 1650029668), (126, 2, 37, 36, '张晓琳', 13962202399, '320582199010176729 ', 2, 2, 1, 1650029668), (127, 2, 18, 18, '刘荣', 13910166761, '130930198305162442 ', 2, 2, 1, 1650029668), (128, 2, 47, 46, '张明扣', 18721137668, '342601196405150012 ', 2, 2, 1, 1650029668), (129, 2, 49, 48, '马佳羽', 15909887919, '210304199303240418 ', 2, 2, 1, 1650029668), (130, 2, 49, 48, '王传营', 15998059782, '210302199111130342 ', 2, 2, 1, 1650029668), (131, 2, 49, 48, '周素兰', 13050000742, '210311196811300325 ', 2, 2, 1, 1650029668), (132, 2, 22, 22, '李卓莹', 18500766976, '130204198203063629 ', 2, 2, 1, 1650029668), (133, 2, 24, 24, '马杰', 13504016036, '210106196304054420 ', 2, 2, 1, 1650029668), (134, 2, 24, 24, '马杰', 18540345578, '210106196304054420 ', 2, 2, 1, 1650029668), (135, 2, 24, 24, '马杰', 15524392574, '210106196304054420 ', 2, 2, 1, 1650029668), (136, 2, 31, 31, '王海霞', 18636598267, '140427198104024445 ', 2, 2, 1, 1650029668), (137, 2, 4, 4, '郭彩云', 15147886411, '152801198411046224 ', 2, 2, 1, 1650029668), (138, 2, 4, 4, '崔亮', 15391076661, '152801198406298355 ', 2, 2, 1, 1650029668), (139, 2, 15, 15, '蒋利香', 15216894813, '51253519810915232X ', 2, 2, 1, 1650029668), (140, 2, 53, 52, '冯蔚洁', 18647100066, '150105199106207327 ', 2, 2, 1, 1650029668), (141, 2, 53, 52, '齐凡', 18686032888, '150105198612207317 ', 2, 2, 1, 1650029668), (142, 2, 53, 52, '薛娴', 15010031036, '150105198408168322 ', 2, 2, 1, 1650029668), (143, 2, 44, 43, '冯晨曦', 13718188715, '150105198601057325 ', 2, 2, 1, 1650029668), (144, 2, 44, 43, '杨艳芳', 18123659695, '150102196606151523 ', 2, 2, 1, 1650029668), (145, 2, 41, 40, '徐京梅', 19110387252, '11010119740426052X ', 2, 2, 1, 1650029668), (146, 2, 41, 40, '徐京梅', 18611724143, ' 11010119740426052X ', 2, 2, 1, 1650029668), (147, 2, 32, 32, '范伦才', 17636381829, '140402195903100431 ', 2, 2, 1, 1650029668), (148, 2, 27, 27, '舒智强', 18771988909, '420102199902201010 ', 2, 2, 1, 1650029668), (149, 2, 27, 27, '舒兰玲', 18694077191, '422301197009240540 ', 2, 2, 1, 1650029668), (150, 2, 27, 27, '舒兰玲', 17671642275, '422301197009240540 ', 2, 2, 1, 1650029668), (151, 2, 27, 27, '舒兰玲', 18607104973, '422301197009240540 ', 2, 2, 1, 1650029668), (152, 2, 27, 27, '陈靖剑', 18271957285, '420104197404014320 ', 2, 2, 1, 1650029668), (153, 2, 27, 27, '舒宗雄', 18071026837, '422322197308121818 ', 2, 2, 1, 1650029668), (154, 2, 27, 27, '舒一雄', 13451107188, '422322197008081818 ', 2, 2, 1, 1650029668), (155, 2, 27, 27, '舒慧', 18771988911, '422322197808270043 ', 2, 2, 1, 1650029668), (156, 2, 27, 27, '舒兰玲', 18086040220, '422301197009240540 ', 2, 2, 1, 1650029668), (157, 2, 27, 27, '舒兰玲', 15071436552, '422301197009240540 ', 2, 2, 1, 1650029668), (158, 2, 6, 6, '陈迪春', 13957715059, '330321196211074213 ', 2, 2, 1, 1650029668), (159, 2, 6, 6, '丁凝一', 13157782102, '330302195701024063 ', 2, 2, 1, 1650029668), (160, 2, 6, 6, '贾春艳', 13936466717, '230105195804191643 ', 2, 2, 1, 1650029668), (161, 2, 6, 6, '李维真', 13736321266, '330321196803214224 ', 2, 2, 1, 1650029668), (162, 2, 21, 21, '李维真', 13868662576, '330321196803214224 ', 2, 2, 1, 1650029668), (163, 2, 21, 21, '李维真', 15858701426, '330321196803214224 ', 2, 2, 1, 1650029668), (164, 2, 21, 21, '李维真', 15868537389, '330321196803214224 ', 2, 2, 1, 1650029668), (165, 2, 21, 21, '李维真', 18957768872, '330321196803214224 ', 2, 2, 1, 1650029668), (166, 2, 23, 23, '罗威', 19957713268, '330328199708314014 ', 2, 2, 1, 1650029668), (167, 2, 23, 23, '罗子忠', 18958982965, '330329197501094939 ', 2, 2, 1, 1650029668), (168, 2, 23, 23, '罗子忠', 17367180051, '330329197501094939 ', 2, 2, 1, 1650029668), (169, 2, 3, 3, '曾韩英', 13977049319, '432503197712205507 ', 2, 2, 1, 1650029668), (170, 2, 14, 14, '姜丁文', 13587865868, '330304199309070621 ', 2, 2, 1, 1650029668), (171, 2, 14, 14, '姜蓓晶', 17758132786, '330321196810050627 ', 2, 2, 1, 1650029668), (172, 2, 17, 17, '廖光明', 18924363999, '330329197107290026 ', 2, 2, 1, 1650029668), (173, 2, 17, 17, '廖光明', 18925707999, '330329197107290026 ', 2, 2, 1, 1650029668), (174, 2, 39, 38, '徐小玲', 18857745187, '330302196207163628 ', 2, 2, 1, 1650029668), (175, 2, 39, 38, '徐小玲', 13868699118, '330302196207163628 ', 2, 2, 1, 1650029668), (176, 2, 39, 38, '徐小玲', 13088662887, '330302196207163628 ', 2, 2, 1, 1650029668), (177, 2, 39, 38, '徐小玲', 13906642381, '330302196207163628 ', 2, 2, 1, 1650029668), (178, 2, 39, 38, '徐小玲', 15067803381, '330302196207163628 ', 2, 2, 1, 1650029668), (179, 2, 39, 38, '徐小玲', 13738749722, '330302196207163628 ', 2, 2, 1, 1650029668), (180, 2, 2, 2, '安燕玲', 13311001230, '110108197402032720 ', 2, 2, 1, 1650029668), (181, 2, 29, 29, '孙建业', 13366127285, '131022199402110317 ', 2, 2, 1, 1650029668), (182, 2, 29, 29, '孙立波', 18513136872, '220123197002267116 ', 2, 2, 1, 1650029668), (183, 2, 1, 1, '安艳娟', 13681041973, '110109197812301221 ', 2, 2, 1, 1650029668), (184, 2, 1, 1, '安艳娟', 13718985072, '110109197812301221 ', 2, 2, 1, 1650029668), (185, 2, 1, 1, '贾盛花', 13301167006, '110108197402016325 ', 2, 2, 1, 1650029668), (186, 2, 1, 1, '曹振', 15935939606, '142701198909084212 ', 2, 2, 1, 1650029668), (187, 2, 1, 1, '安艳娟', 13263185602, '110109197812301221 ', 2, 2, 1, 1650029668), (188, 2, 1, 1, '安艳娟', 13021125191, '110109197812301221 ', 2, 2, 1, 1650029668), (189, 2, 1, 1, '安艳娟', 13716595279, '110109197812301221 ', 2, 2, 1, 1650029668), (190, 2, 1, 1, '安艳娟', 13301308991, '110109197812301221 ', 2, 2, 1, 1650029668), (191, 2, 1, 1, '安艳娟', 13146155477, '110109197812301221 ', 2, 2, 1, 1650029668), (192, 2, 1, 1, '安艳娟', 15210972422, '110109197812301221 ', 2, 2, 1, 1650029668), (193, 2, 1, 1, '安艳娟', 18610024101, '110109197812301221 ', 2, 2, 1, 1650029668), (194, 2, 25, 25, '王春荣', 13552296237, '110226196001021629 ', 2, 2, 1, 1650029668), (195, 2, 25, 25, '杨洪', 13911844298, '110222197312202426 ', 2, 2, 1, 1650029668), (196, 2, 25, 25, '马连胜', 19512219843, '11010519601028153X ', 2, 2, 1, 1650029668), (197, 2, 25, 25, '马连胜', 15201478828, '11010519601028153X ', 2, 2, 1, 1650029668), (198, 2, 25, 25, '李秀云', 18519273633, '110226196301271929 ', 2, 2, 1, 1650029668), (199, 2, 25, 25, '马连胜', 18518043063, '11010519601028153X ', 2, 2, 1, 1650029668), (200, 2, 25, 25, '马连胜', 18612741793, '11010519601028153X ', 2, 2, 1, 1650029668), (201, 2, 25, 25, '马连胜', 15810156842, '11010519601028153X ', 2, 2, 1, 1650029668), (202, 2, 25, 25, '马连胜', 15910498271, '11010519601028153X ', 2, 2, 1, 1650029668), (203, 2, 52, 51, '庄丽容', 13950053218, '350628197205232528 ', 2, 2, 1, 1650029668), (204, 1, 33, 53, '王英', 18911549599, '511124198206073226 ', 2, 2, 1, 1650029668), (205, 2, 34, 33, '王玉环', 13522360422, '341221197303058706 ', 2, 2, 1, 1650029668), (206, 2, 34, 33, '王玉环', 13832658727, '341221197303058706 ', 2, 2, 1, 1650029668), (207, 2, 12, 12, '黄京红', 13260164131, '110102196302072773 ', 2, 2, 1, 1650029668), (208, 2, 51, 50, '周兆兰', 13269033968, '110224196509161013 ', 2, 2, 1, 1650029668), (209, 2, 42, 41, '吕长军', 18943677797, '220105197204271612 ', 2, 2, 1, 1650029668), (210, 2, 42, 41, '王淑云', 15092297917, '370206196307204826 ', 2, 2, 1, 1650029668), (211, 2, 42, 41, '杨素华', 18660226488, '370206196110274820 ', 2, 2, 1, 1650029668), (212, 2, 42, 41, '杨素芹', 13573854487, '370281196302073548 ', 2, 2, 1, 1650029668), (213, 2, 42, 41, '魏论文', 18661899554, '37021319940223481X ', 2, 2, 1, 1650029668), (214, 2, 42, 41, '汤赟', 18961541971, '320282198302060516 ', 2, 2, 1, 1650029668), (215, 2, 42, 41, '杨素华', 15615728689, '370206196110274820 ', 2, 2, 1, 1650029668), (216, 2, 42, 41, '杨素华', 15841357502, '370206196110274820 ', 2, 2, 1, 1650029668), (217, 2, 42, 41, '杨素华', 15553231718, '370206196110274820 ', 2, 2, 1, 1650029668), (218, 2, 11, 11, '李川', 17614824611, '150203198702200920 ', 2, 2, 1, 1650029668), (219, 2, 11, 11, '寇汝勤', 15647252879, '150203195908251068 ', 2, 2, 1, 1650029668), (220, 2, 11, 11, '葛辰朝', 18838711228, '410728199203036532 ', 2, 2, 1, 1650029668), (221, 2, 11, 11, '葛济广', 15149329931, '410728196912256534 ', 2, 2, 1, 1650029668), (222, 2, 48, 47, '赵淑荣', 18141164511, '230229197201053669 ', 2, 2, 1, 1650029668), (223, 2, 35, 34, '武俊林', 19804717968, '142636197808224714 ', 2, 2, 1, 1650029668), (224, 2, 22, 22, '李卓莹', 17326828343, '130204198203063629 ', 2, 2, 1, 1650029668), (225, 1, 54, 54, '王晓丽', 18514793841, '370303199003201722 ', 2, 2, 1, 1650029668); -- -------------------------------------------------------- -- -- 表的结构 `churen_option_push_cash` -- DROP TABLE IF EXISTS `churen_option_push_cash`; CREATE TABLE `churen_option_push_cash` ( `id` int(11) UNSIGNED NOT NULL COMMENT 'ID', `aid` int(11) NOT NULL DEFAULT '-1' COMMENT '期权登录账户', `mid` int(11) NOT NULL DEFAULT '-1' COMMENT '期权账户', `type` tinyint(1) NOT NULL DEFAULT '2' COMMENT '操作类型', `cash` float(11,2) NOT NULL DEFAULT '0.00' COMMENT '操作金额-金额单位为元', `desc` varchar(600) DEFAULT NULL COMMENT '备注', `admin_founder` int(11) NOT NULL DEFAULT '0' COMMENT '插入操作人', `admin_editor` int(11) NOT NULL DEFAULT '0' COMMENT '更新操作人', `status` int(11) NOT NULL DEFAULT '1' COMMENT '发放状态', `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态', `cdate` int(11) NOT NULL DEFAULT '0' COMMENT '交易时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 转存表中的数据 `churen_option_push_cash` -- INSERT INTO `churen_option_push_cash` (`id`, `aid`, `mid`, `type`, `cash`, `desc`, `admin_founder`, `admin_editor`, `status`, `state`, `cdate`) VALUES (1, 331, 1112, 1, 15000.00, '这个苦事故阿斯顿发送到发送地方', 0, 0, 1, 1, 1649662820), (2, 331, 1112, 4, 10000.00, '看见好看巨好看巨好看', 0, 0, 1, 1, 1649662839), (3, 332, 1114, 1, 1500000.00, '短发短发短发', 0, 0, 1, 1, 1649663428), (4, 332, 1114, 4, 10000.00, '离开就离开家', 0, 0, 1, 1, 1649663488); -- -- 转储表的索引 -- -- -- 表的索引 `churen_option_account` -- ALTER TABLE `churen_option_account` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_option_agreement` -- ALTER TABLE `churen_option_agreement` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_option_bill_duifu` -- ALTER TABLE `churen_option_bill_duifu` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_option_bill_fafang` -- ALTER TABLE `churen_option_bill_fafang` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_option_bill_jiaofu` -- ALTER TABLE `churen_option_bill_jiaofu` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_option_cash` -- ALTER TABLE `churen_option_cash` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_option_member` -- ALTER TABLE `churen_option_member` ADD PRIMARY KEY (`id`); -- -- 表的索引 `churen_option_push_cash` -- ALTER TABLE `churen_option_push_cash` ADD PRIMARY KEY (`id`); -- -- 在导出的表使用AUTO_INCREMENT -- -- -- 使用表AUTO_INCREMENT `churen_option_account` -- ALTER TABLE `churen_option_account` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=55; -- -- 使用表AUTO_INCREMENT `churen_option_agreement` -- ALTER TABLE `churen_option_agreement` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID'; -- -- 使用表AUTO_INCREMENT `churen_option_bill_duifu` -- ALTER TABLE `churen_option_bill_duifu` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID'; -- -- 使用表AUTO_INCREMENT `churen_option_bill_fafang` -- ALTER TABLE `churen_option_bill_fafang` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID'; -- -- 使用表AUTO_INCREMENT `churen_option_bill_jiaofu` -- ALTER TABLE `churen_option_bill_jiaofu` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=329; -- -- 使用表AUTO_INCREMENT `churen_option_cash` -- ALTER TABLE `churen_option_cash` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=282; -- -- 使用表AUTO_INCREMENT `churen_option_member` -- ALTER TABLE `churen_option_member` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=226; -- -- 使用表AUTO_INCREMENT `churen_option_push_cash` -- ALTER TABLE `churen_option_push_cash` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=5; COMMIT; /*!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 */;