Special pages: a gallery page of the blog's images

A page's kind says what it shows between its intro and outro: posts,
as before, or something special. The first special kind is a gallery —
every image in the files library as a masonry wall (CSS columns, no
script), newest first, each linked to its full-size file. The page form
lists the library's images with a Hide tick per picture; exclusions are
stored (page_hidden_files) rather than inclusions so a new upload shows
up without editing the page, and the design's own pictures — logo,
favicon, header and background image — are never shown. Special pages
keep the page chrome (menu, announcements, home, ordering) but hold no
posts: the post forms skip them and a forced page id is refused.

Co-Authored-By: Claude Opus 5 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01Sd8UPWrvyYCLj97JexNw3A

1 files changed, 16 insertions, 0 deletions

diff --git a/internal/db/migrations/blog/00013_page_kind.sql b/internal/db/migrations/blog/00013_page_kind.sql
new file mode 100644
index 0000000..072d53d
--- /dev/null
+++ b/internal/db/migrations/blog/00013_page_kind.sql
@@ -0,0 +1,16 @@
+-- +goose Up
+-- Special pages: a page's kind says what it shows instead of posts. The
+-- first special kind is a gallery of the library's images; the images a
+-- gallery leaves out are rows here, so a deleted file drops out by itself.
+ALTER TABLE pages ADD COLUMN kind text NOT NULL DEFAULT 'posts'
+    CHECK (kind IN ('posts', 'gallery'));
+
+CREATE TABLE page_hidden_files (
+    page_id bigint NOT NULL REFERENCES pages(id) ON DELETE CASCADE,
+    file_id uuid   NOT NULL REFERENCES files(id) ON DELETE CASCADE,
+    PRIMARY KEY (page_id, file_id)
+);
+
+-- +goose Down
+DROP TABLE page_hidden_files;
+ALTER TABLE pages DROP COLUMN kind;