-- Fix Critical Errors from Error Log
-- Add receiptCode column to stripePayments table

-- The stripePayments table is missing the receiptCode column
-- that the dine-in app stripe handlers expect

ALTER TABLE `stripePayments`
ADD COLUMN `receiptCode` VARCHAR(50) DEFAULT NULL AFTER `status`;

-- Note: Issue 1 from the original migration (onlineOrderItemOptions foreign key)
-- was already fixed in the production schema. The column is already named 
-- `onlineOrderItemId` and correctly references `onlineOrderItems(id)`.
