-- Completes the SEO content block on `media_description`. The describe
-- pipeline already produces a `meta_title`; it also emits a `meta_description`
-- (the <meta name="description"> companion) which had no column yet and was
-- silently dropped on ingest.
--
-- Nullable, like `meta_title`: the AI worker may omit it, and a media can live
-- without an SEO meta-description. Sized at 500 to comfortably hold the
-- ~160-320 char range search engines render without truncating mid-sentence.

ALTER TABLE `media_description`
    ADD COLUMN `meta_description` VARCHAR(500) NULL DEFAULT NULL AFTER `meta_title`;
