-- =====================================================
-- Migration 004: Add links field to events
-- =====================================================
-- Description: Add support for multiple web links in events (screening rooms, etc.)
-- Author: MediaTrack Team
-- Date: 2025-01-12
-- =====================================================

-- Add links column to LogAggiornamenti table
-- Stores JSON array of URLs: ["https://link1.com", "https://link2.com"]
ALTER TABLE LogAggiornamenti ADD COLUMN links TEXT;

-- Notes:
-- - NULL = no links
-- - Empty array [] = explicitly no links (optional use)
-- - Links are displayed in event timeline similar to file attachments
-- - URLs are normalized on backend (auto-add https:// if missing)