-- Add id_document_path column to landlord_profiles table
-- This column stores the path to the uploaded ID document for verification

ALTER TABLE `landlord_profiles` 
ADD COLUMN `id_document_path` VARCHAR(255) NULL DEFAULT NULL AFTER `id_verified`;