-- Run once to add payment_status to purchases (Paid, Partial, Due).
USE cmr_ecommerce;
ALTER TABLE purchases ADD COLUMN payment_status ENUM('PAID','PARTIAL','DUE') NOT NULL DEFAULT 'DUE' AFTER status;