-- Cancellation and Ordering Updates
-- Run on database to add cancellation audit logging columns

ALTER TABLE `vbs_bookings`
  ADD COLUMN IF NOT EXISTS `cancelled_at` DATETIME NULL DEFAULT NULL AFTER `is_conformed`,
  ADD COLUMN IF NOT EXISTS `cancelled_by` VARCHAR(100) NULL DEFAULT NULL AFTER `cancelled_at`,
  ADD COLUMN IF NOT EXISTS `cancellation_reason` TEXT NULL DEFAULT NULL AFTER `cancelled_by`;

-- Also add to non-prefixed bookings table if it exists
ALTER TABLE `bookings`
  ADD COLUMN IF NOT EXISTS `cancelled_at` DATETIME NULL DEFAULT NULL,
  ADD COLUMN IF NOT EXISTS `cancelled_by` VARCHAR(100) NULL DEFAULT NULL,
  ADD COLUMN IF NOT EXISTS `cancellation_reason` TEXT NULL DEFAULT NULL;
