From f926ef682de637b717d3b0cc0eaee43c59e83c95 Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
Date: Sat, 17 Aug 2024 18:59:55 +0900
Subject: feat(backend): allow login/signup with email address

---
 backend/query.sql | 5 +++++
 1 file changed, 5 insertions(+)

(limited to 'backend/query.sql')

diff --git a/backend/query.sql b/backend/query.sql
index 25eb4df..6b0ecdd 100644
--- a/backend/query.sql
+++ b/backend/query.sql
@@ -3,6 +3,11 @@ SELECT * FROM users
 WHERE users.user_id = $1
 LIMIT 1;
 
+-- name: GetUserIDByUsername :one
+SELECT user_id FROM users
+WHERE users.username = $1
+LIMIT 1;
+
 -- name: CreateUser :one
 INSERT INTO users (username, display_name, is_admin)
 VALUES ($1, $1, false)
-- 
cgit v1.2.3-70-g09d2

