-- Run this if you already have a bookings table but are missing the 'status' column ALTER TABLE `bookings` ADD COLUMN `status` ENUM('confirmed', 'cancelled') DEFAULT 'confirmed' AFTER `amount_paid`;