-- 评分相关字段改为整数(去掉 .00) -- 规则表 ALTER TABLE `supplier_score_rule` MODIFY COLUMN `quality_weight` int unsigned NOT NULL DEFAULT 50 COMMENT '上年度质量评分权重(%)', MODIFY COLUMN `price_weight` int unsigned NOT NULL DEFAULT 50 COMMENT '单价评分权重(%)'; -- 服务评分表(总分/单价合计/单价评分值保留小数) ALTER TABLE `supplier_service_score` MODIFY COLUMN `quality_score` int NOT NULL DEFAULT 0 COMMENT '上年度质量评分', MODIFY COLUMN `quality_weight` int unsigned NOT NULL DEFAULT 50 COMMENT '质量百分比', MODIFY COLUMN `price_sum` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT '本单工序单价合计', MODIFY COLUMN `price_weight` int unsigned NOT NULL DEFAULT 50 COMMENT '价格百分比';