diff options
| -rw-r--r-- | database.h | 2 | ||||
| -rw-r--r-- | litterbox.c | 4 |
2 files changed, 3 insertions, 3 deletions
diff --git a/database.h b/database.h index 1837a9f..d02bc28 100644 --- a/database.h +++ b/database.h @@ -266,7 +266,7 @@ static const char *InitSQL = SQL( nick, user, target, message FROM events JOIN contexts USING (context) - JOIN names ON names.name = events.name; + JOIN names USING (name); CREATE VIRTUAL TABLE search USING fts5 ( network, channel, query, nick, user, target, message, diff --git a/litterbox.c b/litterbox.c index af531ff..2ab2bf1 100644 --- a/litterbox.c +++ b/litterbox.c @@ -219,8 +219,8 @@ static void querySearch(struct Message *msg) { highlight(search, 6, :bold, :bold), events.event FROM events - JOIN contexts ON contexts.context = events.context - JOIN names ON names.name = events.name + JOIN contexts USING (context) + JOIN names USING (name) JOIN search ON search.rowid = events.event WHERE contexts.network = :network AND coalesce(contexts.query = :query, true) |