ngds/sql/update.sql

-- 补充
ALTER TABLE `AR_USER_PERF`
ADD COLUMN `SURPLUS_1L` decimal(16, 2) UNSIGNED NOT NULL DEFAULT 0.00 AFTER `PV_PSS`;
ALTER TABLE `AR_USER_PERF`
ADD COLUMN `SURPLUS_2L` decimal(16, 2) UNSIGNED NOT NULL DEFAULT 0.00 AFTER `SURPLUS_1L`;
ALTER TABLE `AR_USER_PERF`
ADD COLUMN `SURPLUS_3L` decimal(16, 2) UNSIGNED NOT NULL DEFAULT 0.00 AFTER `SURPLUS_2L`;
ALTER TABLE `AR_USER_PERF`
ADD COLUMN `SURPLUS_4L` decimal(16, 2) UNSIGNED NOT NULL DEFAULT 0.00 AFTER `SURPLUS_3L`;
ALTER TABLE `AR_USER_PERF`
ADD COLUMN `SURPLUS_5L` decimal(16, 2) UNSIGNED NOT NULL DEFAULT 0.00 AFTER `SURPLUS_4L`;

-- 2020-04-26
ALTER TABLE `AR_PERF_MONTH` DROP INDEX `LAST_EMP_LV`;
ALTER TABLE `AR_PERF_MONTH` ADD INDEX `CALC_MONTH`(`CALC_MONTH`) USING BTREE;


ALTER TABLE `AR_USER_INFO` DROP INDEX `REG_TYPE`;
ALTER TABLE `AR_USER_INFO` ADD INDEX `REC_UID`(`REC_UID`) USING BTREE;

-- 2020-05-09
ALTER TABLE `AR_USER_TOKEN`
ADD INDEX `USER_ID`(`USER_ID`) USING BTREE;

ALTER TABLE `AR_USER_INFO`
ADD INDEX `CON_UID`(`CON_UID`) USING BTREE;

--2020-05-30
ALTER TABLE `AR_USER`
MODIFY COLUMN `ID` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL FIRST;

-- 2020-06-12
ALTER TABLE `AR_USER_MOVE`
ADD INDEX `USER_ID`(`USER_ID`) USING BTREE;


-- 2020-06-24
ALTER TABLE `AR_USER_PERF`
ADD COLUMN `PV_PSS_TOTAL` decimal(16, 2) UNSIGNED NOT NULL DEFAULT 0.00 AFTER `SURPLUS_5L`;

-- 2020-06-30
ALTER TABLE `AR_CALC_BONUS`
ADD INDEX `CALC_MONTH`(`CALC_MONTH`) USING BTREE;

-- 2020-07-16
UPDATE AR_USER SET EMP_LV='67BE1C6C21F81B32E055736AECE8644D' WHERE EMP_LV<>'67BE1C6C21F81B32E055736AECE8644D';


-- 2020-07-27
ALTER TABLE `AR_CALC_BONUS`
ADD COLUMN `BONUS_REAL` decimal(16, 3) UNSIGNED NOT NULL DEFAULT 0.000 COMMENT '实际奖金' AFTER `PV_TOUCH`;