beads_rust 0.1.14

Agent-first issue tracker (SQLite + JSONL)
Documentation 
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
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211

SQLite format 3@  +.zp��
�
*	�	n	
~E���wC��h��h;�indexidx_comments_created_atcommentsCREATE INDEX idx_comments_created_at ON comments(created_at)a7}indexidx_comments_issue_idcommentsCREATE INDEX idx_comments_issue_id ON comments(issue_id)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�+�)tablecommentscommentsCREATE TABLE comments (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        issue_id TEXT NOT NULL,
        author TEXT NOT NULL,
        text TEXT NOT NULL,
        created_at TEXT NOT NULL,
        FOREIGN KEY (issue_id) REFERENCES issues(id) ON DELETE CASCADE
    )Y3uindexidx_labels_issue_idlabelsCREATE INDEX idx_labels_issue_id ON labels(issue_id)P-iindexidx_labels_labellabelsCREATE INDEX idx_labels_label ON labels(label)�_�tablelabelslabelsCREATE TABLE labels (
        issue_id TEXT NOT NULL,
        label TEXT NOT NULL,
        PRIMARY KEY (issue_id, label),
        FOREIGN KEY (issue_id) REFERENCES issues(id) ON DELETE CASCADE
    )+?indexsqlite_autoindex_labels_1labelse7%}indexidx_dependencies_typedependenciesCREATE INDEX idx_dependencies_type ON dependencies(type)�
I%�!indexidx_dependencies_depends_on_iddependenciesCREATE INDEX idx_dependencies_depends_on_id ON dependencies(depends_on_id)r?%�
indexidx_dependencies_issue_iddependencies
CREATE INDEX idx_dependencies_issue_id ON dependencies(issue_id)�?
%%�AtabledependenciesdependenciesCREATE TABLE dependencies (
        issue_id TEXT NOT NULL,
        depends_on_id TEXT NOT NULL,
        type TEXT NOT NULL,
        created_at TEXT NOT NULL,
        created_by TEXT,
        metadata TEXT,
        thread_id TEXT,
        PRIMARY KEY (issue_id, depends_on_id)
    )7K%indexsqlite_autoindex_dependencies_1dependencies�	;�Qindexidx_issues_external_refissues
CREATE UNIQUE INDEX idx_issues_external_ref ON issues(external_ref) WHERE external_ref IS NOT NULL_7}indexidx_issues_updated_atissues	CREATE INDEX idx_issues_updated_at ON issues(updated_at)_7}indexidx_issues_created_atissuesCREATE INDEX idx_issues_created_at ON issues(created_at)Y3uindexidx_issues_assigneeissuesCREATE INDEX idx_issues_assignee ON issues(assignee)_7}indexidx_issues_issue_typeissuesCREATE INDEX idx_issues_issue_type ON issues(issue_type)Y3uindexidx_issues_priorityissuesCREATE INDEX idx_issues_priority ON issues(priority)S/mindexidx_issues_statusissuesCREATE INDEX idx_issues_status ON issues(status)�
�utableissuesissuesCREATE TABLE issues (
        id TEXT PRIMARY KEY,
        content_hash TEXT,
        title TEXT NOT NULL,
        description TEXT,
        design TEXT,
        acceptance_criteria TEXT,
        notes TEXT,
        status TEXT NOT NULL,
        priority INTEGER NOT NULL,
        issue_type TEXT NOT NULL,
        assignee TEXT,
        owner TEXT,
        estimated_minutes INTEGER,
        created_at TEXT NOT NULL,
        created_by TEXT,
        updated_at TEXT NOT NULL,
        closed_at TEXT,
        close_reason TEXT,
        closed_by_session TEXT,
        due_at TEXT,
        defer_until TEXT,
        external_ref TEXT,
        source_system TEXT,
        deleted_at TEXT,
        deleted_by TEXT,
        delete_reason TEXT,
        original_type TEXT,
        compaction_level INTEGER,
        compacted_at TEXT,
        compacted_at_commit TEXT,
        original_size INTEGER,
        sender TEXT,
        ephemeral INTEGER DEFAULT 0,
        pinned INTEGER DEFAULT 0,
        is_template INTEGER DEFAULT 0,
        CHECK (length(title) >= 1 AND length(title) <= 500),
        CHECK (priority >= 0 AND priority <= 4)
    )+?indexsqlite_autoindex_issues_1issues
























E
;�
�
�
*	�	n	
~E���wC��h�6�b�tableeventseventsCREATE TABLE events (
        id INTEGER PRIMARY KEY,
        issue_id TEXT NOT NULL,
        event_type TEXT NOT NULL,
        actor TEXT NOT NULL,
        old_value TEXT,
        new_value TEXT,
        comment TEXT,
        created_at TEXT NOT NULL,
        FOREIGN KEY (issue_id) REFERENCES issues(id) ON DELETE CASCADE
    )h;�indexidx_comments_created_atcommentsCREATE INDEX idx_comments_created_at ON comments(created_at)a7}indexidx_comments_issue_idcommentsCREATE INDEX idx_comments_issue_id ON comments(issue_id)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�+�)tablecommentscommentsCREATE TABLE comments (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        issue_id TEXT NOT NULL,
        author TEXT NOT NULL,
        text TEXT NOT NULL,
        created_at TEXT NOT NULL,
        FOREIGN KEY (issue_id) REFERENCES issues(id) ON DELETE CASCADE
    )Y3uindexidx_labels_issue_idlabelsCREATE INDEX idx_labels_issue_id ON labels(issue_id)P-iindexidx_labels_labellabelsCREATE INDEX idx_labels_label ON labels(label)�_�tablelabelslabelsCREATE TABLE labels (
        issue_id TEXT NOT NULL,
        label TEXT NOT NULL,
        PRIMARY KEY (issue_id, label),
        FOREIGN KEY (issue_id) REFERENCES issues(id) ON DELETE CASCADE
    )E�?indexsqlite_autoindex_labels_1labelse7%}indexidx_dependencies_typedependenciesCREATE INDEX idx_dependencies_type ON dependencies(type)�
I%�!indexidx_dependencies_depends_on_iddependenciesCREATE INDEX idx_dependencies_depends_on_id ON dependencies(depends_on_id)r?%�
indexidx_dependencies_issue_iddependencies
CREATE INDEX idx_dependencies_issue_id ON dependencies(issue_id)�?
%%�AtabledependenciesdependenciesCREATE TABLE dependencies (
        issue_id TEXT NOT NULL,
        depends_on_id TEXT NOT NULL,
        type TEXT NOT NULL,
        created_at TEXT NOT NULL,
        created_by TEXT,
        metadata TEXT,
        thread_id TEXT,
        PRIMARY KEY (issue_id, depends_on_id)
    )�9K%indexsqlite_autoindex_dependencies_1dependencies�	;�Qindexidx_issues_external_refissues
CREATE UNIQUE INDEX idx_issues_external_ref ON issues(external_ref) WHERE external_ref IS NOT NULL_7}indexidx_issues_updated_atissues	CREATE INDEX idx_issues_updated_at ON issues(updated_at)_7}indexidx_issues_created_atissuesCREATE INDEX idx_issues_created_at ON issues(created_at)Y3uindexidx_issues_assigneeissuesCREATE INDEX idx_issues_assignee ON issues(assignee)_7}indexidx_issues_issue_typeissuesCREATE INDEX idx_issues_issue_type ON issues(issue_type)Y3uindexidx_issues_priorityissuesCREATE INDEX idx_issues_priority ON issues(priority)S/mindexidx_issues_statusissuesCREATE INDEX idx_issues_status ON issues(status)�
�utableissuesissuesCREATE TABLE issues (
        id TEXT PRIMARY KEY,
        content_hash TEXT,
        title TEXT NOT NULL,
        description TEXT,
        design TEXT,
        acceptance_criteria TEXT,
        notes TEXT,
        status TEXT NOT NULL,
        priority INTEGER NOT NULL,
        issue_type TEXT NOT NULL,
        assignee TEXT,
        owner TEXT,
        estimated_minutes INTEGER,
        created_at TEXT NOT NULL,
        created_by TEXT,
        updated_at TEXT NOT NULL,
        closed_at TEXT,
        close_reason TEXT,
        closed_by_session TEXT,
        due_at TEXT,
        defer_until TEXT,
        external_ref TEXT,
        source_system TEXT,
        deleted_at TEXT,
        deleted_by TEXT,
        delete_reason TEXT,
        original_type TEXT,
        compaction_level INTEGER,
        compacted_at TEXT,
        compacted_at_commit TEXT,
        original_size INTEGER,
        sender TEXT,
        ephemeral INTEGER DEFAULT 0,
        pinned INTEGER DEFAULT 0,
        is_template INTEGER DEFAULT 0,
        CHECK (length(title) >= 1 AND length(title) <= 500),
        CHECK (priority >= 0 AND priority <= 4)
    )+?indexsqlite_autoindex_issues_1issues

�;�S�h
�
Y
�~,
�
_��>���V?�z� �;��%'))�tablechild_counterschild_counters*CREATE TABLE child_counters (
        parent_id TEXT PRIMARY KEY,
        next_child_number INTEGER NOT NULL DEFAULT 1
    );(O)indexsqlite_autoindex_child_counters_1child_counters+�'%55�qtableblocked_issues_cacheblocked_issues_cache(CREATE TABLE blocked_issues_cache (
        issue_id TEXT PRIMARY KEY,
        blocked_by_json TEXT NOT NULL
    )G&[5indexsqlite_autoindex_blocked_issues_cache_1blocked_issues_cache)�2#''�#tableexport_hashesexport_hashes&CREATE TABLE export_hashes (
        issue_id TEXT PRIMARY KEY,
        content_hash TEXT NOT NULL,
        exported_at TEXT NOT NULL
    )9$M'indexsqlite_autoindex_export_hashes_1export_hashes'u"A%�indexidx_dirty_issues_marked_atdirty_issues%CREATE INDEX idx_dirty_issues_marked_at ON dirty_issues(marked_at)�	 %%�Utabledirty_issuesdirty_issues#CREATE TABLE dirty_issues (
        issue_id TEXT PRIMARY KEY,
        marked_at TEXT NOT NULL
    )7!K%indexsqlite_autoindex_dirty_issues_1dirty_issues$t�;tablemetadatametadata!CREATE TABLE metadata (
        key TEXT PRIMARY KEY,
        value TEXT NOT NULL
    )/Cindexsqlite_autoindex_metadata_1metadata"n�7tableconfigconfigCREATE TABLE config (
        key TEXT PRIMARY KEY,
        value TEXT NOT NULL
    )+?indexsqlite_autoindex_config_1config P-iindexidx_events_actoreventsCREATE INDEX idx_events_actor ON events(actor)_7}indexidx_events_created_ateventsCREATE INDEX idx_events_created_at ON events(created_at)_7}indexidx_events_event_typeeventsCREATE INDEX idx_events_event_type ON events(event_type)Y3uindexidx_events_issue_ideventsCREATE INDEX idx_events_issue_id ON events(issue_id)�b�tableeventseventsCREATE TABLE events (
        id INTEGER PRIMARY KEY,
        issue_id TEXT NOT NULL,
        event_type TEXT NOT NULL,
        actor TEXT NOT NULL,
        old_value TEXT,
        new_value TEXT,
        comment TEXT,
        created_at TEXT NOT NULL,
        FOREIGN KEY (issue_id) REFERENCES issues(id) ON DELETE CASCADE
    )h;�indexidx_comments_created_atcommentsCREATE INDEX idx_comments_created_at ON comments(created_at)a7}indexidx_comments_issue_idcommentsCREATE INDEX idx_comments_issue_id ON comments(issue_id)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�+�)tablecommentscommentsCREATE TABLE comments (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        issue_id TEXT NOT NULL,
        author TEXT NOT NULL,
        text TEXT NOT NULL,
        created_at TEXT NOT NULL,
        FOREIGN KEY (issue_id) REFERENCES issues(id) ON DELETE CASCADE
    )Y3uindexidx_labels_issue_idlabelsCREATE INDEX idx_labels_issue_id ON labels(issue_id)P-iindexidx_labels_labellabelsCREATE INDEX idx_labels_label ON labels(label)+?indexsqlite_autoindex_labels_1labels�_�tablelabelslabelsCREATE TABLE labels (
        issue_id TEXT NOT NULL,
        label TEXT NOT NULL,
        PRIMARY KEY (issue_id, label),
        FOREIGN KEY (issue_id) REFERENCES issues(id) ON DELETE CASCADE
    )e7%}indexidx_dependencies_typedependenciesCREATE INDEX idx_dependencies_type ON dependencies(type)�
I%�!indexidx_dependencies_depends_on_iddependenciesCREATE INDEX idx_dependencies_depends_on_id ON dependencies(depends_on_id)r?%�
indexidx_dependencies_issue_iddependencies
CREATE INDEX idx_dependencies_issue_id ON dependencies(issue_id)7K%indexsqlite_autoindex_dependencies_1dependencies