opencode database guide
Database
- Schema: Drizzle schema lives in
src/**/*.sql.ts.
- Naming: tables and columns use snake*case; join columns are
<entity>_id; indexes are <table>*<column>\_idx.
- Migrations: generated by Drizzle Kit using
drizzle.config.ts (schema: ./src/**/*.sql.ts, output: ./migration).
- Command:
bun run db generate --name <slug>.
- Output: creates
migration/<timestamp>_<slug>/migration.sql and snapshot.json.
- Tests: migration tests should read the per-folder layout (no
_journal.json).
