-- Add default_duration_minutes column to doctors table
ALTER TABLE doctors ADD COLUMN IF NOT EXISTS default_duration_minutes INTEGER DEFAULT 30 CHECK (default_duration_minutes > 0 AND default_duration_minutes <= 120);

-- Update existing doctors to have default duration of 30 minutes
UPDATE doctors SET default_duration_minutes = 30 WHERE default_duration_minutes IS NULL;

