From e7b35cd81f2e515371a30a59ea4173a31dbeefc5 Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
Date: Sat, 6 Sep 2025 01:09:20 +0900
Subject: feat(backend): add admin page for game creation

---
 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 9f272b1..4d95e3f 100644
--- a/backend/query.sql
+++ b/backend/query.sql
@@ -51,6 +51,11 @@ ORDER BY games.game_id;
 SELECT * FROM games
 ORDER BY games.game_id;
 
+-- name: CreateGame :one
+INSERT INTO games (game_type, is_public, display_name, duration_seconds, problem_id)
+VALUES ($1, $2, $3, $4, $5)
+RETURNING game_id;
+
 -- name: UpdateGameStartedAt :exec
 UPDATE games
 SET started_at = $2
-- 
cgit v1.3.1

