-- Migration script to add accommodation fields to existing inquiries table
-- Run this in phpMyAdmin if your database already exists

-- Add accommodationSharing column
ALTER TABLE `inquiries` 
ADD COLUMN IF NOT EXISTS `accommodationSharing` VARCHAR(50) DEFAULT '' AFTER `budget`;

-- Add propertyType column
ALTER TABLE `inquiries` 
ADD COLUMN IF NOT EXISTS `propertyType` VARCHAR(100) DEFAULT '' AFTER `accommodationSharing`;

-- Verify columns were added
SELECT COLUMN_NAME, DATA_TYPE, COLUMN_DEFAULT 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_NAME = 'inquiries' 
  AND TABLE_SCHEMA = DATABASE()
  AND COLUMN_NAME IN ('accommodationSharing', 'propertyType');