-- Add 3 extra side-photo columns to survey_structures (side 1 = existing structure_photo)
ALTER TABLE survey_structures
    ADD COLUMN structure_photo_2 VARCHAR(255) NOT NULL DEFAULT '' AFTER structure_photo,
    ADD COLUMN structure_photo_3 VARCHAR(255) NOT NULL DEFAULT '' AFTER structure_photo_2,
    ADD COLUMN structure_photo_4 VARCHAR(255) NOT NULL DEFAULT '' AFTER structure_photo_3;