ALTER TABLE handoff_logs
ADD COLUMN manager_verified_at TIMESTAMP NULL DEFAULT NULL AFTER accepted_by_id,
ADD COLUMN manager_verified_by INT NULL DEFAULT NULL AFTER manager_verified_at,
ADD COLUMN manager_notes TEXT NULL AFTER manager_verified_by;

ALTER TABLE handoff_logs
ADD CONSTRAINT fk_manager_verified_by FOREIGN KEY (manager_verified_by) REFERENCES users(id) ON DELETE SET NULL;
