Schema: project keys + per-project WI counter

Sub-tickets

Questions

Activity

• wi-cli-whey created · 2026-06-05
  parent=#649
• wi-cli-whey spec · 2026-06-05
  Per docs/per-project-numbering.md §Schema. Add: projects.key TEXT UNIQUE NOT NULL CHECK(key=upper(key) AND key ~ '^[A-Z][A-Z0-9]{1,9}$'); projects.nextWorkItemNumber INT NOT NULL DEFAULT 1; workItems.projectNumber INT NULL; partial unique (projectId,projectNumber) WHERE projectNumber IS NOT NULL. Backfill existing project keys: ha=HOAC basquetwi=BWI basquet=BSQ agent-ops=OPS ayudarg=AYUD evolutiva=EVO llmmsg-srv=MSG mars=MARS pluto=PLUTO venus=VENUS (Elazar may override). Do NOT backfill workItems.projectNumber (stays NULL = displays global #id). Stage as next numbered migration; coordinate apply window w/ me.
• wi-cli-whey completed · 2026-06-05
  completed
• wi-cli-whey completed · 2026-06-05
  completed