From 925207ba97ddb648bd7ce87261f89b9dee51e620 Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Tue, 12 Sep 2023 18:45:11 +0200 Subject: Don't recreate forum FTS search tables every time we update the schema. --- schema.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'schema.sql') diff --git a/schema.sql b/schema.sql index e121bda..6439d5f 100644 --- a/schema.sql +++ b/schema.sql @@ -261,10 +261,10 @@ create index if not exists posts_thread_idx on posts(thread_id); -- Forum Search (FTS5) -- -drop table if exists forum_search; -create virtual table forum_search using fts5(thread_id, post_id, text, tokenize='porter unicode61'); -insert into forum_search(thread_id,post_id,text) select thread_id, 0, subject from threads; -insert into forum_search(thread_id,post_id,text) select thread_id, post_id, body from posts; +-- drop table if exists forum_search; +create virtual table if not exists forum_search using fts5(thread_id, post_id, text, tokenize='porter unicode61'); +-- insert into forum_search(thread_id,post_id,text) select thread_id, 0, subject from threads; +-- insert into forum_search(thread_id,post_id,text) select thread_id, post_id, body from posts; -- Games -- -- cgit v1.2.3