From 95dd5f0c346d10c9a9497daf88cd199ce71c8122 Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
Date: Sat, 17 Aug 2024 19:35:56 +0900
Subject: feat(backend): fetch user icon from fortee

---
 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 6b0ecdd..dc5f384 100644
--- a/backend/query.sql
+++ b/backend/query.sql
@@ -13,6 +13,11 @@ INSERT INTO users (username, display_name, is_admin)
 VALUES ($1, $1, false)
 RETURNING user_id;
 
+-- name: UpdateUserIconPath :exec
+UPDATE users
+SET icon_path = $2
+WHERE user_id = $1;
+
 -- name: ListUsers :many
 SELECT * FROM users
 ORDER BY users.user_id;
-- 
cgit v1.3.1

