From 282d2ab3e0fb3a74f32160a231225773001acd14 Mon Sep 17 00:00:00 2001 From: grm Date: Mon, 14 Sep 2026 00:51:19 +0300 Subject: Drop the single-database split and re-baseline the control migrations MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Every deployment has been through the per-blog split, so the code that performed it (split.go, control migrations 00002–00007) is dead weight, and a fresh install replaying six migrations only to drop the tables again was silly. The control chain is now a single 00001_init.sql with the final users and blogs shape, matching the blog chain. Goose ignores versions recorded in the database that no longer exist in the source, but refuses a future migration numbered below the database's highest version. Databases that went through the split therefore need `DELETE FROM goose_db_version WHERE version_id > 1` once; README and AGENTS.md say so. Co-Authored-By: Claude Opus 5 Claude-Session: https://claude.ai/code/session_01Sd8UPWrvyYCLj97JexNw3A --- internal/db/migrations/control/00005_per_blog_databases.sql | 12 ------------ 1 file changed, 12 deletions(-) delete mode 100644 internal/db/migrations/control/00005_per_blog_databases.sql (limited to 'internal/db/migrations/control/00005_per_blog_databases.sql') diff --git a/internal/db/migrations/control/00005_per_blog_databases.sql b/internal/db/migrations/control/00005_per_blog_databases.sql deleted file mode 100644 index 92d3fa2..0000000 --- a/internal/db/migrations/control/00005_per_blog_databases.sql +++ /dev/null @@ -1,12 +0,0 @@ --- +goose Up --- Each blog gets its own database; the registry remembers which one. --- db_name stays nullable until the Go migration 00006 has moved the content. -ALTER TABLE blogs ADD COLUMN db_name text UNIQUE; --- "blog_" + subdomain must fit in a 63-char Postgres identifier. -ALTER TABLE blogs DROP CONSTRAINT blogs_subdomain_check; -ALTER TABLE blogs ADD CONSTRAINT blogs_subdomain_check CHECK (subdomain ~ '^[a-z0-9](-?[a-z0-9]){0,57}$'); - --- +goose Down -ALTER TABLE blogs DROP CONSTRAINT blogs_subdomain_check; -ALTER TABLE blogs ADD CONSTRAINT blogs_subdomain_check CHECK (subdomain ~ '^[a-z0-9](-?[a-z0-9]){0,62}$'); -ALTER TABLE blogs DROP COLUMN db_name; -- cgit v1.2.3