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
SQLite format 3 @ % .zp � �����L���d���� )= indexsqlite_autoindex_edges_1edges�f11�wtableembedding_metadataembedding_metadataCREATE TABLE embedding_metadata (
model_name TEXT PRIMARY KEY,
dims INTEGER NOT NULL,
inserted_at TEXT NOT NULL
)CW1 indexsqlite_autoindex_embedding_metadata_1embedding_metadata�u �9tablefacts_vecfacts_vec
CREATE TABLE facts_vec (
fact_id TEXT PRIMARY KEY,
embedding BLOB NOT NULL,
model_name TEXT NOT NULL DEFAULT '',
dims INTEGER NOT NULL,
created_at TEXT NOT NULL,
FOREIGN KEY (fact_id) REFERENCES facts(id) ON DELETE CASCADE
)1
E indexsqlite_autoindex_facts_vec_1facts_vecW /windexidx_facts_versionfacts CREATE INDEX idx_facts_version ON facts(version DESC)Z
/}indexidx_facts_sessionfacts CREATE INDEX idx_facts_session ON facts(created_session)q /�)indexidx_facts_sectionfacts
CREATE INDEX idx_facts_section ON facts(mind, section) WHERE status = 'active'W)}indexidx_facts_hashfacts CREATE INDEX idx_facts_hash ON facts(mind, content_hash)k+�!indexidx_facts_layerfactsCREATE INDEX idx_facts_layer ON facts(mind, layer) WHERE status = 'active's/�-indexidx_facts_personafactsCREATE INDEX idx_facts_persona ON facts(persona_id) WHERE persona_id IS NOT NULLn-�%indexidx_facts_activefactsCREATE INDEX idx_facts_active ON facts(mind, status) WHERE status = 'active'�a�!tablefactsfactsCREATE TABLE facts (
id TEXT PRIMARY KEY,
mind TEXT NOT NULL DEFAULT 'default',
section TEXT NOT NULL,
content TEXT NOT NULL,
status TEXT NOT NULL DEFAULT 'active',
created_at TEXT NOT NULL,
created_session TEXT,
supersedes TEXT,
superseded_at TEXT,
archived_at TEXT,
source TEXT NOT NULL DEFAULT 'manual',
content_hash TEXT NOT NULL,
confidence REAL NOT NULL DEFAULT 1.0,
last_reinforced TEXT NOT NULL,
reinforcement_count INTEGER NOT NULL DEFAULT 1,
decay_rate REAL NOT NULL DEFAULT 0.05,
decay_profile TEXT NOT NULL DEFAULT 'standard',
version INTEGER NOT NULL DEFAULT 0,
last_accessed TEXT,
jj_change_id TEXT,
persona_id TEXT,
layer TEXT NOT NULL DEFAULT 'project',
tags TEXT,
FOREIGN KEY (mind) REFERENCES minds(name) ON DELETE CASCADE
))= indexsqlite_autoindex_facts_1facts�Q�tablemindsmindsCREATE TABLE minds (
name TEXT PRIMARY KEY,
description TEXT,
status TEXT NOT NULL DEFAULT 'active',
origin_type TEXT,
origin_path TEXT,
origin_url TEXT,
readonly INTEGER NOT NULL DEFAULT 0,
parent TEXT,
created_at TEXT NOT NULL,
last_sync TEXT
))= indexsqlite_autoindex_minds_1mind
� � + 3 defaultactive2026-04-22 02:11:38
� �
default
�
��j
����L�� ���� )= indexsqlite_autoindex_edges_1edges�f11�wtableembedding_metadataembedding_metadataCREATE TABLE embe�f11�wtableembedding_metadataembedding_metadataCREATE TABLE embedding_metadata (
model_name TEXT PRIMARY KEY,
dims INTEGER NOT NULL,
inserted_at TEXT NOT NULL
)1
E indexsqlite_autoindex_facts_vec_1facts_vec�u �9tablefacts_vecfacts_vec
CREATE TABLE facts_vec (
fact_id TEXT PRIMARY KEY,
embedding BLOB NOT NULL,
model_name TEXT NOT NULL DEFAULT '',
dims INTEGER NOT NULL,
created_at TEXT NOT NULL,
FOREIGN KEY (fact_id) REFERENCES facts(id) ON DELETE CASCADE
)W /windexidx_facts_versionfacts CREATE INDEX idx_facts_version ON facts(version DESC)Z
/}indexidx_facts_sessionfacts CREATE INDEX idx_facts_session ON facts(created_session)q /�)indexidx_facts_sectionfacts
CREATE INDEX idx_facts_section ON facts(mind, section) WHERE status = 'active'W)}indexidx_facts_hashfacts CREATE INDEX idx_facts_hash ON facts(mind, content_hash)k+�!indexidx_facts_layerfactsCREATE INDEX idx_facts_layer ON facts(mind, layer) WHERE status = 'active's/�-indexidx_facts_personafactsCREATE INDEX idx_facts_persona ON facts(persona_id) WHERE persona_id IS NOT NULLn-�%indexidx_facts_activefactsCREATE INDEX idx_facts_active ON facts(mind, status) WHERE status = 'active'�a�!tablefactsfactsCREATE TABLE facts (
id TEXT PRIMARY KEY,
mind TEXT NOT NULL DEFAULT 'default',
section TEXT NOT NULL,
content TEXT NOT NULL,
status TEXT NOT NULL DEFAULT 'active',
created_at TEXT NOT NULL,
created_session TEXT,
supersedes TEXT,
superseded_at TEXT,
archived_at TEXT,
source TEXT NOT NULL DEFAULT 'manual',
content_hash TEXT NOT NULL,
confidence REAL NOT NULL DEFAULT 1.0,
last_reinforced TEXT NOT NULL,
reinforcement_count INTEGER NOT NULL DEFAULT 1,
decay_rate REAL NOT NULL DEFAULT 0.05,
decay_profile TEXT NOT NULL DEFAULT 'standard',
version INTEGER NOT NULL DEFAULT 0,
last_accessed TEXT,
jj_change_id TEXT,
persona_id TEXT,
layer TEXT NOT NULL DEFAULT 'project',
tags TEXT,
FOREIGN KEY (mind) REFERENCES minds(name) ON DELETE CASCADE
))= indexsqlite_autoindex_facts_1facts�Q�tablemindsmindsCREATE TABLE minds (
name TEXT PRIMARY KEY,
description TEXT,
status TEXT NOT NULL DEFAULT 'active',
origin_type TEXT,
origin_path TEXT,
origin_url TEXT,
readonly INTEGER NOT NULL DEFAULT 0,
parent TEXT,
created_at TEXT NOT NULL,
last_sync TEXT
))= indexsqlite_autoindex_minds_1minds
F � L �����6�� y��
� w � j))�tablefacts_fts_datafacts_fts_data CREATE TABLE 'facts_fts_data'(id INTEGER PRIMARY KEY, block BLOB)�W �tablefacts_ftsfacts_ftsCREATE VIRTUAL TABLE facts_fts USING fts5(
id UNINDEXED, mind UNINDEXED, section UNINDEXED, content,
content='facts', content_rowid='rowid'
)�%%�Ktableepisodes_vecepisodes_vecCREATE TABLE episodes_vec (
episode_id TEXT PRIMARY KEY,
embedding BLOB NOT NULL,
model_name TEXT NOT NULL DEFAULT '',
dims INTEGER NOT NULL,
created_at TEXT NOT NULL,
FOREIGN KEY (episode_id) REFERENCES episodes(id) ON DELETE CASCADE
)� K%1
E indexsqlite_autoindex_facts_vec_1facts_vec�y''�1tableepisode_factsepisode_factsCREATE TABLE episode_facts (
episode_id TEXT NOT NULL,
fact_id TEXT NOT NULL,
PRIMARY KEY (episode_id, fact_id),
FOREIGN KEY (episode_id) REFERENCES episodes(id) ON DELETE CASCADE,
FOREIGN KEY (fact_id) REFERENCES facts(id) ON DELETE CASCADE
)9M' indexsqlite_autoindex_episode_facts_1episode_factsa/ �indexidx_episodes_mindepisodesCREATE INDEX idx_episodes_mind ON episodes(mind, date DESC)�j �'tableepisodesepisodesCREATE TABLE episodes (
id TEXT PRIMARY KEY,
mind TEXT NOT NULL DEFAULT 'default',
title TEXT NOT NULL,
narrative TEXT NOT NULL,
date TEXT NOT NULL,
session_id TEXT,
created_at TEXT NOT NULL,
jj_change_id TEXT,
FOREIGN KEY (mind) REFERENCES minds(name) ON DELETE CASCADE
)/C indexsqlite_autoindex_episodes_1episodes � )= indexsqlite_autoindex_edges_1edges�9�QtableedgesedgesCREATE TABLE edges (
id TEXT PRIMARY KEY,
source_fact_id TEXT NOT NULL,
target_fact_id TEXT NOT NULL,
relation TEXT NOT NULL,
description TEXT,
confidence REAL NOT NULL DEFAULT 1.0,
last_reinforced TEXT,
reinforcement_count INTEGER NOT NULL DEFAULT 1,
decay_rate REAL NOT NULL DEFAULT 0.05,
status TEXT NOT NULL DEFAULT 'active',
created_at TEXT NOT NULL,
created_session TEXT,
source_mind TEXT,
target_mind TEXT,
FOREIGN KEY (source_fact_id) REFERENCES facts(id) ON DELETE CASCADE,
FOREIGN KEY (target_fact_id) REFERENCES facts(id) ON DELETE CASCADE
)CW1 indexsqlite_autoindex_embedding_metadata_1embedding_metadata ,11�wtableembedding_metadataembedding_metadataCREATE TABLE embedding_metadata (
model_name TEXT PRIMARY KEY,
� -�triggerfacts_fts_deletefactsCREATE TRIGGER facts_fts_delete AFTER DELETE ON facts BEGIN
INSERT INTO facts_fts(facts_fts, rowid, id, mind, section, content)
VALUES ('delete', OLD.rowid, OLD.id, OLD.mind, OLD.section, OLD.content);
END� -�Utriggerfacts_fts_insertfactsCREATE TRIGGER facts_fts_insert AFTER INSERT ON facts BEGIN
INSERT INTO facts_fts(rowid, id, mind, section, content)
VALUES (NEW.rowid, NEW.id, NEW.mind, NEW.section, NEW.content);
ENDl --� tablefacts_fts_configfacts_fts_config CREATE TABLE 'facts_fts_config'(k PRIMARY KEY, v) WITHOUT ROWIDp //��f11�wtableembedding_metadataembedding_metadataCREATE TABLE embedding_metadata (
model_name TEXT PRIMARY KEY,
dims INTEGER NOT NULL,
inserted_at TEXT NOT NULL
)
� ��
� � version
y ���
�
!
� @d�e�sZ)y �-())�tableschema_versionschema_version%CREATE TABLE schema_version (
version INTEGER PRIMARY KEY,
applied_at TEXT NOT NULL
)�.'3 �triggerepisodes_fts_deleteepisodesCREATE TRIGGER episodes_fts_delete AFTER DELETE ON episodes BEGIN
INSERT INTO episodes_fts(episodes_fts, rowid, id, mind, title, narrative)
VALUES ('delete', OLD.rowid, OLD.id, OLD.mind, OLD.title, OLD.narrative);
END�&3 �gtriggerepisodes_fts_insertepisodesCREATE TRIGGER episodes_fts_insert AFTER INSERT ON episodes BEGIN
INSERT INTO episodes_fts(rowid, id, mind, title, narrative)
VALUES (NEW.rowid, NEW.id, NEW.mind, NEW.title, NEW.narrative);
ENDu%33�tableepisodes_fts_configepisodes_fts_config$CREATE TABLE 'episodes_fts_config'(k PRIMARY KEY, v) WITHOUT ROWIDy$55�tableepisodes_fts_docsizeepisodes_fts_docsize#CREATE TABLE 'episodes_fts_docsize'(id INTEGER PRIMARY KEY, sz BLOB)�#--�Atableepisodes_fts_idxepisodes_fts_idx"CREATE TABLE 'episodes_fts_idx'(segid, term, pgno, PRIMARY KEY(segid, term)) WITHOUT ROWIDs"//�tableepisodes_fts_dataepisodes_fts_data!CREATE TABLE 'episodes_fts_data'(id INTEGER PRIMARY KEY, block BLOB)�Y!%%�wtableepisodes_ftsepisodes_ftsCREATE VIRTUAL TABLE episodes_fts USING fts5(
id UNINDEXED, mind UNINDEXED, title, narrative,
content='episodes', content_rowid='rowid'
)�5 -�1triggerfacts_fts_updatefactsCREATE TRIGGER facts_fts_update AFTER UPDATE ON facts BEGIN
INSERT INTO facts_fts(facts_fts, rowid, id, mind, section, content)
VALUES ('delete', OLD.rowid, OLD.id, OLD.mind, OLD.section, OLD.content);
INSERT INTO facts_fts(rowid, id, mind, section, content)
VALUES (NEW.rowid, NEW.id, NEW.mind, NEW.section, NEW.content);
END� -�triggerfacts_fts_deletefactsCREATE TRIGGER facts_fts_delete AFTER DELETE ON facts BEGIN
INSERT INTO facts_fts(facts_fts, rowid, id, mind, section, content)
VALUES ('delete', OLD.rowid, OLD.id, OLD.mind, OLD.section, OLD.content);
END� -�Utriggerfacts_fts_insertfactsCREATE TRIGGER facts_fts_insert AFTER INSERT ON facts BEGIN
INSERT INTO facts_fts(rowid, id, mind, section, content)
VALUES (NEW.rowid, NEW.id, NEW.mind, NEW.section, NEW.content);
ENDl --� tablefacts_fts_configfacts_fts_config CREATE TABLE 'facts_fts_config'(k PRIMARY KEY, v) WITHOUT ROWIDp //�tablefacts_fts_docsizefacts_fts_docsize CREATE TABLE 'facts_fts_docsize'(id INTEGER PRIMARY KEY, sz BLOB)~''�;tablefacts_fts_idxfacts_fts_idx CREATE TABLE 'facts_fts_idx'(segid, term, pgno, PRIMARY KEY(segid, term)) WITHOUT ROWIDj))�tablefacts_fts_datafacts_fts_data CREATE TABLE 'facts_fts_data'(id INTEGER PRIMARY KEY, block BLOB)�W �tablefacts_ftsfacts_ftsCREATE VIRTUAL TABLE facts_fts USING fts5(
id UNINDEXED, mind UNINDEXED, section UNINDEXED, content,
content='facts', content_rowid='rowid'
)7K% indexsqlite_autoindex_episodes_vec_1episodes_vec
� ��
� � version
� �� 32026-04-22 02:11:38 32026-04-22 02:11:38