-- Step 36: Priority Queue Lock + Optimizer Upgrade
--
-- Adds a lock column so managers can pin items in priority/normal queue,
-- preventing the cron optimizer from moving them.
--
-- NULL = unlocked (optimizer can change)
-- 'manager' = locked by manager app user

ALTER TABLE `menuItems`
  ADD COLUMN `priorityQueueLockedBy` VARCHAR(20) DEFAULT NULL AFTER `priorityQueue`;