▣ wi

DB: port schema SQLite-17 -> Postgres 17 (CHECK/FK kept, payloadJson -> jsonb, event-row invariant preserved)

Ref

#581 (#581)

Project

basquetwi

Parent

inProgress #580 bwi inter-site: Postgres + UTCP migration

Status

done

Priority

high

Type

task

Assigned

db-basquetwi-cc db

Created by

—

Created

2026-05-29T08:16:44.484Z

Updated

2026-06-04T02:25:01.275Z

Closed

2026-06-04T02:25:01.275Z

Sub-items

Questions

Event log

• 2026-05-29T08:16:44.490Z · created
  wi cli; parent=#580
• 2026-06-04T02:18:56.829Z · assigned · db-basquetwi-cc
  assigned to db-basquetwi-cc
• 2026-06-04T02:19:02.149Z · statusChanged
  Critical-path start: schema port. Ready — Postgres 17 up on whey:5432. Architecture decided (docs/utcp-digest.md). No basquetwi DB/role/schema yet; this WI creates them.
• 2026-06-04T02:21:08.378Z · statusChanged
  db-basquetwi-cc started. Decisions approved: TIMESTAMPTZ, updatedAt trigger on workItems, eventType CHECK (CLAUDE.md list). Migration to be checked in at migrations/0001_init_pg.sql as SSOT for #584/#586. Est ~1h.
• 2026-06-04T02:25:01.275Z · completed
  Schema port done, smoke green (cf5aec3). migrations/0001_init_pg.sql is SSOT. basquetwi DB+role on whey:5432, TIMESTAMPTZ, JSONB, eventType CHECK (14 types), updatedAt trigger, FKs+partial indexes preserved. Unblocks #584.