summary refs log tree commit diff
path: root/database.h
diff options
context:
space:
mode:
authorJune McEnroe <june@causal.agency>2019-12-06 12:09:51 -0500
committerJune McEnroe <june@causal.agency>2019-12-06 12:09:51 -0500
commit357276b599bd631f4a3c1cf63f63b886015ab9a0 (patch)
tree244b40c7f34b026afa4a1ca22126b729c169f643 /database.h
parentAdd catgirl format (diff)
downloadlitterbox-357276b599bd631f4a3c1cf63f63b886015ab9a0.tar.gz
litterbox-357276b599bd631f4a3c1cf63f63b886015ab9a0.zip
Add eventsDelete trigger
Diffstat (limited to '')
-rw-r--r--database.h5
1 files changed, 4 insertions, 1 deletions
diff --git a/database.h b/database.h
index 038ce70..2481262 100644
--- a/database.h
+++ b/database.h
@@ -177,7 +177,6 @@ static const char *InitSQL = {
 		"target TEXT,"
 		"message TEXT"
 	");"
-	// TODO: Create other indexes on events?
 	"CREATE VIRTUAL TABLE search USING fts5 ("
 		"message,"
 		"content = events,"
@@ -187,6 +186,10 @@ static const char *InitSQL = {
 	"CREATE TRIGGER eventsInsert AFTER INSERT ON events BEGIN"
 	" INSERT INTO search (rowid, message) VALUES (new.id, new.message);"
 	"END;"
+	"CREATE TRIGGER eventsDelete AFTER DELETE ON events BEGIN"
+	" INSERT INTO search (search, rowid, message)"
+	" VALUES ('delete', old.id, old.message);"
+	"END;"
 	"COMMIT TRANSACTION;"
 };