-- Add photo_path column to lokasi for storing uploaded house photos
ALTER TABLE lokasi
  ADD COLUMN photo_path VARCHAR(255) NULL AFTER assistance_notes;