_memory

Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette

Custom SQL query returning 5 rows (hide)

This data as json, testall, testnone, testresponse, CSV

typenametbl_namerootpagesql
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))