-- Tier 2 Block E — host analytics. -- -- The only schema change for analytics is opt-in source attribution on -- tokens. Counts, funnels, and histograms are all derived from existing -- tables (events / guests / tokens / rsvps / access_logs) via aggregation -- queries with a 60-second Redis cache in front. ALTER TABLE tokens ADD COLUMN IF NOT EXISTS utm_source TEXT;