-- Migration: Add PAN and Aadhar fields to employees table
-- Date: 2025-01-XX
-- Description: Adds pan_number and aadhar_number columns to employees table for statutory compliance

ALTER TABLE `employees` 
ADD COLUMN IF NOT EXISTS `pan_number` varchar(50) AFTER `uan_number`,
ADD COLUMN IF NOT EXISTS `aadhar_number` varchar(50) AFTER `pan_number`;

