-- Migration: 019_residence_home_profile
-- Add home profile fields to residence for smart onboarding task suggestions

ALTER TABLE residence_residence
  ADD COLUMN IF NOT EXISTS heating_type VARCHAR(50),
  ADD COLUMN IF NOT EXISTS cooling_type VARCHAR(50),
  ADD COLUMN IF NOT EXISTS water_heater_type VARCHAR(50),
  ADD COLUMN IF NOT EXISTS roof_type VARCHAR(50),
  ADD COLUMN IF NOT EXISTS has_pool BOOLEAN DEFAULT FALSE,
  ADD COLUMN IF NOT EXISTS has_sprinkler_system BOOLEAN DEFAULT FALSE,
  ADD COLUMN IF NOT EXISTS has_septic BOOLEAN DEFAULT FALSE,
  ADD COLUMN IF NOT EXISTS has_fireplace BOOLEAN DEFAULT FALSE,
  ADD COLUMN IF NOT EXISTS has_garage BOOLEAN DEFAULT FALSE,
  ADD COLUMN IF NOT EXISTS has_basement BOOLEAN DEFAULT FALSE,
  ADD COLUMN IF NOT EXISTS has_attic BOOLEAN DEFAULT FALSE,
  ADD COLUMN IF NOT EXISTS exterior_type VARCHAR(50),
  ADD COLUMN IF NOT EXISTS flooring_primary VARCHAR(50),
  ADD COLUMN IF NOT EXISTS landscaping_type VARCHAR(50);