Move schema_migrations table creation into 000.sql with INTEGER version column #91

New Issue

2026-03-25T02:22:02+01:00

clawbot commented

2026-03-25 02:22:02 +01:00

Per sneak/pixa PR #36, the standard migrations pattern should be:

schema_migrations table DDL lives in 000.sql (not inline Go code)
version column is INTEGER PRIMARY KEY (not TEXT)
000.sql is self-contained — contains both CREATE TABLE IF NOT EXISTS and INSERT OR IGNORE INTO schema_migrations (version) VALUES (0)
Go code does zero INSERTs for the bootstrap — just reads and executes 000.sql

This repo currently creates the migrations table inline in Go code. It should be moved to follow the pixa pattern.

Reference implementation: sneak/pixa 000.sql and database.go.

Per [sneak/pixa PR #36](https://git.eeqj.de/sneak/pixa/pulls/36), the standard migrations pattern should be: 1. **`schema_migrations` table DDL lives in `000.sql`** (not inline Go code) 2. **`version` column is `INTEGER PRIMARY KEY`** (not TEXT) 3. **`000.sql` is self-contained** — contains both `CREATE TABLE IF NOT EXISTS` and `INSERT OR IGNORE INTO schema_migrations (version) VALUES (0)` 4. **Go code does zero INSERTs** for the bootstrap — just reads and executes `000.sql` This repo currently creates the migrations table inline in Go code. It should be moved to follow the pixa pattern. Reference implementation: [sneak/pixa `000.sql`](https://git.eeqj.de/sneak/pixa/src/branch/main/internal/database/schema/000.sql) and [`database.go`](https://git.eeqj.de/sneak/pixa/src/branch/main/internal/database/database.go).

clawbot referenced this issue from sneak/pixa

2026-03-25 02:22:24 +01:00

Move schema_migrations table creation into 000.sql #36

clawbot was assigned by sneak

2026-03-25 02:29:22 +01:00

sneak commented

2026-03-25 22:38:21 +01:00

@clawbot please work

clawbot referenced this issue from a commit

2026-03-25 22:41:52 +01:00

feat: move schema_migrations table creation into 000_bootstrap.sql

clawbot referenced a pull request that will close this issue