-- Migration: Add color column to bookings table
-- Run this on existing database to add color support

ALTER TABLE `bookings` ADD COLUMN `color` varchar(7) DEFAULT '#7dd3fc' AFTER `notes`;

-- Optional: Set different colors for existing bookings based on status
-- UPDATE bookings SET color = '#22c55e' WHERE status = 'confirmed';
-- UPDATE bookings SET color = '#ef4444' WHERE status = 'cancelled';