antissoft / lvqianmeiye_ERP

add_first_upgrade_performance_fields.sql 1.01 KB
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;