aboutsummaryrefslogtreecommitdiffhomepage
path: root/backend/query.sql
diff options
context:
space:
mode:
authornsfisis <nsfisis@gmail.com>2024-08-05 02:33:54 +0900
committernsfisis <nsfisis@gmail.com>2024-08-05 03:02:18 +0900
commit968b835d0e6fe960c3d7ab915ef6d9cecec4ab7f (patch)
treeee5c3cd7e3817866439f71eccb085e8394a0a1a5 /backend/query.sql
parent5988360d8cf0fc0028c6db1c82afc1e313ba0513 (diff)
downloadphperkaigi-2025-albatross-968b835d0e6fe960c3d7ab915ef6d9cecec4ab7f.tar.gz
phperkaigi-2025-albatross-968b835d0e6fe960c3d7ab915ef6d9cecec4ab7f.tar.zst
phperkaigi-2025-albatross-968b835d0e6fe960c3d7ab915ef6d9cecec4ab7f.zip
feat(backend): allow to edit `game_type` in admin page
Diffstat (limited to 'backend/query.sql')
-rw-r--r--backend/query.sql11
1 files changed, 6 insertions, 5 deletions
diff --git a/backend/query.sql b/backend/query.sql
index 886f96c..39b0b21 100644
--- a/backend/query.sql
+++ b/backend/query.sql
@@ -41,9 +41,10 @@ LIMIT 1;
-- name: UpdateGame :exec
UPDATE games
SET
- state = $2,
- display_name = $3,
- duration_seconds = $4,
- started_at = $5,
- problem_id = $6
+ game_type = $2,
+ state = $3,
+ display_name = $4,
+ duration_seconds = $5,
+ started_at = $6,
+ problem_id = $7
WHERE game_id = $1;