0001 Init

_archivesourcesql
Path: _archive/loom-stale-pre-sprint-snapshot/migrations/0001_init.sqlRelative: loom-stale-pre-sprint-snapshot/migrations/0001_init.sqlSubproject: _archiveCategory: archived
Lines: 101Bytes: 4,113Imports: 0Exports: 0
_archivesourcesqlloom-stale-pre-sprint-snapshotmigrations

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