-- Adds an Order-specific Masonic Rank list for the Bro salutation and stores
-- the selected value for attendees and guests.

ALTER TABLE order_rank_settings
  ADD COLUMN masonic_ranks TEXT NULL AFTER salutation_rank_links;

ALTER TABLE bookings
  ADD COLUMN masonic_rank VARCHAR(150) NULL AFTER lodge_number;

ALTER TABLE guests
  ADD COLUMN masonic_rank VARCHAR(150) NULL AFTER surname;