-- Phase 2 migration. Run ONLY if you imported the Phase 1 schema.sql before this change.
-- (A rejected reference must be re-submittable, so uniqueness is enforced in code for pending/approved only.)
ALTER TABLE payment_submissions DROP INDEX uq_payment_reference, ADD INDEX idx_payment_reference (reference);

INSERT IGNORE INTO settings (`key`, `value`) VALUES
  ('payment_methods', 'Mobile Money,Bank Transfer'),
  ('support_contact', '');