aboutsummaryrefslogtreecommitdiffstats
path: root/internal/db/migrations/control/00005_per_blog_databases.sql
diff options
context:
space:
mode:
authorgrm <grm@eyesin.space>2026-09-14 00:51:19 +0300
committergrm <grm@eyesin.space>2026-09-14 00:51:19 +0300
commit282d2ab3e0fb3a74f32160a231225773001acd14 (patch)
treeb15c105c0c5d79467d3b815af4c67f5bf4a02d9d /internal/db/migrations/control/00005_per_blog_databases.sql
parent0de17af2318134549fa6f4db822ba6921b35f12f (diff)
downloadblogspace-282d2ab3e0fb3a74f32160a231225773001acd14.tar.gz
blogspace-282d2ab3e0fb3a74f32160a231225773001acd14.tar.bz2
blogspace-282d2ab3e0fb3a74f32160a231225773001acd14.zip
Drop the single-database split and re-baseline the control migrations
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 <noreply@anthropic.com> Claude-Session: https://claude.ai/code/session_01Sd8UPWrvyYCLj97JexNw3A
Diffstat (limited to 'internal/db/migrations/control/00005_per_blog_databases.sql')
-rw-r--r--internal/db/migrations/control/00005_per_blog_databases.sql12
1 files changed, 0 insertions, 12 deletions
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;