feat(pin): pin a post to your own blog
An author has no way to keep a post at the top of their own blog: the timeline is strictly reverse-chronological, so anything worth keeping visible -- an introduction, a rules post, a long-running index -- sinks within a day.
This adds a per-author pin. The pinned post leads the author's Blog timeline, where it is materialized.
The account's Posts and Comments lists stay strictly chronological. They are the archive of what the author published and when, so a pin keeps its own position there: hoisting it would present a post from days ago as the newest thing the author wrote.
Schema: migration v49_to_v50 adds nexus_posts.is_blog_pinned with a partial
index on (author, created_at DESC) WHERE is_blog_pinned = true, so the lookup
touches only pinned rows.
Verified on a full node: the pinned post leads the Blog, and the account's Posts list returns the genuinely newest post first.