/*
 Navicat Premium Data Transfer

 Source Server         : 爱康高级测试
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : 47.92.206.87:4000
 Source Schema         : new_aikang_db

 Target Server Type    : MySQL
 Target Server Version : 50725
 File Encoding         : 65001

 Date: 21/07/2020 16:04:22
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for AR_CONFIG
-- ----------------------------
DROP TABLE IF EXISTS `AR_CONFIG`;
CREATE TABLE `AR_CONFIG` (
  `CONFIG_NAME` varchar(32) NOT NULL COMMENT '配置参数名',
  `TITLE` varchar(48) NOT NULL COMMENT '标题',
  `UNIT` varchar(32) DEFAULT NULL COMMENT '单位',
  `INPUT_TYPE` int(2) NOT NULL DEFAULT 1 COMMENT '表单类型',
  `OPTIONS` text DEFAULT NULL COMMENT '参数配置的选项',
  `VALUE` text NOT NULL COMMENT '配置值',
  `TYPE` varchar(32) NOT NULL COMMENT '类型',
  `SORT` int(10) NOT NULL DEFAULT 1 COMMENT '排序',
  `CREATED_AT` int(10) NOT NULL COMMENT '创建时间',
  `UPDATED_AT` int(10) NOT NULL DEFAULT 0 COMMENT '更新时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='系统配置表';

-- ----------------------------
-- Records of AR_CONFIG
-- ----------------------------
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;

SET FOREIGN_KEY_CHECKS = 1;
