-- 报工关联设备快照。先执行结构升级，再部署后端；不反推历史设备，不更改设备状态。
|
SET @feedback_machinery_sql = IF(
|
EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema=DATABASE()
|
AND table_name='mes_pro_feedback' AND column_name='machinery_ids'),
|
'SELECT 1',
|
'ALTER TABLE mes_pro_feedback ADD COLUMN machinery_ids VARCHAR(2048) NULL COMMENT ''首次提交时关联设备编号快照，逗号分隔；历史记录可为空''');
|
PREPARE feedback_machinery_stmt FROM @feedback_machinery_sql;
|
EXECUTE feedback_machinery_stmt;
|
DEALLOCATE PREPARE feedback_machinery_stmt;
|
