Schema for docs
CREATE TABLE "sections" (
"id" TEXT PRIMARY KEY,
"page" TEXT,
"ref" TEXT,
"title" TEXT,
"content" TEXT,
"breadcrumbs" TEXT,
"references" TEXT
);
CREATE VIRTUAL TABLE "sections_fts" USING FTS5 (
"title", "content",
tokenize='porter',
content="sections"
);
CREATE TABLE 'sections_fts_data'(id INTEGER PRIMARY KEY, block BLOB);
CREATE TABLE 'sections_fts_idx'(segid, term, pgno, PRIMARY KEY(segid, term)) WITHOUT ROWID;
CREATE TABLE 'sections_fts_docsize'(id INTEGER PRIMARY KEY, sz BLOB);
CREATE TABLE 'sections_fts_config'(k PRIMARY KEY, v) WITHOUT ROWID;
CREATE TRIGGER "sections_ai" AFTER INSERT ON "sections" BEGIN
INSERT INTO "sections_fts" (rowid, "title", "content") VALUES (new.rowid, new."title", new."content");
END;
CREATE TRIGGER "sections_ad" AFTER DELETE ON "sections" BEGIN
INSERT INTO "sections_fts" ("sections_fts", rowid, "title", "content") VALUES('delete', old.rowid, old."title", old."content");
END;
CREATE TRIGGER "sections_au" AFTER UPDATE ON "sections" BEGIN
INSERT INTO "sections_fts" ("sections_fts", rowid, "title", "content") VALUES('delete', old.rowid, old."title", old."content");
INSERT INTO "sections_fts" (rowid, "title", "content") VALUES (new.rowid, new."title", new."content");
END