0001 Init

loom-sprint-scaffoldsourcesql
Path: loom-sprint-scaffold/loom/migrations/0001_init.sqlRelative: loom/migrations/0001_init.sqlSubproject: loom-sprint-scaffoldCategory: other
Lines: 101Bytes: 4,113Imports: 0Exports: 0
loom-sprint-scaffoldsourcesqlloommigrations

Content Preview

  1. -- LOOM 0001_init — 7 core tables + FTS5 + append-only enforcement.
  2. -- Identical on local workerd (--local) and edge D1 (--remote): D1 = SQLite.
  4. CREATE TABLE goals (
  5. goal_id TEXT PRIMARY KEY,
  6. original_spec TEXT NOT NULL,
  7. spec_hash TEXT NOT NULL,
  8. status TEXT NOT NULL CHECK (status IN ('active','reformulating','halted','completed','failed')),
  9. tunables_json TEXT NOT NULL,
  10. created_at TEXT NOT NULL
  11. );
  13. CREATE TABLE stages (
  14. stage_id TEXT PRIMARY KEY,
  15. goal_i