-- Add chassis number, engine number, vehicle photo, and multiple part photos to inquiries table
-- This migration adds support for vehicle identification and multiple photo uploads

-- Add chassis number field
ALTER TABLE `inquiries` 
ADD COLUMN `chassisNumber` VARCHAR(100) NULL COMMENT 'Vehicle chassis/VIN number' AFTER `vehicleYear`;

-- Add engine number field
ALTER TABLE `inquiries` 
ADD COLUMN `engineNumber` VARCHAR(100) NULL COMMENT 'Vehicle engine number' AFTER `chassisNumber`;

-- Add vehicle photo field
ALTER TABLE `inquiries` 
ADD COLUMN `vehiclePhoto` VARCHAR(500) NULL COMMENT 'Vehicle photo path' AFTER `partPhoto`;

-- Add part photos field (JSON array to store multiple part photos)
ALTER TABLE `inquiries` 
ADD COLUMN `partPhotos` JSON NULL COMMENT 'Array of part photo paths' AFTER `vehiclePhoto`;

-- Note: The existing `partPhoto` field is kept for backward compatibility
-- New inquiries can use `partPhotos` array, and `partPhoto` can store the first photo