1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
SQLite format 3 @ .�
� � !�
��
F &
& � �
� �X
##�wtableobligationsobligations CREATE TABLE obligations (
id TEXT PRIMARY KEY,
intent_ref TEXT NOT NULL,
risk_tier TEXT NOT NULL,
required_proofs TEXT NOT NULL, -- JSON array of claim IDs or proof labels
status TEXT NOT NULL DEFAULT 'open', -- open, met, failed
created_at TEXT NOT NULL
)5 I# indexsqlite_autoindex_obligations_1obligations �J �ctabletask_tagstask_tags CREATE TABLE task_tags (
task_id TEXT NOT NULL,
tag TEXT NOT NULL,
PRIMARY KEY(task_id, tag),
FOREIGN KEY(task_id) REFERENCES tasks(id) ON DELETE CASCADE
)1 E indexsqlite_autoindex_task_tags_1task_tags
�r�CtabletaskstasksCREATE TABLE tasks (
id TEXT PRIMARY KEY,
hash TEXT NOT NULL,
title TEXT NOT NULL,
status TEXT NOT NULL DEFAULT 'open',
payload BLOB,
revision INTEGER NOT NULL DEFAULT 0
))= indexsqlite_autoindex_tasks_1tasksvE�indexidx_events_stream_seq_uniqueeventsCREATE UNIQUE INDEX idx_events_stream_seq_unique ON events(stream, seq)�3�AtableeventseventsCREATE TABLE events (
event_id TEXT PRIMARY KEY,
ts TEXT NOT NULL,
seq INTEGER NOT NULL,
stream TEXT NOT NULL,
subject_kind TEXT,
subject_id TEXT,
event_type TEXT NOT NULL DEFAULT '',
payload TEXT NOT NULL,
actor TEXT NOT NULL DEFAULT 'decapod'
)+? indexsqlite_autoindex_events_1events�+�9tablemetametaCREATE TABLE meta (
namespace TEXT NOT NULL,
key TEXT NOT NULL,
value TEXT NOT NULL,
PRIMARY KEY(namespace, key)
)'; indexsqlite_autoindex_meta_1meta
� � repoproductdactyl
� � repoproduct
� � V
5 #5evt12026-08-12T00:00:00Ztodotasktask-1node.create{"title":"imported"}decapod
� � evt1
� � todo
� � %'task-1abcimported taskopen �
� � task-1
� �
task-1docs
� � task-1docs
� � / 5ob1intent:1low[]open2026-08-12T00:00:00Z
� � ob1