ALTER TABLE courses ADD COLUMN IF NOT EXISTS include_in_physical_hole_total BOOLEAN NOT NULL DEFAULT TRUE; UPDATE courses SET include_in_physical_hole_total = TRUE WHERE include_in_physical_hole_total IS NULL;