-- Required before deploying supplier-payment journal synchronization.
ALTER TABLE supplier_payments
  ADD COLUMN journalEntryId INT NULL AFTER creditAccount,
  ADD INDEX idx_supplier_payments_journal_entry (journalEntryId);

-- Legacy links are resolved safely by the application on the next edit. The
-- application links only when one journal matches and no other payment owns it.