_memory
This data as json, testall, testnone, testresponse, CSV
type | name | tbl_name | rootpage | sql |
---|---|---|---|---|
table | searchable | searchable | 2 | CREATE TABLE searchable ( pk integer primary key, text1 text, text2 text ) |
table | searchable_fts | searchable_fts | 0 | CREATE VIRTUAL TABLE "searchable_fts" USING FTS3 (text1, text2, content="searchable") |
table | searchable_fts_content | searchable_fts_content | 3 | CREATE TABLE 'searchable_fts_content'(docid INTEGER PRIMARY KEY, 'c0text1', 'c1text2', 'c2content') |
table | searchable_fts_segments | searchable_fts_segments | 4 | CREATE TABLE 'searchable_fts_segments'(blockid INTEGER PRIMARY KEY, block BLOB) |
table | searchable_fts_segdir | searchable_fts_segdir | 5 | CREATE TABLE 'searchable_fts_segdir'(level INTEGER,idx INTEGER,start_block INTEGER,leaves_end_block INTEGER,end_block INTEGER,root BLOB,PRIMARY KEY(level, idx)) |