ALTER TABLE payroll_absences
  MODIFY type ENUM('vacation','sickness','accident','unpaid','maternity','paternity','military','care','training','remote','other') NOT NULL DEFAULT 'vacation';

ALTER TABLE payroll_absences
  ADD COLUMN half_day ENUM('full','morning','afternoon') NOT NULL DEFAULT 'full' AFTER hours,
  ADD COLUMN certificate_required TINYINT(1) NOT NULL DEFAULT 0 AFTER status,
  ADD COLUMN certificate_received TINYINT(1) NOT NULL DEFAULT 0 AFTER certificate_required,
  ADD COLUMN replacement_user_id INT UNSIGNED NULL AFTER certificate_received,
  ADD COLUMN decision_note TEXT NULL AFTER note,
  ADD COLUMN created_by INT UNSIGNED NULL AFTER decision_note;
