-- Allow bank transfer and flexible payment method strings (mixed payments per invoice).
-- Safe if column is already VARCHAR.

ALTER TABLE payments
  MODIFY COLUMN payment_method VARCHAR(40) NOT NULL DEFAULT 'CASH';