-- Migration: Add 'tugas_luar' status to attendance system
-- Date: 2026-02-18
-- Description: Expand status options from 3 to 4 statuses

-- Step 1: Modify the status column to include 'tugas_luar'
ALTER TABLE `attendance` 
MODIFY COLUMN `status` ENUM('present', 'absent', 'cuti', 'tugas_luar') NOT NULL DEFAULT 'present';

-- Step 2: Verify the change
SELECT COLUMN_TYPE 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_NAME = 'attendance' 
AND COLUMN_NAME = 'status';

-- Expected result: enum('present','absent','cuti','tugas_luar')

-- Note: Existing data will remain unchanged
-- Only new status option 'tugas_luar' is added
