-- Update property_type enum to include new real estate property types
-- This adds: land, villa, townhouse, farmland to the existing types

ALTER TABLE `properties` 
MODIFY COLUMN `property_type` 
ENUM(
  'apartment',
  'house',
  'hostel',
  'commercial',
  'land',
  'villa',
  'townhouse',
  'farmland'
) NOT NULL;

-- Note: 
-- apartment - A self-contained residential unit in a building
-- house - A standalone residential dwelling
-- hostel - A hostel facility for short-term accommodations
-- commercial - Business/retail space for commercial purposes
-- land - Raw land without structures (no units to be added)
-- villa - A luxury residential dwelling, usually standalone
-- townhouse - A multi-story residential unit, typically shared walls
-- farmland - Agricultural land for farming purposes (no units)