From 925207ba97ddb648bd7ce87261f89b9dee51e620 Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
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

