-- ============================================================
-- G012 Couple Dashboard & Analytics Engine — Database Migration
-- ============================================================
-- Adds `view_count` column to the `guests` table to track invitation opens.
-- @ref G012
-- ============================================================

ALTER TABLE `guests` 
    ADD COLUMN IF NOT EXISTS `view_count` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Total times invitation URL was opened' AFTER `last_opened_at`;