3.VIS 4

spc以及VIS暂没有重新计算缺陷数量功能
4.4.1汇总功能未合并，任务详情页Fusion数量与历史任务缺陷总数不匹配，合并后即正确，应已历史任务数量为准
http://192.168.10.205/
SPC_VIS_V1_1.2 Revison
机台测试需在数据库中执行此sql，iris机台已执行
-- 仅当列不存在时新增
SET @sql := (
SELECT IF(
(SELECT COUNT FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = DATABASE
AND TABLE_NAME = 'substrate_task'
AND COLUMN_NAME = 'total_defect_num') = 0,
'ALTER TABLE `substrate_task` ADD COLUMN `total_defect_num` INT NULL DEFAULT NULL',
'SELECT ''column already exists'' AS msg'
)
);

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;