-- Add account_category to bank_transactions for tracking BCH, KMH, etc.
ALTER TABLE bank_transactions
ADD COLUMN account_category ENUM('bch', 'kmh', 'installment_loan', 'credit_card') DEFAULT NULL
AFTER bank_id;

-- Add index for better performance
ALTER TABLE bank_transactions
ADD INDEX idx_account_category (account_category);
