ALTER TABLE attendance
MODIFY status VARCHAR(20)
CHARACTER SET utf8mb4
COLLATE utf8mb4_unicode_ci
NOT NULL
DEFAULT 'present';




ALTER TABLE attendance_summaries
ADD UNIQUE KEY uniq_emp_date (employee_id, summary_date);