From e247e81f649297784dc81e83b2e6d33d30f9f3ee Mon Sep 17 00:00:00 2001
From: Dan Goodliffe <dan.goodliffe@octal.co.uk>
Date: Wed, 18 Mar 2026 10:25:09 +0000
Subject: Fix typo in access_log_view definition

Replaces accidentally duplicated user_agent for correct content_type.
---
 src/schema.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'src/schema.sql')

diff --git a/src/schema.sql b/src/schema.sql
index 8008b3c..140f2a5 100644
--- a/src/schema.sql
+++ b/src/schema.sql
@@ -99,4 +99,4 @@ FROM
 	LEFT OUTER JOIN entities q ON l.query_string = q.id
 	LEFT OUTER JOIN entities r ON l.referrer = r.id
 	LEFT OUTER JOIN entities u ON l.user_agent = u.id
-	LEFT OUTER JOIN entities c ON l.user_agent = c.id;
+	LEFT OUTER JOIN entities c ON l.content_type = c.id;
-- 
cgit v1.3

