18 lines
479 B
Go
18 lines
479 B
Go
package storage
|
|
|
|
// migration007 — FTS5 search index.
|
|
// Requires SQLite compiled with FTS5 (go build -tags sqlite_fts5).
|
|
// The migration is wrapped in a savepoint so it can be skipped on
|
|
// SQLite builds without FTS5 (the search_index table simply won't exist,
|
|
// and search falls back to LIKE on node titles).
|
|
const migration007 = `
|
|
CREATE VIRTUAL TABLE IF NOT EXISTS search_index USING fts5(
|
|
node_id UNINDEXED,
|
|
title,
|
|
content,
|
|
path,
|
|
tags,
|
|
type
|
|
);
|
|
`
|