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

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