diff options
| author | June McEnroe <june@causal.agency> | 2019-12-30 22:27:46 -0500 |
|---|---|---|
| committer | June McEnroe <june@causal.agency> | 2019-12-30 22:29:08 -0500 |
| commit | de6980860b012fd2dfd1f7a77b47473ff290dc4f (patch) | |
| tree | bbd46f89d2ccd120c28c7f941e6c9a97a8fe8c01 | |
| parent | Add -D flag to prospective scoop manual (diff) | |
| download | litterbox-de6980860b012fd2dfd1f7a77b47473ff290dc4f.tar.gz litterbox-de6980860b012fd2dfd1f7a77b47473ff290dc4f.zip | |
Join with USING wherever possible
| -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) |