12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259 |
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET AUTOCOMMIT = 0;
- START TRANSACTION;
- SET time_zone = "+00:00";
- ;
- ;
- ;
- ;
- CREATE DATABASE IF NOT EXISTS `churen` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
- USE `churen`;
- 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;
- 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);
- 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;
- 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;
- 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;
- 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;
- 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);
- 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;
- 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);
- 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;
- 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);
- 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;
- 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);
- ALTER TABLE `churen_option_account`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `churen_option_agreement`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `churen_option_bill_duifu`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `churen_option_bill_fafang`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `churen_option_bill_jiaofu`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `churen_option_cash`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `churen_option_member`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `churen_option_push_cash`
- ADD PRIMARY KEY (`id`);
- ALTER TABLE `churen_option_account`
- MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=55;
- ALTER TABLE `churen_option_agreement`
- MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID';
- ALTER TABLE `churen_option_bill_duifu`
- MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID';
- ALTER TABLE `churen_option_bill_fafang`
- MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID';
- ALTER TABLE `churen_option_bill_jiaofu`
- MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=329;
- ALTER TABLE `churen_option_cash`
- MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=282;
- ALTER TABLE `churen_option_member`
- MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=226;
- ALTER TABLE `churen_option_push_cash`
- MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID', AUTO_INCREMENT=5;
- COMMIT;
- ;
- ;
- ;
|