-- Keep legacy venue_address for old event records and exports. New structured
-- fields are additive so no address text is guessed or discarded.
ALTER TABLE meetings
  ADD COLUMN IF NOT EXISTS venue_address_line_1 VARCHAR(200) NULL AFTER venue_address,
  ADD COLUMN IF NOT EXISTS venue_address_line_2 VARCHAR(200) NULL AFTER venue_address_line_1,
  ADD COLUMN IF NOT EXISTS venue_address_line_3 VARCHAR(200) NULL AFTER venue_address_line_2,
  ADD COLUMN IF NOT EXISTS venue_town_city VARCHAR(120) NULL AFTER venue_address_line_3,
  ADD COLUMN IF NOT EXISTS venue_county VARCHAR(120) NULL AFTER venue_town_city,
  ADD COLUMN IF NOT EXISTS venue_postcode VARCHAR(24) NULL AFTER venue_county;