diff options
| -rw-r--r-- | database.h | 5 |
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;" }; |