-- Adds the missing officer email destinations used by the public contact form.
ALTER TABLE lodge_settings
  ADD COLUMN director_of_ceremonies_email VARCHAR(254) NULL AFTER dining_steward_email,
  ADD COLUMN almoner_email VARCHAR(254) NULL AFTER director_of_ceremonies_email;