-- 按实际业务维护排产优先级;数字越大越先排,历史工单保持 0。 SET @has_schedule_priority := (SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='mes_pro_work_order' AND COLUMN_NAME='schedule_priority'); SET @priority_sql := IF(@has_schedule_priority=0, 'ALTER TABLE mes_pro_work_order ADD COLUMN schedule_priority INT NOT NULL DEFAULT 0 COMMENT ''排产优先级,数字越大越优先''', 'SELECT 1'); PREPARE priority_stmt FROM @priority_sql; EXECUTE priority_stmt; DEALLOCATE PREPARE priority_stmt;