BEGIN;

ALTER TABLE dealer_offers ADD COLUMN IF NOT EXISTS customer_visited boolean;
ALTER TABLE dealer_offers ADD COLUMN IF NOT EXISTS vehicle_purchased boolean;
ALTER TABLE dealer_offers ADD COLUMN IF NOT EXISTS outcome_updated_at timestamptz;

CREATE INDEX IF NOT EXISTS dealer_offers_outcome_idx
  ON dealer_offers (vehicle_purchased, customer_visited, outcome_updated_at DESC)
  WHERE status = 'submitted';

COMMIT;