-- =========================================================
-- 105_spk_progress_photo.sql
-- Sprint: Landing SPK - Foto progres level SPK
--
-- Adds optional progress photo fields directly on SPK rows for
-- tenants that run production without department workflow.
-- =========================================================

ALTER TABLE spk
  ADD COLUMN progress_photo_path VARCHAR(255) NULL AFTER pickup_proof_uploaded_by_name_snapshot,
  ADD COLUMN progress_photo_uploaded_at DATETIME NULL AFTER progress_photo_path,
  ADD COLUMN progress_photo_uploaded_by_name_snapshot VARCHAR(120) NULL AFTER progress_photo_uploaded_at;