-- ============================================================
-- migration_payment_fields.sql
-- Run this once on your live DB to add extra payment columns
-- ============================================================

ALTER TABLE payment_proofs
  ADD COLUMN IF NOT EXISTS sender_id     VARCHAR(255) DEFAULT NULL COMMENT 'Zelle email/phone or Revolut @revtag',
  ADD COLUMN IF NOT EXISTS payment_notes TEXT         DEFAULT NULL;

ALTER TABLE orders
  ADD COLUMN IF NOT EXISTS payment_sender VARCHAR(255) DEFAULT NULL COMMENT 'Sender identifier per payment method';