-- Step 21: Add sessionItemId column to reservationPreorderItems
-- Links each preorder item to its corresponding sessionItem after activation
-- Allows tracking which session item was created from each preorder item,
-- even if the session item is later moved to a different session.

ALTER TABLE `reservationPreorderItems`
  ADD COLUMN `sessionItemId` int(11) UNSIGNED DEFAULT NULL
  AFTER `kitchenHandled`;
