-- Add display_name column to users table
-- Allows clinician names like "Dr. Steven Smith" for reports
ALTER TABLE users ADD COLUMN IF NOT EXISTS display_name VARCHAR(255);

-- Seed existing users with their username as default
UPDATE users SET display_name = username WHERE display_name IS NULL;
