diff options
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 |