From e7b35cd81f2e515371a30a59ea4173a31dbeefc5 Mon Sep 17 00:00:00 2001 From: nsfisis 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.2.3-70-g09d2