SPB Git

spb/rareindex

Public
863 B · 12 lines markdown
1# Pending schema changes (to be folded into the next generated migration)23Applied locally with `drizzle-kit push`; regenerate one migration at integration with `pnpm db:generate`.45## packages/database/src/schema/ingestion.ts — `normalized_records`6- **added** `seq integer not null default 0` — position of the record within `normalize(raw)` output (one raw row commonly yields a catalog item + several price observations).7- **changed** unique index `normalized_records_raw_uq`: `(raw_record_id)` → `(raw_record_id, kind, seq)`.89## Notes10- No other table/column changes were needed by the pipeline; the `assets_title_trgm` GIN index declared in the schema was missing from the local DB and got created by the push (it is already in migration 0000).11- pg-boss creates and manages its own schema `pgboss` at worker start (not part of Drizzle migrations).12
Files · 8fd03303eebf7df7e6b85f13b512e86dd3eab467
Menu

Theme