ALTER TABLE payment_methods ADD COLUMN category ENUM('deposit', 'withdrawal') DEFAULT 'deposit';
-- Update existing methods to be 'deposit' (default handles this, but being explicit is good)
UPDATE payment_methods SET category = 'deposit' WHERE category IS NULL;
