max / makenotwork
| 1 | -- Operator-controlled flag marking a changelog post as landing-page-worthy. |
| 2 | -- |
| 3 | -- The landing page surfaces a single "Last shipped" velocity line drawn from |
| 4 | -- the most recent *published* blog post that (a) has this flag set and (b) |
| 5 | -- belongs to the project whose slug is CHANGELOG_PROJECT_SLUG. Not every |
| 6 | -- changelog entry warrants landing-page weight, so the operator opts a post in |
| 7 | -- explicitly via the "Show on landing" checkbox in the blog editor. |
| 8 | -- |
| 9 | -- The column lives on every blog_posts row (any project's editor can set it), |
| 10 | -- but the landing reader filters by the changelog project slug, so the flag is |
| 11 | -- inert on non-changelog projects. Defaults FALSE: existing posts stay off the |
| 12 | -- landing page until deliberately flagged. |
| 13 | blog_posts |
| 14 | ADD COLUMN IF NOT EXISTS show_on_landing BOOLEAN NOT NULL DEFAULT FALSE; |
| 15 |