From e9b709c12a9f64ab99b361a93c173548382147fd Mon Sep 17 00:00:00 2001
From: René 'Necoro' Neumann <necoro@necoro.eu>
Date: Tue, 13 Feb 2024 20:45:09 +0100
Subject: Check username in lowercase

---
 sql/users.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'sql/users.sql')

diff --git a/sql/users.sql b/sql/users.sql
index 3e0e992..9f1b5ef 100644
--- a/sql/users.sql
+++ b/sql/users.sql
@@ -5,7 +5,7 @@ SELECT *
 -- name: GetUserByName :one
 SELECT *
   FROM users
- WHERE name = ?;
+ WHERE LOWER(name) = LOWER(?);
 
 -- name: GetUserById :one
 SELECT *
-- 
cgit v1.2.3-70-g09d2

