SQLite format 3@ .� ��g�  � � � x  � ��V[��#�qtriggermemories_admemoriesCREATE TRIGGER memories_ad AFTER DELETE ON memories BEGIN DELETE FROM memories_fts WHERE rowid = old.id; END�x#�;triggermemories_aumemoriesCREATE TRIGGER memories_au AFTER UPDATE ON memories BEGIN DELETE FROM memories_fts WHERE rowid = old.id; INSERT INTO memories_fts(rowid, content, summary) VALUES (new.id, new.content, new.summary); END�E#�Utriggermemories_aimemoriesCREATE TRIGGER memories_ai AFTER INSERT ON memories BEGIN INSERT INTO memories_fts(rowid, content, summary) VALUES (new.id, new.content, new.summary); ENDu33�tablememories_fts_configmemories_fts_configCREATE TABLE 'memories_fts_config'(k PRIMARY KEY, v) WITHOUT ROWIDy55�tablememories_fts_docsizememories_fts_docsizeCREATE TABLE 'memories_fts_docsize'(id INTEGER PRIMARY KEY, sz BLOB)x 55�tablememories_fts_contentmemories_fts_content CREATE TABLE 'memories_fts_content'(id INTEGER PRIMARY KEY, c0, c1)� --�Atablememories_fts_idxmemories_fts_idx CREATE TABLE 'memories_fts_idx'(segid, term, pgno, PRIMARY KEY(segid, term)) WITHOUT ROWIDs //�tablememories_fts_datamemories_fts_data CREATE TABLE 'memories_fts_data'(id INTEGER PRIMARY KEY, block BLOB)� %%�Qtablememories_ftsmemories_ftsCREATE VIRTUAL TABLE memories_fts USING fts5( content, summary, content_rowid='id' )� I'�!indexidx_relationships_to_memory_idrelationships CREATE INDEX idx_relationships_to_memory_id ON relationships(to_memory_id)�^''�{tablerelationshipsrelationshipsCREATE TABLE relationships ( id INTEGER PRIMARY KEY AUTOINCREMENT, from_memory_id INTEGER NOT NULL, to_memory_id INTEGER NOT NULL, relation_type TEXT NOT NULL, created_at TEXT DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (from_memory_id) REFERENCES memories(id) ON DELETE CASCADE, FOREIGN KEY (to_memory_id) REFERENCES memories(id) ON DELETE CASCADE, UNIQUE(from_memory_id, to_memory_id, relation_type) ) STRICT9M'indexsqlite_autoindex_relationships_1relationships b9�indexidx_tags_tag_memory_idtagsCREATE INDEX idx_tags_tag_memory_id ON tags(tag, memory_id)�R�tabletagstagsCREATE TABLE tags ( memory_id INTEGER NOT NULL, tag TEXT NOT NULL, PRIMARY KEY (memory_id, tag), FOREIGN KEY (memory_id) REFERENCES memories(id) ON DELETE CASCADE ) STRICT';indexsqlite_autoindex_tags_1tagsP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�]� tablememoriesmemoriesCREATE TABLE memories ( id INTEGER PRIMARY KEY AUTOINCREMENT, content TEXT NOT NULL, summary TEXT, importance INTEGER DEFAULT 0, memory_type TEXT DEFAULT 'general', created_at TEXT DEFAULT CURRENT_TIMESTAMP, accessed_at TEXT DEFAULT CURRENT_TIMESTAMP, hash TEXT UNIQUE NOT NULL ) STRICT/Cindexsqlite_autoindex_memories_1memories          ���     �� version