-- Add profile avatar and notification preferences to users.

ALTER TABLE users
  ADD COLUMN IF NOT EXISTS avatar_url TEXT,
  ADD COLUMN IF NOT EXISTS notification_preferences JSONB DEFAULT '{"emailReports": true, "weatherAlerts": true, "applicationReminders": true, "wateringReminders": false}'::jsonb;