-- Update payment_mode ENUM in sales table to include 'credit'
ALTER TABLE `sales` 
MODIFY COLUMN `payment_mode` enum('cash','card','upi','bank_transfer','credit') 
CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'cash';

-- Update payment_mode ENUM in payments table to include 'credit'
ALTER TABLE `payments` 
MODIFY COLUMN `payment_mode` enum('cash','card','upi','bank_transfer','cheque','credit') 
CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'cash';