-- ============================================================
-- vibration_drive – Migration 005: Add missing columns to vibration_link
-- ============================================================
-- The LinkRepository::create() inserts author_name, reading_time_minutes,
-- and duration_seconds but these columns were never added to the table.

SET NAMES utf8mb4;

ALTER TABLE `vibration_link`
  ADD COLUMN `author_name` VARCHAR(255) NULL DEFAULT NULL AFTER `site_name`,
  ADD COLUMN `reading_time_minutes` INT UNSIGNED NULL DEFAULT NULL AFTER `author_name`,
  ADD COLUMN `duration_seconds` INT UNSIGNED NULL DEFAULT NULL AFTER `reading_time_minutes`;
