Главная Обзор Помощь
Регистрация Вход
guanli
/
ngds
1
0
Ответвить 0
Файлы Задачи 0 Запросы на слияние 0 Вики
Дерево: e180034fc2
Ветки Метки
ngds
/
sql
/
2020_07
/
AR_CONFIG.sql

AR_CONFIG.sql 15 KB
История Исходник

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : 爱康高级测试
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 50725
    7. 

  7.  Source Host           : 47.92.206.87:4000
    8. 

  8.  Source Schema         : new_aikang_db
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 50725
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 21/07/2020 16:04:22
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

  20. -- ----------------------------
    21. 

  21. -- Table structure for AR_CONFIG
    22. 

  22. -- ----------------------------
    23. 

  23. DROP TABLE IF EXISTS `AR_CONFIG`;
    24. 

  24. CREATE TABLE `AR_CONFIG` (
    25. 

  25.   `CONFIG_NAME` varchar(32) NOT NULL COMMENT '配置参数名',
    26. 

  26.   `TITLE` varchar(48) NOT NULL COMMENT '标题',
    27. 

  27.   `UNIT` varchar(32) DEFAULT NULL COMMENT '单位',
    28. 

  28.   `INPUT_TYPE` int(2) NOT NULL DEFAULT 1 COMMENT '表单类型',
    29. 

  29.   `OPTIONS` text DEFAULT NULL COMMENT '参数配置的选项',
    30. 

  30.   `VALUE` text NOT NULL COMMENT '配置值',
    31. 

  31.   `TYPE` varchar(32) NOT NULL COMMENT '类型',
    32. 

  32.   `SORT` int(10) NOT NULL DEFAULT 1 COMMENT '排序',
    33. 

  33.   `CREATED_AT` int(10) NOT NULL COMMENT '创建时间',
    34. 

  34.   `UPDATED_AT` int(10) NOT NULL DEFAULT 0 COMMENT '更新时间'
    35. 

  35. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='系统配置表';
    36. 

  36. 

  37. -- ----------------------------
    38. 

  38. -- Records of AR_CONFIG
    39. 

  39. -- ----------------------------
    40. 

  40. BEGIN;
    41. 

  41. INSERT INTO `AR_CONFIG` VALUES ('siteTitle', '网站标题', NULL, 1, NULL, '会员管理系统', 'base', 1, 1521085263, 1588054426);
    42. 

  42. INSERT INTO `AR_CONFIG` VALUES ('decPercent', '报单奖比例', '%', 1, NULL, '3', 'bonus', 2, 1521085263, 1594777830);
    43. 

  43. INSERT INTO `AR_CONFIG` VALUES ('transferOpen', '是否开启转账功能', NULL, 8, NULL, '1', 'transfer', 1, 1521085263, 1588053932);
    44. 

  44. INSERT INTO `AR_CONFIG` VALUES ('smsOpen', '是否开启短信通知', NULL, 8, NULL, '1', 'sms', 1, 1521085263, 1522396087);
    45. 

  45. INSERT INTO `AR_CONFIG` VALUES ('calcYear', '期数计算至年份', '年', 4, NULL, '2025', 'period', 1, 1521085263, 1583288578);
    46. 

  46. INSERT INTO `AR_CONFIG` VALUES ('siteClose', '是否关闭网站', NULL, 8, NULL, '0', 'base', 2, 1521085263, 1588054426);
    47. 

  47. 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);
    48. 

  48. INSERT INTO `AR_CONFIG` VALUES ('smsFee', '短信月费用', '元/月', 1, NULL, '10', 'sms', 2, 1521085263, 1524116298);
    49. 

  49. 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);
    50. 

  50. INSERT INTO `AR_CONFIG` VALUES ('recPercent', '推广奖比例', '%', 1, NULL, '15', 'bonus', 4, 1521085263, 1594777830);
    51. 

  51. INSERT INTO `AR_CONFIG` VALUES ('siteCloseInfo', '关闭提示信息', NULL, 1, NULL, '网站正在维护中...', 'base', 3, 1521085263, 1588054426);
    52. 

  52. INSERT INTO `AR_CONFIG` VALUES ('pointsLayer', '业绩奖偶数层数', '层', 1, NULL, '10', 'bonus', 9, 1521085263, 1594777830);
    53. 

  53. INSERT INTO `AR_CONFIG` VALUES ('smsWallet', '短信费用扣除钱包', NULL, 2, '[{\"label\":\"奖金钱包\",\"value\":\"1\"},{\"label\":\"现金钱包\",\"value\":\"2\"}]', '1,2', 'sms', 3, 1521085263, 1524116298);
    54. 

  54. INSERT INTO `AR_CONFIG` VALUES ('closeTime', '自动封期时间', NULL, 7, '{\"start\":\"00:00\",\"end\":\"23:59\",\"step\":\"00:30\"}', '00:00', 'period', 3, 1521085263, 1583288578);
    55. 

  55. INSERT INTO `AR_CONFIG` VALUES ('smsContent', '短信内容', NULL, 9, NULL, '尊敬的会员{%REAL_NAME%}！您的最迟复销充值日期是{%LAST_RECHARGE_DATE%}、您{%MONTH%}{%IS_PASS%}，请留意您的复销状态；如已交复销请忽略此短信。', 'sms', 4, 1521085263, 1524116298);
    56. 

  56. INSERT INTO `AR_CONFIG` VALUES ('shareRegPerson', '共享奖注册时间人数', '人', 1, NULL, '7', 'bonus', 26, 1521085263, 1594777830);
    57. 

  57. INSERT INTO `AR_CONFIG` VALUES ('sharePercent', '共享奖比例', '%', 1, NULL, '5', 'bonus', 27, 1521085263, 1594777830);
    58. 

  58. INSERT INTO `AR_CONFIG` VALUES ('parentOddPercent_0', '管理奖1/3/5代比例', '%', 1, NULL, '5', 'bonus', 30, 1521085263, 1594777830);
    59. 

  59. INSERT INTO `AR_CONFIG` VALUES ('parentOddPercent_1', '管理奖7/9/11代比例', '%', 1, NULL, '4', 'bonus', 32, 1521085263, 1594777830);
    60. 

  60. INSERT INTO `AR_CONFIG` VALUES ('parentOddPercent_2', '管理奖13/15/17代比例', '%', 1, NULL, '3', 'bonus', 34, 1521085263, 1594777830);
    61. 

  61. INSERT INTO `AR_CONFIG` VALUES ('smsEmpOpen', '是否开启首次达到聘级短信通知', NULL, 8, NULL, '1', 'sms', 10, 1521085263, 1522396087);
    62. 

  62. INSERT INTO `AR_CONFIG` VALUES ('parentOddPercent_3', '管理奖19/21/23代比例', '%', 1, NULL, '2', 'bonus', 36, 1521085263, 1594777830);
    63. 

  63. 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);
    64. 

  64. INSERT INTO `AR_CONFIG` VALUES ('reConsumePointsPercent', '重复消费积分比例', '%', 1, NULL, '10', 'bonus', 51, 1521085263, 1594777830);
    65. 

  65. INSERT INTO `AR_CONFIG` VALUES ('smsEmpContent', '聘级短信内容', NULL, 9, NULL, '尊敬的会员{%REAL_NAME%}！恭喜您于{%EMP_LV_DATE%}升级到{%EMP_LV%}。', 'sms', 12, 1521085263, 1524116298);
    66. 

  66. INSERT INTO `AR_CONFIG` VALUES ('reConsumePointsMonthCap', '重复消费积分每月上限', '积分', 1, NULL, '1000', 'bonus', 52, 1521085263, 1594777830);
    67. 

  67. INSERT INTO `AR_CONFIG` VALUES ('showBonusPeriodNum', '前台可见往期奖金期数', '期', 1, NULL, '10', 'other', 13, 1521085263, 1588053935);
    68. 

  68. INSERT INTO `AR_CONFIG` VALUES ('manageTaxPercent', '管理费比例', '%', 1, NULL, '5', 'bonus', 53, 1521085263, 1594777830);
    69. 

  69. INSERT INTO `AR_CONFIG` VALUES ('showFlowPeriodNum', '前台可见交易记录期数', '期', 1, NULL, '10', 'other', 14, 1521085263, 1588053935);
    70. 

  70. INSERT INTO `AR_CONFIG` VALUES ('bonusTotalZeroLimit', '总收入限制(推荐0人)', '倍', 1, NULL, '1', 'bonus', 54, 1521085263, 1594777830);
    71. 

  71. INSERT INTO `AR_CONFIG` VALUES ('showTransferPeriodNum', '前台可见转账记录期数', '期', 1, NULL, '10', 'other', 15, 1521085263, 1588053935);
    72. 

  72. INSERT INTO `AR_CONFIG` VALUES ('bonusTotalOneLimit', '总收入限制(推荐1人)', '倍', 1, NULL, '2', 'bonus', 55, 1521085263, 1594777830);
    73. 

  73. INSERT INTO `AR_CONFIG` VALUES ('showWithdrawPeriodNum', '前台可见提现记录期数', '期', 1, NULL, '10', 'other', 16, 1521085263, 1588053935);
    74. 

  74. INSERT INTO `AR_CONFIG` VALUES ('bonusTotalTwoLimit', '总收入限制(推荐2人)', '倍', 1, NULL, '4', 'bonus', 56, 1521085263, 1594777830);
    75. 

  75. INSERT INTO `AR_CONFIG` VALUES ('sameEmpLevelPercent', '相同聘级荣衔奖比例', '%', 1, NULL, '10', 'bonus', 38, 1521085263, 1594777830);
    76. 

  76. INSERT INTO `AR_CONFIG` VALUES ('openQY', '是否开启团队奖', NULL, 8, NULL, '1', 'bonus', 7, 1521085263, 1594777830);
    77. 

  77. INSERT INTO `AR_CONFIG` VALUES ('openYC', '是否开启荣衔奖', NULL, 8, NULL, '1', 'bonus', 37, 1521085263, 1594777830);
    78. 

  78. INSERT INTO `AR_CONFIG` VALUES ('openBD', '是否开启报单奖', NULL, 8, NULL, '1', 'bonus', 1, 1521085263, 1594777830);
    79. 

  79. INSERT INTO `AR_CONFIG` VALUES ('manualWithdrawMinAmount', '手动提现最低金额', '元', 1, NULL, '100', 'other', 23, 1521085263, 1588053935);
    80. 

  80. INSERT INTO `AR_CONFIG` VALUES ('openTG', '是否开启推广奖', NULL, 8, NULL, '1', 'bonus', 3, 1521085263, 1594777830);
    81. 

  81. INSERT INTO `AR_CONFIG` VALUES ('openYJ', '是否开启业绩奖', NULL, 8, NULL, '1', 'bonus', 8, 1521085263, 1594777830);
    82. 

  82. INSERT INTO `AR_CONFIG` VALUES ('openGX', '是否开启共享奖', NULL, 8, NULL, '1', 'bonus', 22, 1521085263, 1594777830);
    83. 

  83. INSERT INTO `AR_CONFIG` VALUES ('withdrawFreezeDays', '提现预付款天数', '天', 1, NULL, '30', 'other', 26, 1521085263, 1588053935);
    84. 

  84. INSERT INTO `AR_CONFIG` VALUES ('openGL', '是否开启管理奖', NULL, 8, NULL, '1', 'bonus', 28, 1521085263, 1594777830);
    85. 

  85. INSERT INTO `AR_CONFIG` VALUES ('isCanWithdrawBack', '是否开启前台提现退回功能', NULL, 8, NULL, '1', 'other', 27, 1521085263, 1588053935);
    86. 

  86. INSERT INTO `AR_CONFIG` VALUES ('autoClosePeriod', '自动封期', NULL, 8, NULL, '1', 'other', 41, 1521085263, 1588053935);
    87. 

  87. INSERT INTO `AR_CONFIG` VALUES ('autoCalcPeriod', '自动结算', NULL, 8, NULL, '1', 'other', 42, 1521085263, 1588053935);
    88. 

  88. INSERT INTO `AR_CONFIG` VALUES ('isCanTransferProp', '是否开启单笔转账比例', NULL, 8, NULL, '1', 'other', 43, 1521085263, 1588053935);
    89. 

  89. 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);
    90. 

  90. INSERT INTO `AR_CONFIG` VALUES ('backupTime', '备份时间', NULL, 7, '{\"start\":\"00:00\",\"end\":\"23:59\",\"step\":\"00:30\"}', '03:30', 'other', 45, 1521085263, 1588053935);
    91. 

  91. INSERT INTO `AR_CONFIG` VALUES ('historyBonusLimit', '奖金余额备份近几周', '周', 1, NULL, '5', 'other', 46, 1521085263, 1588053935);
    92. 

  92. 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);
    93. 

  93. 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);
    94. 

  94. INSERT INTO `AR_CONFIG` VALUES ('pvRatio', 'PV比例', NULL, 1, NULL, '0.7', 'other', 49, 1521085263, 1588053935);
    95. 

  95. INSERT INTO `AR_CONFIG` VALUES ('isDecReg', '只允许报单中心报单', NULL, 8, NULL, '0', 'other', 50, 1521085263, 1588053935);
    96. 

  96. INSERT INTO `AR_CONFIG` VALUES ('withdrawFee', '提现手续费', '%', 1, NULL, '3', 'other', 26, 1521085263, 1588053935);
    97. 

  97. INSERT INTO `AR_CONFIG` VALUES ('cashReconsumeBonusPercent', '现金购物PV算奖比例', '%', 1, NULL, '62.5', 'bonus', 57, 1521085263, 1594777830);
    98. 

  98. 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);
    99. 

  99. 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);
    100. 

  100. 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);
    101. 

  101. INSERT INTO `AR_CONFIG` VALUES ('shareIncomeFrom', '共享奖收入来源', NULL, 3, '[{\"label\":\"推广奖\",\"value\":\"TG\"},{\"label\":\"业绩奖\",\"value\":\"YJ\"},{\"label\":\"团队奖\",\"value\":\"QY\"}]', 'TG,YJ,QY', 'bonus', 25, 1521085263, 1594777830);
    102. 

  102. INSERT INTO `AR_CONFIG` VALUES ('shareRecPercent', '共享奖推荐人比例', '%', 1, NULL, '5', 'bonus', 24, 1521085263, 1594777830);
    103. 

  103. 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);
    104. 

  104. INSERT INTO `AR_CONFIG` VALUES ('shareRecIncomeFrom', '共享奖推荐人收入来源', NULL, 3, '[{\"label\":\"推广奖\",\"value\":\"TG\"},{\"label\":\"业绩奖\",\"value\":\"YJ\"},{\"label\":\"团队奖\",\"value\":\"QY\"}]', 'TG,YJ,QY', 'bonus', 23, 1521085263, 1594777830);
    105. 

  105. INSERT INTO `AR_CONFIG` VALUES ('pointsPercent_2', '业绩奖2层比例', '%', 1, NULL, '1', 'bonus', 11, 1521085263, 1594777830);
    106. 

  106. INSERT INTO `AR_CONFIG` VALUES ('pointsPercent_4', '业绩奖4层比例', '%', 1, NULL, '1', 'bonus', 12, 1521085263, 1594777830);
    107. 

  107. INSERT INTO `AR_CONFIG` VALUES ('pointsPercent_6', '业绩奖6层比例', '%', 1, NULL, '1', 'bonus', 13, 1521085263, 1594777830);
    108. 

  108. INSERT INTO `AR_CONFIG` VALUES ('pointsPercent_8', '业绩奖8层比例', '%', 1, NULL, '1', 'bonus', 14, 1521085263, 1594777830);
    109. 

  109. INSERT INTO `AR_CONFIG` VALUES ('pointsPercent_10', '业绩奖10层比例', '%', 1, NULL, '1', 'bonus', 15, 1521085263, 1594777830);
    110. 

  110. INSERT INTO `AR_CONFIG` VALUES ('pointsPercent_12', '业绩奖12层比例', '%', 1, NULL, '1', 'bonus', 16, 1521085263, 1594777830);
    111. 

  111. INSERT INTO `AR_CONFIG` VALUES ('pointsPercent_14', '业绩奖14层比例', '%', 1, NULL, '1', 'bonus', 17, 1521085263, 1594777830);
    112. 

  112. INSERT INTO `AR_CONFIG` VALUES ('pointsPercent_16', '业绩奖16层比例', '%', 1, NULL, '1', 'bonus', 18, 1521085263, 1594777830);
    113. 

  113. INSERT INTO `AR_CONFIG` VALUES ('pointsPercent_18', '业绩奖18层比例', '%', 1, NULL, '1', 'bonus', 19, 1521085263, 1594777830);
    114. 

  114. INSERT INTO `AR_CONFIG` VALUES ('pointsPercent_18', '业绩奖18层比例', '%', 1, NULL, '1', 'bonus', 20, 1521085263, 1594777830);
    115. 

  115. INSERT INTO `AR_CONFIG` VALUES ('pointsPercent_20', '业绩奖20层比例', '%', 1, NULL, '1', 'bonus', 21, 1521085263, 1594777830);
    116. 

  116. INSERT INTO `AR_CONFIG` VALUES ('pointsPercent', '业绩奖默认比例', '%', 1, NULL, '1', 'bonus', 10, 1521085263, 1594777830);
    117. 

  117. INSERT INTO `AR_CONFIG` VALUES ('fxRecRecPercent', '复消推广奖-推荐人比例', '%', 1, NULL, '15', 'bonus', 5, 1521085263, 1594777830);
    118. 

  118. INSERT INTO `AR_CONFIG` VALUES ('fxRecSelfPercent', '复消推广奖-自己比例', '%', 1, NULL, '15', 'bonus', 6, 1521085263, 1594777830);
    119. 

  119. COMMIT;
    120. 

  120. 

  121. SET FOREIGN_KEY_CHECKS = 1;
    122.