-- Add 'due' to payment_status ENUM for sales table
ALTER TABLE `sales` MODIFY COLUMN `payment_status` ENUM('paid','partial','credit','due') DEFAULT 'paid';

-- Add 'due' to payment_status ENUM for purchases table
ALTER TABLE `purchases` MODIFY COLUMN `payment_status` ENUM('paid','partial','credit','due') DEFAULT 'paid';
