759f9f27
 “wangming”
123321
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
-- 为个人业绩统计表添加首单业绩和升单业绩字段
ALTER TABLE lq_statistics_personal_performance
ADD COLUMN F_FirstOrderPerformance decimal(18,2) DEFAULT '0.00' COMMENT '首单业绩' AFTER F_UpgradeOrderCount,
ADD COLUMN F_UpgradeOrderPerformance decimal(18,2) DEFAULT '0.00' COMMENT '升单业绩' AFTER F_FirstOrderPerformance;
-- 为门店总业绩统计表添加首单业绩和升单业绩字段
ALTER TABLE lq_statistics_store_total_performance
ADD COLUMN F_FirstOrderPerformance decimal(18,2) DEFAULT '0.00' COMMENT '首单业绩' AFTER F_UpgradeOrderCount,
ADD COLUMN F_UpgradeOrderPerformance decimal(18,2) DEFAULT '0.00' COMMENT '升单业绩' AFTER F_FirstOrderPerformance;
-- 为工资统计表添加首单业绩和升单业绩字段
ALTER TABLE lq_salary_statistics
ADD COLUMN F_FirstOrderPerformance decimal(18,2) DEFAULT '0.00' COMMENT '首单业绩' AFTER F_UpgradePerformance,
ADD COLUMN F_UpgradeOrderPerformance decimal(18,2) DEFAULT '0.00' COMMENT '升单业绩' AFTER F_FirstOrderPerformance;
|
