-- Update existing LEAVE or HOLIDAY status values to HALF_DAY
UPDATE `attendances` SET `status` = 'HALF_DAY' WHERE `status` IN ('LEAVE', 'HOLIDAY');

-- AlterTable
ALTER TABLE `attendances` MODIFY COLUMN `status` ENUM('PRESENT', 'ABSENT', 'HALF_DAY') NOT NULL DEFAULT 'PRESENT';