sqlite> .tables
documents  settings   tokens

sqlite> .schema documents
CREATE TABLE documents (  id      INTEGER PRIMARY KEY,  title   TEXT NOT NULL,  body    TEXT NOT NULL);
CREATE UNIQUE INDEX title_index ON documents(title);

sqlite> .schema tokens
CREATE TABLE tokens (  id         INTEGER PRIMARY KEY,  token      TEXT NOT NULL,  docs_count INT NOT NULL,  postings   BLOB NOT NULL);
CREATE UNIQUE INDEX token_index ON tokens(token);