ALTER TABLE rekognition_otp_verifications
  ADD COLUMN otp_ref VARCHAR(16) NOT NULL DEFAULT '' AFTER otp_code;