ALTER TABLE `attendance_logs`
ADD COLUMN `status` VARCHAR(20) NOT NULL DEFAULT 'on_time' COMMENT 'e.g., on_time, late, leave' AFTER `clock_out`,
ADD COLUMN `work_schedule_id` INT(11) NULL DEFAULT NULL COMMENT 'FK to work_schedule_templates' AFTER `status`;
