-- Add 'cancelled' payment status to registrations table
-- This allows registrations to be marked as cancelled and then deleted

ALTER TABLE `registrations` 
MODIFY COLUMN `payment_status` ENUM('pending','paid','failed','expired','cancelled') DEFAULT 'pending';

-- Update any views or procedures that reference payment_status
-- Note: This will need to be run on the live database
