-- =========================================================
-- 049_spk_department_progress_photo.sql
-- Sprint: Landing SPK - Foto progres departemen
--
-- Adds optional progress photo fields per department progress row.
-- Uploaded files are stored as compressed WebP assets.
-- =========================================================

ALTER TABLE spk_department_progress
  ADD COLUMN photo_path VARCHAR(255) NULL AFTER finished_at,
  ADD COLUMN photo_uploaded_at DATETIME NULL AFTER photo_path,
  ADD COLUMN photo_uploaded_by_name_snapshot VARCHAR(120) NULL AFTER photo_uploaded_at;