SQLite format 3@ .c                version       F A EL`acu^p --tablefigures_fts_datafigures_fts_data CREATE TABLE 'figures_fts_data'(id INTEGER PRIMARY KEY, block BLOB)U ##stablefigures_ftsfigures_ftsCREATE VIRTUAL TABLE figures_fts USING fts5( file_name, location, tags, content='figures', content_rowid='id' )q 5- indexidx_latex_ref_figurelatex_references CREATE INDEX idx_latex_ref_figure ON latex_references(figure_id)\ --ktablelatex_referenceslatex_references CREATE TABLE latex_references ( id INTEGER PRIMARY KEY AUTOINCREMENT, figure_id INTEGER NOT NULL, tex_file TEXT NOT NULL, line_number INTEGER, context TEXT, FOREIGN KEY (figure_id) REFERENCES figures(id) ON DELETE CASCADE )P'mindexidx_file_typefigures CREATE INDEX idx_file_type ON figures(file_type)G!aindexidx_sourcefiguresCREATE INDEX idx_source ON figures(source)\/}indexidx_is_referencedfiguresCREATE INDEX idx_is_referenced ON figures(is_referenced)\/}indexidx_last_modifiedfiguresCREATE INDEX idx_last_modified ON figures(last_modified)P'mindexidx_file_hashfiguresCREATE INDEX idx_file_hash ON figures(file_hash)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)\tablefiguresfiguresCREATE TABLE figures ( id INTEGER PRIMARY KEY AUTOINCREMENT, file_path TEXT UNIQUE NOT NULL, file_name TEXT NOT NULL, file_hash TEXT NOT NULL, file_size INTEGER NOT NULL, file_type TEXT NOT NULL, -- Metadata last_modified REAL NOT NULL, thumbnail_path TEXT, -- Auto-extracted tags TEXT, is_referenced INTEGER DEFAULT 0, reference_count INTEGER DEFAULT 0, -- Discovery info source TEXT, location TEXT, -- Index tracking indexed_at REAL NOT NULL, UNIQUE(file_path) )-Aindexsqlite_autoindex_figures_1figures  Oy 8 OQ-kindexidx_table_sourcetablesCREATE INDEX idx_table_source ON tables(source)g;indexidx_table_is_referencedtablesCREATE INDEX idx_table_is_referenced ON tables(is_referenced)+?indexsqlite_autoindex_tables_1tables&'tabletablestablesCREATE TABLE tables ( id INTEGER PRIMARY KEY AUTOINCREMENT, file_path TEXT UNIQUE NOT NULL, file_name TEXT NOT NULL, file_hash TEXT NOT NULL, caption TEXT, -- Metadata last_modified REAL NOT NULL, thumbnail_path TEXT, -- Auto-extracted tags TEXT, is_referenced INTEGER DEFAULT 0, reference_count INTEGER DEFAULT 0, -- Discovery info source TEXT, location TEXT, -- Index tracking indexed_at REAL NOT NULL, UNIQUE(file_path) ),1triggerfigures_fts_deletefiguresCREATE TRIGGER figures_fts_delete AFTER DELETE ON figures BEGIN DELETE FROM figures_fts WHERE rowid = old.id; END{15triggerfigures_fts_updatefiguresCREATE TRIGGER figures_fts_update AFTER UPDATE ON figures BEGIN UPDATE figures_fts SET file_name = new.file_name, location = new.location, tags = new.tags WHERE rowid = new.id; END|17triggerfigures_fts_insertfiguresCREATE TRIGGER figures_fts_insert AFTER INSERT ON figures BEGIN INSERT INTO figures_fts(rowid, file_name, location, tags) VALUES (new.id, new.file_name, new.location, new.tags); ENDr11tablefigures_fts_configfigures_fts_configCREATE TABLE 'figures_fts_config'(k PRIMARY KEY, v) WITHOUT ROWIDv33tablefigures_fts_docsizefigures_fts_docsizeCREATE TABLE 'figures_fts_docsize'(id INTEGER PRIMARY KEY, sz BLOB) ++?tablefigures_fts_idxfigures_fts_idx CREATE TABLE 'figures_fts_idx'(segid, term, pgno, PRIMARY KEY(segid, term)) WITHOUT ROWID