ngds/sql/v2.0.0/aikang_db_init.sql

INSERT INTO `AR_AD` (ID, TITLE, IMAGE, TYPE, LID, CONTENT, SORT, STATUS, CREATE_ADMIN, UPDATE_ADMIN, CREATED_AT, UPDATED_AT) VALUES ('97D768C0C80C1301E053693418AC7112', '点点滴滴', 'http://upload.lxak2020.com/files/2019/1227/c6cbf858284911eaacd700163e007e21.jpg', 1, '7EFF6260A16C3CC7E053693418AC03E4', '#', 10, 1, '8E57B73F979B0863E053693418AC9F70', null, 1574322019, 0);

INSERT INTO `AR_ADMIN` VALUES ('7d43ed1e579a11ea95b9e8612aaeea8d', 'admin', 'admin', '', '666A7F102B8D6C66E055736AECE8644D', 1, 'asdsad', '$2y$13$ZTJsT7UpOiaebII1ex3vV.boCW9hTJseV3/pbuYJ2lQQltcKq/hcG', NULL, 1, 0, 8, 0, '127.0.0.1', 1582624678, '', '65F27BCE7FD278FFE055736AECE8644D', NULL, 1519978161, 0, 0);

INSERT INTO `AR_ADMIN_ROLE` VALUES ('666A7F102B8D6C66E055736AECE8644D', '超级管理员', '全局管理', NULL, NULL, 1, '65F27BCE7FD278FFE055736AECE8644D', NULL, 1519978161, 0);

INSERT INTO `AR_AD_LOCATION` (ID, LOCATION_NAME, REMARK, TYPE, CREATE_ADMIN, UPDATE_ADMIN, CREATED_AT, UPDATED_AT) VALUES ('7EFF6260A16C3CC7E053693418AC03E4', 'PC首页幻灯', 'PC首页幻灯', 1, '65F27BCE7FD278FFE055736AECE8644D', null, 1523245926, 0);

BEGIN;
INSERT INTO `AR_CONFIG` VALUES ('siteTitle', '网站标题', NULL, 1, NULL, '会员管理系统', 'base', 1, 1521085263, 1588054426);
INSERT INTO `AR_CONFIG` VALUES ('decPercent', '报单奖比例', '%', 1, NULL, '3', 'bonus', 2, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('transferOpen', '是否开启转账功能', NULL, 8, NULL, '1', 'transfer', 1, 1521085263, 1588053932);
INSERT INTO `AR_CONFIG` VALUES ('smsOpen', '是否开启短信通知', NULL, 8, NULL, '1', 'sms', 1, 1521085263, 1522396087);
INSERT INTO `AR_CONFIG` VALUES ('calcYear', '期数计算至年份', '年', 4, NULL, '2025', 'period', 1, 1521085263, 1583288578);
INSERT INTO `AR_CONFIG` VALUES ('siteClose', '是否关闭网站', NULL, 8, NULL, '0', 'base', 2, 1521085263, 1588054426);
INSERT INTO `AR_CONFIG` VALUES ('allowWallet', '转出转入配置', NULL, 10, NULL, '[{\"out\":\"bonus\",\"in\":\"cash\",\"outMin\":\"100\",\"outMax\":\"0\",\"fee\":\"0\",\"feeMin\":\"0\",\"feeMax\":\"0\",\"weekMax\":\"0\",\"monthMax\":\"0\",\"isSystem\":true,\"isBind\":true,\"isOpen\":true},{\"out\":\"bonus\",\"in\":\"bonus\",\"outMin\":\"100\",\"outMax\":\"0\",\"fee\":\"0\",\"feeMin\":\"0\",\"feeMax\":\"0\",\"weekMax\":\"0\",\"monthMax\":\"0\",\"isSystem\":true,\"isBind\":true,\"isOpen\":true},{\"out\":\"cash\",\"in\":\"cash\",\"outMin\":\"100\",\"outMax\":\"0\",\"fee\":\"0\",\"feeMin\":\"0\",\"feeMax\":\"0\",\"weekMax\":\"0\",\"monthMax\":\"0\",\"isSystem\":true,\"isBind\":true,\"isOpen\":true}]', 'transfer', 2, 1521085263, 1588053932);
INSERT INTO `AR_CONFIG` VALUES ('smsFee', '短信月费用', '元/月', 1, NULL, '10', 'sms', 2, 1521085263, 1524116298);
INSERT INTO `AR_CONFIG` VALUES ('closeWeekDate', '自动封期星期', NULL, 2, '[{\"label\":\"星期一\",\"value\":\"1\"},{\"label\":\"星期二\",\"value\":\"2\"},{\"label\":\"星期三\",\"value\":\"3\"},{\"label\":\"星期四\",\"value\":\"4\"},{\"label\":\"星期五\",\"value\":\"5\"},{\"label\":\"星期六\",\"value\":\"6\"},{\"label\":\"星期日\",\"value\":\"0\"}]', '1', 'period', 2, 1521085263, 1583288578);
INSERT INTO `AR_CONFIG` VALUES ('recPercent', '推广奖比例', '%', 1, NULL, '15', 'bonus', 4, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('siteCloseInfo', '关闭提示信息', NULL, 1, NULL, '网站正在维护中...', 'base', 3, 1521085263, 1588054426);
INSERT INTO `AR_CONFIG` VALUES ('pointsLayer', '业绩奖偶数层数', '层', 1, NULL, '10', 'bonus', 9, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('smsWallet', '短信费用扣除钱包', NULL, 2, '[{\"label\":\"奖金钱包\",\"value\":\"1\"},{\"label\":\"现金钱包\",\"value\":\"2\"}]', '1,2', 'sms', 3, 1521085263, 1524116298);
INSERT INTO `AR_CONFIG` VALUES ('closeTime', '自动封期时间', NULL, 7, '{\"start\":\"00:00\",\"end\":\"23:59\",\"step\":\"00:30\"}', '00:00', 'period', 3, 1521085263, 1583288578);
INSERT INTO `AR_CONFIG` VALUES ('smsContent', '短信内容', NULL, 9, NULL, '尊敬的会员{%REAL_NAME%}！您的最迟复销充值日期是{%LAST_RECHARGE_DATE%}、您{%MONTH%}{%IS_PASS%}，请留意您的复销状态；如已交复销请忽略此短信。', 'sms', 4, 1521085263, 1524116298);
INSERT INTO `AR_CONFIG` VALUES ('shareRegPerson', '共享奖注册时间人数', '人', 1, NULL, '7', 'bonus', 26, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('sharePercent', '共享奖比例', '%', 1, NULL, '5', 'bonus', 27, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('parentOddPercent_0', '管理奖1/3/5代比例', '%', 1, NULL, '5', 'bonus', 30, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('parentOddPercent_1', '管理奖7/9/11代比例', '%', 1, NULL, '4', 'bonus', 32, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('parentOddPercent_2', '管理奖13/15/17代比例', '%', 1, NULL, '3', 'bonus', 34, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('smsEmpOpen', '是否开启首次达到聘级短信通知', NULL, 8, NULL, '1', 'sms', 10, 1521085263, 1522396087);
INSERT INTO `AR_CONFIG` VALUES ('parentOddPercent_3', '管理奖19/21/23代比例', '%', 1, NULL, '2', 'bonus', 36, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('smsEmp', '达到的聘级', NULL, 2, '[{\"label\":\"高级经理\",\"value\":\"1\"},{\"label\":\"合格高级经理\",\"value\":\"2\"},{\"label\":\"一钻经理\",\"value\":\"3\"},{\"label\":\"二钻经理\",\"value\":\"4\"},{\"label\":\"三钻经理\",\"value\":\"5\"},{\"label\":\"四钻经理\",\"value\":\"6\"},{\"label\":\"五钻经理\",\"value\":\"7\"},{\"label\":\"六钻经理\",\"value\":\"8\"},{\"label\":\"七钻经理\",\"value\":\"9\"},{\"label\":\"七星董事\",\"value\":\"10\"},{\"label\":\"六星董事\",\"value\":\"11\"},{\"label\":\"三星董事\",\"value\":\"12\"}]', '1,2,3,4,5,6,7,8,9,10,11,12', 'sms', 11, 1521085263, 1524116298);
INSERT INTO `AR_CONFIG` VALUES ('reConsumePointsPercent', '重复消费积分比例', '%', 1, NULL, '10', 'bonus', 51, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('smsEmpContent', '聘级短信内容', NULL, 9, NULL, '尊敬的会员{%REAL_NAME%}！恭喜您于{%EMP_LV_DATE%}升级到{%EMP_LV%}。', 'sms', 12, 1521085263, 1524116298);
INSERT INTO `AR_CONFIG` VALUES ('reConsumePointsMonthCap', '重复消费积分每月上限', '积分', 1, NULL, '1000', 'bonus', 52, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('showBonusPeriodNum', '前台可见往期奖金期数', '期', 1, NULL, '10', 'other', 13, 1521085263, 1588053935);
INSERT INTO `AR_CONFIG` VALUES ('manageTaxPercent', '管理费比例', '%', 1, NULL, '5', 'bonus', 53, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('showFlowPeriodNum', '前台可见交易记录期数', '期', 1, NULL, '10', 'other', 14, 1521085263, 1588053935);
INSERT INTO `AR_CONFIG` VALUES ('bonusTotalZeroLimit', '总收入限制(推荐0人)', '倍', 1, NULL, '1', 'bonus', 54, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('showTransferPeriodNum', '前台可见转账记录期数', '期', 1, NULL, '10', 'other', 15, 1521085263, 1588053935);
INSERT INTO `AR_CONFIG` VALUES ('bonusTotalOneLimit', '总收入限制(推荐1人)', '倍', 1, NULL, '2', 'bonus', 55, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('showWithdrawPeriodNum', '前台可见提现记录期数', '期', 1, NULL, '10', 'other', 16, 1521085263, 1588053935);
INSERT INTO `AR_CONFIG` VALUES ('bonusTotalTwoLimit', '总收入限制(推荐2人)', '倍', 1, NULL, '4', 'bonus', 56, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('sameEmpLevelPercent', '相同聘级荣衔奖比例', '%', 1, NULL, '10', 'bonus', 38, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('openQY', '是否开启团队奖', NULL, 8, NULL, '1', 'bonus', 7, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('openYC', '是否开启荣衔奖', NULL, 8, NULL, '1', 'bonus', 37, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('openBD', '是否开启报单奖', NULL, 8, NULL, '1', 'bonus', 1, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('manualWithdrawMinAmount', '手动提现最低金额', '元', 1, NULL, '100', 'other', 23, 1521085263, 1588053935);
INSERT INTO `AR_CONFIG` VALUES ('openTG', '是否开启推广奖', NULL, 8, NULL, '1', 'bonus', 3, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('openYJ', '是否开启业绩奖', NULL, 8, NULL, '1', 'bonus', 8, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('openGX', '是否开启共享奖', NULL, 8, NULL, '1', 'bonus', 22, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('withdrawFreezeDays', '提现预付款天数', '天', 1, NULL, '30', 'other', 26, 1521085263, 1588053935);
INSERT INTO `AR_CONFIG` VALUES ('openGL', '是否开启管理奖', NULL, 8, NULL, '1', 'bonus', 28, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('isCanWithdrawBack', '是否开启前台提现退回功能', NULL, 8, NULL, '1', 'other', 27, 1521085263, 1588053935);
INSERT INTO `AR_CONFIG` VALUES ('autoClosePeriod', '自动封期', NULL, 8, NULL, '1', 'other', 41, 1521085263, 1588053935);
INSERT INTO `AR_CONFIG` VALUES ('autoCalcPeriod', '自动结算', NULL, 8, NULL, '1', 'other', 42, 1521085263, 1588053935);
INSERT INTO `AR_CONFIG` VALUES ('isCanTransferProp', '是否开启单笔转账比例', NULL, 8, NULL, '1', 'other', 43, 1521085263, 1588053935);
INSERT INTO `AR_CONFIG` VALUES ('backupWeekDate', '备份星期', NULL, 2, '[{\"label\":\"星期一\",\"value\":\"1\"},{\"label\":\"星期二\",\"value\":\"2\"},{\"label\":\"星期三\",\"value\":\"3\"},{\"label\":\"星期四\",\"value\":\"4\"},{\"label\":\"星期五\",\"value\":\"5\"},{\"label\":\"星期六\",\"value\":\"6\"},{\"label\":\"星期日\",\"value\":\"0\"}]', '6', 'other', 44, 1521085263, 1588053935);
INSERT INTO `AR_CONFIG` VALUES ('backupTime', '备份时间', NULL, 7, '{\"start\":\"00:00\",\"end\":\"23:59\",\"step\":\"00:30\"}', '03:30', 'other', 45, 1521085263, 1588053935);
INSERT INTO `AR_CONFIG` VALUES ('historyBonusLimit', '奖金余额备份近几周', '周', 1, NULL, '5', 'other', 46, 1521085263, 1588053935);
INSERT INTO `AR_CONFIG` VALUES ('payPasswordRule', '支付密码规则', NULL, 2, '[{\"label\":\"无\",\"value\":\"0\"},{\"label\":\"身份证后6位\",\"value\":\"id_s_6\"},{\"label\":\"身份证前8位\",\"value\":\"id_p_8\"},{\"label\":\"用户名\",\"value\":\"user_name\"}]', 'user_name', 'other', 47, 1521085263, 1588053935);
INSERT INTO `AR_CONFIG` VALUES ('passwordRule', '密码规则', NULL, 2, '[{\"label\":\"无\",\"value\":\"0\"},{\"label\":\"身份证后6位\",\"value\":\"id_s_6\"},{\"label\":\"身份证前8位\",\"value\":\"id_p_8\"},{\"label\":\"用户名\",\"value\":\"user_name\"}]', '0', 'other', 48, 1521085263, 1588053935);
INSERT INTO `AR_CONFIG` VALUES ('pvRatio', 'PV比例', NULL, 1, NULL, '0.7', 'other', 49, 1521085263, 1588053935);
INSERT INTO `AR_CONFIG` VALUES ('isDecReg', '只允许报单中心报单', NULL, 8, NULL, '0', 'other', 50, 1521085263, 1588053935);
INSERT INTO `AR_CONFIG` VALUES ('withdrawFee', '提现手续费', '%', 1, NULL, '3', 'other', 26, 1521085263, 1588053935);
INSERT INTO `AR_CONFIG` VALUES ('cashReconsumeBonusPercent', '现金购物PV算奖比例', '%', 1, NULL, '62.5', 'bonus', 57, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('parentOddIncomeFrom_0', '管理奖1/3/5代收入来源', '', 3, '[{\"label\":\"推广奖\",\"value\":\"TG\"},{\"label\":\"业绩奖\",\"value\":\"YJ\"},{\"label\":\"团队奖\",\"value\":\"QY\"}]', 'TG,YJ,QY', 'bonus', 29, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('parentOddIncomeFrom_1', '管理奖7/9/11代收入来源', NULL, 3, '[{\"label\":\"推广奖\",\"value\":\"TG\"},{\"label\":\"业绩奖\",\"value\":\"YJ\"},{\"label\":\"团队奖\",\"value\":\"QY\"}]', 'TG,YJ,QY', 'bonus', 31, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('parentOddIncomeFrom_2', '管理奖13/15/17代收入来源', NULL, 3, '[{\"label\":\"推广奖\",\"value\":\"TG\"},{\"label\":\"业绩奖\",\"value\":\"YJ\"},{\"label\":\"团队奖\",\"value\":\"QY\"}]', 'TG,YJ,QY', 'bonus', 33, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('shareIncomeFrom', '共享奖收入来源', NULL, 3, '[{\"label\":\"推广奖\",\"value\":\"TG\"},{\"label\":\"业绩奖\",\"value\":\"YJ\"},{\"label\":\"团队奖\",\"value\":\"QY\"}]', 'TG,YJ,QY', 'bonus', 25, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('shareRecPercent', '共享奖推荐人比例', '%', 1, NULL, '5', 'bonus', 24, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('parentOddIncomeFrom_3', '管理奖19/21/23代收入来源', NULL, 3, '[{\"label\":\"推广奖\",\"value\":\"TG\"},{\"label\":\"业绩奖\",\"value\":\"YJ\"},{\"label\":\"团队奖\",\"value\":\"QY\"}]', 'TG,YJ,QY', 'bonus', 35, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('shareRecIncomeFrom', '共享奖推荐人收入来源', NULL, 3, '[{\"label\":\"推广奖\",\"value\":\"TG\"},{\"label\":\"业绩奖\",\"value\":\"YJ\"},{\"label\":\"团队奖\",\"value\":\"QY\"}]', 'TG,YJ,QY', 'bonus', 23, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('pointsPercent_2', '业绩奖2层比例', '%', 1, NULL, '1', 'bonus', 11, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('pointsPercent_4', '业绩奖4层比例', '%', 1, NULL, '1', 'bonus', 12, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('pointsPercent_6', '业绩奖6层比例', '%', 1, NULL, '1', 'bonus', 13, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('pointsPercent_8', '业绩奖8层比例', '%', 1, NULL, '1', 'bonus', 14, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('pointsPercent_10', '业绩奖10层比例', '%', 1, NULL, '1', 'bonus', 15, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('pointsPercent_12', '业绩奖12层比例', '%', 1, NULL, '1', 'bonus', 16, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('pointsPercent_14', '业绩奖14层比例', '%', 1, NULL, '1', 'bonus', 17, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('pointsPercent_16', '业绩奖16层比例', '%', 1, NULL, '1', 'bonus', 18, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('pointsPercent_18', '业绩奖18层比例', '%', 1, NULL, '1', 'bonus', 19, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('pointsPercent_18', '业绩奖18层比例', '%', 1, NULL, '1', 'bonus', 20, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('pointsPercent_20', '业绩奖20层比例', '%', 1, NULL, '1', 'bonus', 21, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('pointsPercent', '业绩奖默认比例', '%', 1, NULL, '1', 'bonus', 10, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('fxRecRecPercent', '复消推广奖-推荐人比例', '%', 1, NULL, '15', 'bonus', 5, 1521085263, 1594777830);
INSERT INTO `AR_CONFIG` VALUES ('fxRecSelfPercent', '复消推广奖-自己比例', '%', 1, NULL, '15', 'bonus', 6, 1521085263, 1594777830);
COMMIT;

BEGIN;
INSERT INTO `AR_DEAL_TYPE` VALUES ('01A753D2548F44FA99B847133C1B5F79', '提现退回', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
INSERT INTO `AR_DEAL_TYPE` VALUES ('01C2916A2ECA4D1B9C29AA333C6D13E7', '复消积分转出', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
INSERT INTO `AR_DEAL_TYPE` VALUES ('1145D8ABA7A7471FB59B6760BDB19019', '短信服务费', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
INSERT INTO `AR_DEAL_TYPE` VALUES ('141E52002AAE43B7AC304F4BAEFDA268', '奖金发放', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
INSERT INTO `AR_DEAL_TYPE` VALUES ('37B81A45F38646A0A16499AB27B51923', '补发', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
INSERT INTO `AR_DEAL_TYPE` VALUES ('37EFF25E5E3F46A6BB84B8C55997F276', '永久关停扣除', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
INSERT INTO `AR_DEAL_TYPE` VALUES ('6626ED606DB34A11B6CCEA768B6E36C2', '奖金提现', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
INSERT INTO `AR_DEAL_TYPE` VALUES ('A1F1E76F34EE4981AB3BF4F8D20BB53E', '注销扣除', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
INSERT INTO `AR_DEAL_TYPE` VALUES ('A6BDF8A2E5F7450B80CBF3B28D8010D2', '复消积分发放', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
INSERT INTO `AR_DEAL_TYPE` VALUES ('DAA0FB1465F748908680D941D589326E', '转出', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
INSERT INTO `AR_DEAL_TYPE` VALUES ('DB62879E6C6B4B2F8591FAD920A2822C', '转入', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
INSERT INTO `AR_DEAL_TYPE` VALUES ('F6AA8D767E654D86917BBF1A5C24F439', '复消积分转入', '65F27BCE7FD278FFE055736AECE8644D', NULL, NULL, NULL, 1, 1, 1561942800, 0, 0);
COMMIT;

BEGIN;
INSERT INTO `AR_DECLARATION_LEVEL` VALUES ('67ABCB8C1F7D5519E055736AECE8644D', '银钻会员', 980.00, 2.00, 15000.00, 280000.00, 1, 13, 3.00, 1, 1, 2, 'admin', 'adminx', 158, NULL, 1521358140, 1581996445, 1, 2, 6, 10000.00);
INSERT INTO `AR_DECLARATION_LEVEL` VALUES ('67ABCCE20A9F5553E055736AECE8644D', '金钻会员', 2980.00, 2.00, 30000.00, 550000.00, 1, 14, 3.00, 1, 1, 3, 'admin', 'adminx', 140, NULL, 1521358162, 1581996462, 2, 4, 9, 100000.00);
INSERT INTO `AR_DECLARATION_LEVEL` VALUES ('67ABCE0ECE705575E055736AECE8644D', 'VIP会员', 9800.00, 2.00, 80000.00, 1050000.00, 1, 17, 3.00, 1, 1, 4, 'admin', 'adminx', 158, NULL, 1521358182, 1581996473, 3, 6, 12, 200000.00);
COMMIT;

BEGIN;
INSERT INTO `AR_DEC_ROLE` VALUES ('16B96B8D910E44EA86C89CC80F6BC76C', '一级报单中心', 0.00, 1, 1534749214, 1571380490, 'ADMINZ', 'ADMIN');
INSERT INTO `AR_DEC_ROLE` VALUES ('466CB7E1F32349C196B88ECBDE51C059', '二级报单中心', 0.00, 2, 1534749202, 1571380500, 'ADMINZ', 'ADMIN');
INSERT INTO `AR_DEC_ROLE` VALUES ('810916A06B304162902408A6B9E5D177', '三级报单中心', 0.00, 3, 1534749236, 1571380696, 'ADMINZ', 'ADMIN');
INSERT INTO `AR_DEC_ROLE` VALUES ('85B65542FCC341FAAFFAD0FA625CF9B8', '四级报单中心', 0.00, 4, 1534749225, 1571380719, 'ADMINZ', 'ADMIN');
INSERT INTO `AR_DEC_ROLE` VALUES ('8976C62F40064D8AB357BE07C8A3CA8F', '五级报单中心', 0.00, 5, 1534748970, 1571380687, 'ADMINZ', 'ADMIN');
COMMIT;

BEGIN;
INSERT INTO `AR_EMPLOY_LEVEL` VALUES ('67BE1C6C21F81B32E055736AECE8644D', '无聘级', 0, 0.00, 0.00, NULL, '[0,0,0,0,0,0,0,0,0,0]', 0.00, 0.00, 0.00, 0.00, 0, 1521436806, 1594603737, 'admin', 'adminy', 0, 0, 0.00, 0.00, 0);
INSERT INTO `AR_EMPLOY_LEVEL` VALUES ('67BE5FE7857C216AE055736AECE8644D', '主任', 2, 0.00, 0.00, 'E121497617216708615', '[0,0,0,0,0,0,0,0,0,0]', 0.00, 0.00, 0.00, 0.00, 2, 1521437938, 1594603783, 'admin', 'adminy', 1, 2, 3.00, 0.00, 1);
INSERT INTO `AR_EMPLOY_LEVEL` VALUES ('67BE6A4D03C52288E055736AECE8644D', '经理', 2, 0.00, 0.00, 'E121497617216708616', '[0,0,0,0,0,0,0,0,0,0]', 0.00, 0.00, 0.00, 0.00, 4, 1521438113, 1594191015, 'admin', 'adminy', 2, 1, 4.00, 0.00, 1);
INSERT INTO `AR_EMPLOY_LEVEL` VALUES ('67BE6EA2070D22EBE055736AECE8644D', '高级经理', 2, 0.00, 0.00, '67BE6A4D03C52288E055736AECE8644D', '[\"10\",0,0,0,0,0,0,0,0,0]', 0.00, 0.00, 0.00, 0.00, 5, 1521438185, 1594191004, 'admin', 'adminy', 2, 2, 4.50, 0.00, 1);
INSERT INTO `AR_EMPLOY_LEVEL` VALUES ('67BE742A336F2370E055736AECE8644D', '总监', 3, 0.00, 0.00, '67BE6EA2070D22EBE055736AECE8644D', '[\"10\",\"10\",0,0,0,0,0,0,0,0]', 0.00, 0.00, 0.00, 0.00, 6, 1521438278, 1594191007, 'admin', 'adminy', 3, 1, 5.00, 0.00, 1);
INSERT INTO `AR_EMPLOY_LEVEL` VALUES ('67BE805032C22492E055736AECE8644D', '高级总监', 3, 0.00, 0.00, '67BE742A336F2370E055736AECE8644D', '[\"10\",\"10\",\"10\",0,0,0,0,0,0,0]', 0.00, 0.00, 0.00, 0.00, 7, 1521438482, 1594191010, 'admin', 'adminy', 3, 2, 5.50, 0.00, 1);
INSERT INTO `AR_EMPLOY_LEVEL` VALUES ('67BE82019BE524CAE055736AECE8644D', '首席总监', 3, 0.00, 0.00, '67BE742A336F2370E055736AECE8644D', '[\"10\",\"10\",\"10\",\"5\",0,0,0,0,0,0]', 0.00, 0.00, 0.00, 0.00, 8, 1521438510, 1594630563, 'admin', 'adminy', 3, 3, 6.00, 0.00, 1);
INSERT INTO `AR_EMPLOY_LEVEL` VALUES ('E121497617216708615', '见习主任', 0, 0.00, 0.00, NULL, '[0,0,0,0,0,0,0,0,0,0]', 0.00, 0.00, 0.00, 0.00, 1, 1521437938, 1594609178, 'admin', 'adminy', 1, 1, 2.00, 100000.00, 0);
INSERT INTO `AR_EMPLOY_LEVEL` VALUES ('E121497617216708616', '高级主任', 2, 0.00, 0.00, '67BE5FE7857C216AE055736AECE8644D', '[0,0,0,0,0,0,0,0,0,0]', 0.00, 0.00, 0.00, 0.00, 3, 1521438113, 1594190968, 'admin', 'adminy', 1, 3, 3.50, 0.00, 1);
COMMIT;

INSERT INTO `AR_OCR_API` VALUES ('5955B56B0C0E465E8F0E65FBF86E5D44', 'baidu', '百度OCR识别', NULL, 1, '65F27BCE7FD278FFE055736AECE8644D', NULL, 1526960820, 0);

BEGIN;
INSERT INTO `AR_OPEN_BANK` VALUES ('95A71AF5E4D55466E053693418ACED88', '工商银行', '11111111', 1, 1571915532, 1572345780, 'CN0006', 0.00, 0.00, 0.00, 'ADMIN', 1);
INSERT INTO `AR_OPEN_BANK` VALUES ('960B4CAB7C07769CE053693418ACF6F7', '农业银行', '123456', 2, 1572345863, 0, 'ADMIN', 0.00, 0.00, 0.00, NULL, 1);
INSERT INTO `AR_OPEN_BANK` VALUES ('960B4D9367C776B7E053693418ACFCC1', '中国银行', '4566999', 3, 1572345878, 1573182295, 'ADMIN', 0.00, 0.00, 0.00, 'LIMIN', 1);
INSERT INTO `AR_OPEN_BANK` VALUES ('960B6924E1527B02E053693418AC2B0A', '民生银行', '456789', 14, 1572346341, 0, 'ADMIN', 0.00, 0.00, 0.00, NULL, 1);
INSERT INTO `AR_OPEN_BANK` VALUES ('960B6BDE22667B67E053693418ACF2B7', '招商银行', '789666', 5, 1572346386, 0, 'ADMIN', 0.00, 0.00, 0.00, NULL, 1);
INSERT INTO `AR_OPEN_BANK` VALUES ('960B7BDF35E67F01E053693418AC3102', '上海银行', '88585585', 13, 1572346655, 0, 'ADMIN', 0.00, 0.00, 0.00, NULL, 1);
INSERT INTO `AR_OPEN_BANK` VALUES ('9632D2ECCB120E33E053693418AC891C', '建设银行', '11111112', 4, 1572515619, 0, 'ADMINZ', 0.00, 0.00, 0.00, NULL, 1);
INSERT INTO `AR_OPEN_BANK` VALUES ('80106645488799744', '交通银行', '95559', 6, 1572515619, 0, 'ADMIN', 0.00, 0.00, 0.00, '', 1);
INSERT INTO `AR_OPEN_BANK` VALUES ('80106645497188352', '中信银行', '95558', 7, 1572515619, 0, 'ADMIN', 0.00, 0.00, 0.00, '', 1);
INSERT INTO `AR_OPEN_BANK` VALUES ('80106645497188355', '广发银行', '95508', 8, 1572515619, 0, 'ADMIN', 0.00, 0.00, 0.00, '', 1);
INSERT INTO `AR_OPEN_BANK` VALUES ('80124747588964358', '邮政储蓄银行', '95580', 9, 1572515619, 0, 'ADMIN', 0.00, 0.00, 0.00, '', 1);
INSERT INTO `AR_OPEN_BANK` VALUES ('80124747588964360\n', '兴业银行', '95561', 10, 1572515619, 0, 'ADMIN', 0.00, 0.00, 0.00, '', 1);
INSERT INTO `AR_OPEN_BANK` VALUES ('80124747588964354\n', '平安银行', '95511', 11, 1572515619, 0, 'ADMIN', 0.00, 0.00, 0.00, '', 1);
INSERT INTO `AR_OPEN_BANK` VALUES ('80138465332826120\n', '其他银行', '328776', 12, 1572515619, 0, 'ADMIN', 0.00, 0.00, 0.00, '', 1);
COMMIT;

BEGIN;
INSERT INTO `AR_REG_TYPE` VALUES ('28359A005A3E44C6816A4A7E994B7789', '个体工商户', 1, 0.00, 0.00, 2, NULL, NULL, NULL, 1521438677, 0);
INSERT INTO `AR_REG_TYPE` VALUES ('56D9181C0F5D428FA2DBD4CAB263BF2F', '个人', 1, 0.00, 0.00, 1, NULL, NULL, NULL, 1521438677, 0);
INSERT INTO `AR_REG_TYPE` VALUES ('758BF69C25C3422AA7743936BC77EE64', '公司', 1, 0.00, 0.00, 3, NULL, NULL, NULL, 1521438677, 0);
COMMIT;

INSERT INTO `AR_SMS_TEMPLATE` VALUES ('651074FEE2804DE695CDB00EDED342B0', '注册成功', '首购报单完成后给新注册的会员发送注册成功短信', 'REG_SUCCESS', '67ABCB8C1F7D5519E055736AECE8644D', NULL, '尊敬的{REAL_NAME}，您已注册成功，用户名：{USER_NAME}，报单金额{AMOUNT}', 1526002387);

INSERT INTO `AR_USER`(`ID`, `USER_NAME`, `PASSWORD_HASH`, `PAY_PASSWORD`, `NATION`, `REAL_NAME`, `ID_CARD`, `ID_TYPE`, `MOBILE`, `ADDRESS`, `ID_IMAGE`, `OPEN_BANK`, `BANK_ADDRESS`, `BANK_NO`, `BANK_PROVINCE`, `BANK_CITY`, `BANK_COUNTY`, `SPOUSE_NAME`, `SPOUSE_IDCARD`, `CREATED_AT`, `UPDATED_AT`, `STATUS`, `DEC_CLOSED`, `DEC_CLOSED_AT`, `DEC_LV`, `EMP_LV`, `PROVINCE`, `CITY`, `COUNTY`, `TEL`, `LOGIN_TIMES`, `LOGIN_IP`, `LOGIN_AT`, `PULL_MESSAGE_AT`, `SUB_COM_ID`, `AVATAR`, `DELETED`, `DELETED_AT`, `ALLOW_TRANSFER`, `TRANSFER_PROP`, `PARTITION_DATE`, `IS_DEC`, `DEC_ID`, `BIRTHDAY`, `DEC_ROLE_ID`, `PERIOD_AT`, `DEC_PROVINCE`, `DEC_CITY`, `DEC_COUNTY`, `IS_UNION`, `STATUS_AT`, `VERIFIED`, `VERIFIED_AT`, `ALLOW_LOGIN`, `NOT_OPERATING`, `REG_FROM`, `ID_CARD_PREFIX`, `ALLOW_BONUS_LOGIN`, `SEX`, `DEC_ACCOUNT_OLD`, `BANK_UPDATED_AT`, `IS_DIRECT_SELLER`, `DEC_LV_UPDATED_AT`, `DEC_LV_UPDATED_PERIOD`, `DEC_ADDRESS`, `DEC_PHONE`, `GUARANTOR`, `GUARANTOR_NAME`, `PART_FUNC_CLOSED`, `LAST_DEC_LV_UPDATED_PERIOD`, `USER_CREATOR`, `USER_UPDATER`, `LAST_DEC_LV_UPDATED_AT`, `DEC_CREATED_AT`, `PART_FUNC_CLOSED_REMARK`, `DEC_CREATED_PERIOD`, `PASSWORD_CHANGED`, `SUB_COM_LEADER`, `LOGIN_FAIL_TIMES`, `ZG_UPGRADE_PV`, `APP_CLIENT_ID`, `READ_AGREEMENT`, `LAST_DEC_LV`, `BONUS_APP_CLIENT_ID`, `IS_FIRST_OPEN`) VALUES ('670B84FD7C216D4EE055736AECE8644D', 'Q94839185', '$2y$13$SaUlrQmOvVklNywqBwHLPuW6x6c3VOTS.aCBVWkqCN.MiySmV1/hi', '$2y$13$bN0c48m12545XHRLYV9LM.qilBtBu0b7WLBLnzYL5lAhmruMR3QqC', 1, '齐长青', '370723197302176334', 0, '18763607339', '秦皇岛市东山街1000001号', 'http://upload.ar.wqcms.com/files/2018/0606/e0013022694b11e8b1af10ddb1d0e3fd', '789666', '鸽子窝110号', '6222***********0131', 130000, 130300, 130304, '瞬瞬', '130324198808081235', 1528770496, 1575450033, 1, 0, 0, '67ABCE0ECE705575E055736AECE8644D', '67BE5FE7857C216AE055736AECE8644D', 110000, 110100, 110101, '13826545212', 2659, '106.118.113.61', 1578879390, 0, '953BF18AE3694BC4E053693418ACAC98', 'http://upload.ar.wqcms.com/cdn/avatar/1.png', 0, 0, 1, 1.01, '2018-06-11 08:00:00', 1, '670B84FD7C216D4EE055736AECE8644D', '1977-08-10', '810916A06B304162902408A6B9E5D177', 117, 130000, 130200, 130203, 0, 1565921409, 1, 1571797394, 1, 0, 0, NULL, 1, '女', NULL, 0, 0, 1573003331, 158, '123', '15098156582', NULL, NULL, 0, 0, 'adminty', 'adminty', 0, 1572337842, '报单中心货款/会员货款余额15132.00,600010.00高于参数\"100.00\"关闭', 158, 3, 0, 5, 12000.00, NULL, 1, '67ABCE0ECE705575E055736AECE8644D', NULL, 1);
INSERT INTO `AR_USER_INFO`(`ID`, `USER_ID`, `USER_NAME`, `ZC_PV`, `CON_UID`, `REC_UID`, `CON_NUM`, `REC_NUM`, `NETWORK_DEEP`, `RELATION_DEEP`, `SYSTEM_ID`, `IS_GROUP_LEADER`, `IS_SYSTEM_LEADER`, `IS_TEAM`, `IS_BIND`, `IS_TEAM_MAIN`, `IS_BIND_MAIN`, `IS_AUTO_WITHDRAW`, `CLOSE_LOGIN`, `REG_TYPE`, `SHOULD_REG_TYPE`, `REG_NAME`, `CREDIT_CODE`, `PREMISES`, `LEGAL_PERSON`, `REG_EXPIRES`, `STORE_TYPE`, `INVOICE_BALANCE`, `HIGHEST_EMP_LV`, `CREATED_AT`, `UPDATED_AT`, `CLOSE_LOGIN_AT`, `PULLED_AT`, `DELETED`, `DELETED_AT`, `GROUP_LEADER_AT`, `ALLOW_TRANSFER`, `ALLOW_RECONSUME_SMS`, `ALLOW_RECONSUME_SMS_TO`, `HIGHEST_EMP_LV_PERIOD`, `TRANSFER_PROP`, `LOGIN_NUMS`, `FAIL_NUMS`, `LAST_LOGIN_IP`, `LAST_LOGIN_AT`, `SHOW_EMP_LV`, `ZC_AMOUNT`) VALUES ('74442999509159944', '670B84FD7C216D4EE055736AECE8644D', 'Q94839185', 600.000, '0', '0', 297, 4, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 1, 0, '56D9181C0F5D428FA2DBD4CAB263BF2F', '56D9181C0F5D428FA2DBD4CAB263BF2F', NULL, NULL, NULL, NULL, NULL, 0, 0.00, NULL, 1520667339, 0, 0, 1593940121, 0, 0, 0, 1, 0, 0, 103, 100.00, 571, 27, '10.10.1.2', 1593940121, '', 0.000);
INSERT INTO `AR_USER_NETWORK_NEW`(`ID`, `USER_ID`, `PARENT_UID`, `LOCATION_TAG`, `RELATIVE_LOCATION`, `TOP_UID`, `TOP_DEEP`, `PARENT_UIDS`, `CREATED_AT`, `UPDATED_AT`) VALUES ('123680871562743808', '670B84FD7C216D4EE055736AECE8644D', '0', '1', 0, '670B84FD7C216D4EE055736AECE8644D', 0, '', 1520667339, 0);
INSERT INTO `AR_USER_RELATION_NEW`(`ID`, `USER_ID`, `PARENT_UID`, `TOP_UID`, `TOP_DEEP`, `PARENT_UIDS`, `CREATED_AT`, `UPDATED_AT`) VALUES ('123688573491875840', '670B84FD7C216D4EE055736AECE8644D', '0', '670B84FD7C216D4EE055736AECE8644D', 0, '', 1520667339, 0);

BEGIN;
INSERT INTO `AR_WITHDRAW_LEVEL` VALUES ('7671AA8CA8DE4BF39C00BB5558416EAB', '56D9181C0F5D428FA2DBD4CAB263BF2F', 2001.00, 5000.00, 2.00, 1523435514);
INSERT INTO `AR_WITHDRAW_LEVEL` VALUES ('89CFFF1D53464165B173ED9B48AEC0C3', '56D9181C0F5D428FA2DBD4CAB263BF2F', 5001.00, NULL, 1.00, 1523437783);
INSERT INTO `AR_WITHDRAW_LEVEL` VALUES ('BE062D2EDA204B16B31DF8B06189AD07', '56D9181C0F5D428FA2DBD4CAB263BF2F', 0.00, 2000.00, 5.00, 1523435526);
COMMIT;