-- 报工关联设备快照。先执行结构升级，再部署后端；不反推历史设备，不更改设备状态。
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;