-- Moves public payment details into Lodge Settings.
ALTER TABLE lodge_settings
  ADD COLUMN IF NOT EXISTS bank_account_name VARCHAR(150) NULL AFTER retention_meetings,
  ADD COLUMN IF NOT EXISTS bank_sort_code VARCHAR(20) NULL AFTER bank_account_name,
  ADD COLUMN IF NOT EXISTS bank_account_number VARCHAR(40) NULL AFTER bank_sort_code;