| 123456 |
- ALTER TABLE `AR_EMPLOY_LEVEL`
- ADD COLUMN `LEVEL_SCORE` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '级别分数' AFTER `MIN_EMPLOY_NUM`;
- ALTER TABLE `AR_EMPLOY_LEVEL`
- ADD COLUMN `UPGRADE_SCORE` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '升级分数' AFTER `LEVEL_SCORE`;
- INSERT INTO `AR_CONFIG`(`CONFIG_NAME`, `TITLE`, `UNIT`, `INPUT_TYPE`, `OPTIONS`, `VALUE`, `TYPE`, `SORT`, `CREATED_AT`, `UPDATED_AT`) VALUES ('baseScore', '基础分数配置', NULL, 10, NULL, '[{\"sort\":1,\"monthTotalPvMin\":\"10000\",\"monthTotalPvMax\":\"20000\",\"score\":\"5\"},{\"sort\":2,\"monthTotalPvMin\":\"20000\",\"monthTotalPvMax\":\"30000\",\"score\":\"5.5\"},{\"sort\":3,\"monthTotalPvMin\":\"30000\",\"monthTotalPvMax\":\"40000\",\"score\":\"6\"},{\"sort\":4,\"monthTotalPvMin\":\"40000\",\"monthTotalPvMax\":\"50000\",\"score\":\"6.5\"},{\"sort\":5,\"monthTotalPvMin\":\"50000\",\"monthTotalPvMax\":\"60000\",\"score\":\"7.0\"},{\"sort\":6,\"monthTotalPvMin\":\"60000\",\"monthTotalPvMax\":\"70000\",\"score\":\"7.5\"},{\"sort\":7,\"monthTotalPvMin\":\"70000\",\"monthTotalPvMax\":\"0\",\"score\":\"8\"}]', 'score', 1, 1521085263, 1602819452);
|
