-- =====================================================================
-- AI Front Desk Platform — Migration 004
--
-- Adds a service address to contacts, per explicit request: the
-- technician needs to know where to go, and there was previously no
-- column to store this at all (bookAppointment could not have collected
-- it even if the AI had asked). Required going forward for new bookings
-- (enforced in BookAppointmentTool's tool schema + system prompt, not
-- at the DB level — existing contacts with no address on file are left
-- alone, NULL is allowed here so historical rows aren't broken).
-- =====================================================================

SET NAMES utf8mb4;

ALTER TABLE contacts
    ADD COLUMN address VARCHAR(255) NULL
        COMMENT 'Service address — where the technician should go. Required for new bookings going forward; NULL allowed for pre-existing contacts.'
        AFTER email;
