summary refs log tree commit diff
diff options
context:
space:
mode:
-rw-r--r--database.h2
-rw-r--r--litterbox.c4
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)
> 2024-09-24Allow not having descriptionsJune McEnroe I'm sorry, I can't keep writing descriptions. It makes posting photos take too long, I often don't know the words for what I'm looking at, and a good description is an entirely different work of art than the photo I took, and I'm just a photographer. It's visual art. 2024-09-23Automatically select the last used lens for a bodyJune McEnroe 2024-09-19Add photos from September 5June McEnroe Had to prefix the folder number onto these file names manually because they must have come out of a different scanner or something. 2024-09-15Add some more film stocks to the listJune McEnroe 2024-09-13Add photos from September 2June McEnroe 2024-09-13Add Fomapan 200 to films listJune McEnroe 2024-09-10Add August 29 picnic photosJune McEnroe 2024-09-08Apply some bold to trips renderingJune McEnroe This seems easier to visually scan. The only other thing I'd like is a nicer date rendering but JavaScript is useless for that. 2024-09-08Render trips hopefully more efficientlyJune McEnroe 2024-09-08Allow removing bodies and lensesJune McEnroe 2024-09-08Limit body width so it looks less silly on desktopJune McEnroe 2024-09-07Handle no film being loadedJune McEnroe 2024-09-07Fancy up the text a littleJune McEnroe