-- Adds exact farm coordinates (entered by hand in Settings), powering the
-- Dashboard's live temperature/humidity pulled client-side from Open-Meteo's
-- free API. NULL until a farm sets them — the weather pill just doesn't show.
ALTER TABLE farms
  ADD COLUMN latitude  DECIMAL(9,6) NULL AFTER timezone,
  ADD COLUMN longitude DECIMAL(9,6) NULL AFTER latitude;