-- The printed journal is dated, not quartered.
--
-- Every issue since Vol 10 carries a publication date — "15 July, 2020",
-- "15 जुलाई, 2020" — in its running head, sidebar, title page and contents. The
-- magazines table only had a free-text "quarter" ("Q4 2026"), which is the wrong
-- concept for a half-yearly journal and could not be rendered the way the print
-- edition renders it. quarter stays, nullable, so existing rows keep displaying.
ALTER TABLE magazines
    ADD COLUMN publication_date DATE,

    -- The real cover is commissioned artwork, which no generator can produce.
    -- When the editor uploads it, it becomes page one and the typographic title
    -- page follows it, exactly as in the printed issue.
    ADD COLUMN cover_image_key VARCHAR(500);