-- Insurance / TPA details captured at the kiosk (card image is never stored)
ALTER TABLE registrations
  ADD COLUMN ins_source ENUM('none','ocr','manual') NOT NULL DEFAULT 'none' AFTER pay_status,
  ADD COLUMN ins_insurer VARCHAR(120) NULL AFTER ins_source,
  ADD COLUMN ins_tpa VARCHAR(120) NULL AFTER ins_insurer,
  ADD COLUMN ins_policy_enc TEXT NULL AFTER ins_tpa,
  ADD COLUMN ins_member_enc TEXT NULL AFTER ins_policy_enc,
  ADD COLUMN ins_valid_till DATE NULL AFTER ins_member_enc;