diff options
| author | June McEnroe <june@causal.agency> | 2019-12-06 12:09:51 -0500 |
|---|---|---|
| committer | June McEnroe <june@causal.agency> | 2019-12-06 12:09:51 -0500 |
| commit | 357276b599bd631f4a3c1cf63f63b886015ab9a0 (patch) | |
| tree | 244b40c7f34b026afa4a1ca22126b729c169f643 /database.h | |
| parent | Add catgirl format (diff) | |
| download | litterbox-357276b599bd631f4a3c1cf63f63b886015ab9a0.tar.gz litterbox-357276b599bd631f4a3c1cf63f63b886015ab9a0.zip | |
Add eventsDelete trigger
Diffstat (limited to 'database.h')
| -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;" }; |