-- =============================================
-- M1：盘点结果审批 BPM
-- mes_wm_stock_taking_task 增加 process_instance_id 列
-- 用于回写"盘点结果已提交 BPM 审批"的流程实例编号
-- 目标库：mom-xgdl（local profile）
-- =============================================

-- 1. mes_wm_stock_taking_task.process_instance_id
SET @exists = (SELECT COUNT(*) FROM information_schema.columns
               WHERE table_schema = DATABASE() AND table_name = 'mes_wm_stock_taking_task' AND column_name = 'process_instance_id');
SET @sql = IF(@exists = 0,
              'ALTER TABLE mes_wm_stock_taking_task ADD COLUMN process_instance_id VARCHAR(64) NULL COMMENT ''BPM 流程实例编号（非空表示盘点结果已提交审批）'' AFTER status',
              'SELECT 1');
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;