USE cashless_db;

ALTER TABLE payments
  ADD COLUMN duplicate_reference_detected TINYINT(1) NOT NULL DEFAULT 0,
  ADD COLUMN duplicate_reference_candidate VARCHAR(80) DEFAULT NULL;