-- Add sort_order column to property_types table
ALTER TABLE property_types ADD COLUMN sort_order INT DEFAULT 0;

-- Create index on sort_order
CREATE INDEX idx_sort_order ON property_types(sort_order);

-- Verify the column was added
SHOW COLUMNS FROM property_types LIKE 'sort_order';