-- Adds photo-proof support to task_proofs.
-- proof_text becomes optional (old submissions keep their text);
-- proof_photo stores the relative path under /uploads/proofs/ for new submissions.
ALTER TABLE task_proofs
  MODIFY proof_text TEXT NULL,
  ADD COLUMN proof_photo VARCHAR(255) DEFAULT NULL AFTER proof_text;