-- Add housekeeping status to rooms
ALTER TABLE rooms ADD COLUMN housekeeping_status ENUM('clean','dirty','needs_cleaning') NOT NULL DEFAULT 'clean';