Schema for extra_database

CREATE TABLE searchable (
  pk integer primary key,
  text1 text,
  text2 text
);
CREATE VIEW searchable_view AS SELECT * FROM searchable;
CREATE VIRTUAL TABLE "searchable_fts"
    USING FTS3 (text1, text2, content="searchable");
CREATE TABLE 'searchable_fts_content'(docid INTEGER PRIMARY KEY, 'c0text1', 'c1text2', 'c2content');
CREATE TABLE 'searchable_fts_segments'(blockid INTEGER PRIMARY KEY, block BLOB);
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))