-- =============================================
|
-- 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;
|
