-- Migration: Add address field to tenant_profiles table
-- Date: 2024
-- Description: Adds address field to store tenant's current address

-- Add address column to tenant_profiles table
ALTER TABLE `tenant_profiles` 
ADD COLUMN `address` TEXT DEFAULT NULL AFTER `emergency_contact_relationship`;

-- Note: The users table already has profile_image column, no changes needed there
-- Verify with: DESCRIBE users;
-- Expected: profile_image varchar(255) DEFAULT NULL

-- Update existing tenant scores to include address field (optional)
-- This will recalculate scores for existing profiles
-- Address field will add 10 points to the tenant score when filled