-- =========================================================
-- 104_spk_pickup_proof.sql
-- Sprint: Landing SPK - Bukti pickup
--
-- Adds optional pickup proof fields on SPK handover flow.
-- Uploaded files reuse the existing SPK landing upload storage.
-- =========================================================

ALTER TABLE spk
  ADD COLUMN pickup_proof_path VARCHAR(255) NULL AFTER jam_serah,
  ADD COLUMN pickup_proof_uploaded_at DATETIME NULL AFTER pickup_proof_path,
  ADD COLUMN pickup_proof_uploaded_by_name_snapshot VARCHAR(120) NULL AFTER pickup_proof_uploaded_at;