-- =====================================================
-- Add Pay Mode and Bank Mode to Employees Table (Direct SQL)
-- =====================================================
-- Simple version - Run this directly in phpMyAdmin
-- =====================================================

-- Add pay_mode column (if not exists)
ALTER TABLE `employees` 
ADD COLUMN IF NOT EXISTS `pay_mode` varchar(50) DEFAULT NULL AFTER `bank_ifsc`;

-- Add bank_mode column (if not exists)  
ALTER TABLE `employees`
ADD COLUMN IF NOT EXISTS `bank_mode` varchar(50) DEFAULT 'NEFT' AFTER `pay_mode`;

-- Verify columns
SHOW COLUMNS FROM `employees` LIKE 'pay_mode';
SHOW COLUMNS FROM `employees` LIKE 'bank_mode';

-- Note: If you get "IF NOT EXISTS" error, use the other migration file
-- which uses dynamic SQL to check before adding

