-- Add employee_category column to employee_transfers table
-- This column stores the category selected in the transfer form

ALTER TABLE `employee_transfers` 
ADD COLUMN IF NOT EXISTS `employee_category` VARCHAR(50) DEFAULT NULL AFTER `employee_id`;

