ngds/sql/2021_04/bonus_two/update.sql

UPDATE AR_CONFIG SET CONFIG_NAME='monthPcsPvFxCondition',TITLE='每月个人复消PV条件',UNIT=null,SORT=58 WHERE CONFIG_NAME='vipBonusCashFxAmountCondition' LIMIT 1;
INSERT INTO `AR_CONFIG`(`CONFIG_NAME`, `TITLE`, `UNIT`, `INPUT_TYPE`, `OPTIONS`, `VALUE`, `TYPE`, `SORT`, `CREATED_AT`, `UPDATED_AT`) VALUES ('vipBonusGoldDecLevel', '金钻会员是否能得vip奖', NULL, 8, NULL, '1', 'bonus', 42, 1521085263, 1612333477);
-- UPDATE AR_CONFIG SET TITLE='共享奖上2代来源',OPTIONS='[{"label":"推广奖","value":"TG"},{"label":"首单业绩奖","value":"YJ"},{"label":"首单团队奖","value":"QY"}]',`VALUE`='QY' WHERE CONFIG_NAME='shareRecIncomeFrom' LIMIT 1;
DELETE FROM AR_CONFIG WHERE CONFIG_NAME='shareRecIncomeFrom' LIMIT 1;
UPDATE AR_CONFIG SET TITLE='共享奖上2代比例' WHERE CONFIG_NAME='shareRecPercent' LIMIT 1;
-- UPDATE AR_CONFIG SET TITLE='共享奖下5层来源',OPTIONS='[{"label":"推广奖","value":"TG"},{"label":"首单业绩奖","value":"YJ"},{"label":"首单团队奖","value":"QY"}]',`VALUE`='QY' WHERE CONFIG_NAME='shareIncomeFrom' LIMIT 1;
DELETE FROM AR_CONFIG WHERE CONFIG_NAME='shareIncomeFrom' LIMIT 1;
UPDATE AR_CONFIG SET TITLE='共享奖下5层比例',`VALUE`='5' WHERE CONFIG_NAME='sharePercent' LIMIT 1;
DELETE FROM AR_CONFIG WHERE CONFIG_NAME='shareRegPerson' LIMIT 1;
DELETE FROM AR_CONFIG WHERE CONFIG_NAME='parentOddPercent_3' LIMIT 1;

DELETE FROM AR_CONFIG WHERE CONFIG_NAME='parentOddIncomeFrom_0' LIMIT 1;
DELETE FROM AR_CONFIG WHERE CONFIG_NAME='parentOddIncomeFrom_1' LIMIT 1;
DELETE FROM AR_CONFIG WHERE CONFIG_NAME='parentOddIncomeFrom_2' LIMIT 1;
DELETE FROM AR_CONFIG WHERE CONFIG_NAME='parentOddIncomeFrom_3' LIMIT 1;

DELETE FROM AR_CONFIG WHERE CONFIG_NAME='fxOpenGL' LIMIT 1;
DELETE FROM AR_CONFIG WHERE CONFIG_NAME='fxParentOddIncomeFrom_0' LIMIT 1;
DELETE FROM AR_CONFIG WHERE CONFIG_NAME='fxParentOddIncomeFrom_1' LIMIT 1;
DELETE FROM AR_CONFIG WHERE CONFIG_NAME='fxParentOddIncomeFrom_2' LIMIT 1;
DELETE FROM AR_CONFIG WHERE CONFIG_NAME='fxParentOddIncomeFrom_3' LIMIT 1;
DELETE FROM AR_CONFIG WHERE CONFIG_NAME='fxParentOddPercent_0' LIMIT 1;
DELETE FROM AR_CONFIG WHERE CONFIG_NAME='fxParentOddPercent_1' LIMIT 1;
DELETE FROM AR_CONFIG WHERE CONFIG_NAME='fxParentOddPercent_2' LIMIT 1;
DELETE FROM AR_CONFIG WHERE CONFIG_NAME='fxParentOddPercent_3' LIMIT 1;


ALTER TABLE `AR_PERF_MONTH`
ADD COLUMN `PV_PCS_FX` decimal(16, 3) NOT NULL DEFAULT 0.000 COMMENT '个人复消业绩' AFTER `PV_PCS`;

ALTER TABLE `AR_CALC_BONUS`
ADD COLUMN `REAL_BONUS_GX` decimal(16, 3) NOT NULL DEFAULT 0.000 COMMENT '实发共享奖' AFTER `ORI_BONUS_GX`;
ALTER TABLE `AR_CALC_BONUS`
ADD COLUMN `REAL_BONUS_GL` decimal(16, 3) NOT NULL DEFAULT 0.000 COMMENT '实发管理奖' AFTER `ORI_BONUS_GL`;