CREATE TABLE youtube_subscribe_clicks (
    id INT AUTO_INCREMENT PRIMARY KEY,
    click_timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    ip_address VARCHAR(45),
    user_agent TEXT,
    referrer_url TEXT,
    session_id VARCHAR(255),
    INDEX idx_timestamp (click_timestamp),
    INDEX idx_session (session_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;