-- Release 066: additive Unit contact fields. Existing branding values remain untouched.
ALTER TABLE unit_lodge_details
  ADD COLUMN IF NOT EXISTS secretary_contact_name VARCHAR(150) NULL AFTER provincial_secretary_email,
  ADD COLUMN IF NOT EXISTS secretary_contact_email VARCHAR(254) NULL AFTER secretary_contact_name,
  ADD COLUMN IF NOT EXISTS secretary_contact_phone VARCHAR(50) NULL AFTER secretary_contact_email,
  ADD COLUMN IF NOT EXISTS postal_address TEXT NULL AFTER secretary_contact_phone;