diff options
| author | nsfisis <nsfisis@gmail.com> | 2025-09-06 01:09:20 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2025-09-06 01:09:20 +0900 |
| commit | e7b35cd81f2e515371a30a59ea4173a31dbeefc5 (patch) | |
| tree | 783ef649110730a8946b0021c50688d29b6dab9b /backend/query.sql | |
| parent | e33bfff4db95586a3140b5e71a7d3dba2c72f694 (diff) | |
| download | iosdc-japan-2025-albatross-e7b35cd81f2e515371a30a59ea4173a31dbeefc5.tar.gz iosdc-japan-2025-albatross-e7b35cd81f2e515371a30a59ea4173a31dbeefc5.tar.zst iosdc-japan-2025-albatross-e7b35cd81f2e515371a30a59ea4173a31dbeefc5.zip | |
feat(backend): add admin page for game creation
Diffstat (limited to 'backend/query.sql')
| -rw-r--r-- | backend/query.sql | 5 |
1 files changed, 5 insertions, 0 deletions
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 |