-- ============================================================
-- G006 Guest & Invitation Engine — Database Migration
-- ============================================================
--
-- This migration adds the `honorific` column to the `guests` table.
-- It uses the native IF NOT EXISTS check which is fully supported
-- by MariaDB (XAMPP default).
--
-- @ref G006
-- ============================================================

ALTER TABLE `guests` 
    ADD COLUMN IF NOT EXISTS `honorific` VARCHAR(50) NULL DEFAULT NULL AFTER `full_name` 
    COMMENT 'Guest title/salutation (Mr., Mrs., Family of, etc.)';