d8035736
 “wangming”
Refactor project ...
|
1
2
3
4
5
6
7
8
9
10
11
12
13
|
-- 在健康师工资表中添加升单人头数、新客业绩提成金额、升单业绩提成金额字段
-- 添加升单人头数字段（放在F_NewCustomerPoint字段后面）
ALTER TABLE `lq_salary_statistics`
ADD COLUMN `F_UpgradeCustomerCount` DECIMAL(18,2) DEFAULT 0.00 COMMENT '升单人头数' AFTER `F_NewCustomerPoint`;
-- 添加新客业绩提成金额字段
ALTER TABLE `lq_salary_statistics`
ADD COLUMN `F_NewCustomerPerformanceCommission` DECIMAL(18,2) DEFAULT 0.00 COMMENT '新客业绩提成金额' AFTER `F_UpgradePoint`;
-- 添加升单业绩提成金额字段
ALTER TABLE `lq_salary_statistics`
ADD COLUMN `F_UpgradePerformanceCommission` DECIMAL(18,2) DEFAULT 0.00 COMMENT '升单业绩提成金额' AFTER `F_NewCustomerPerformanceCommission`;
|
