diff options
Diffstat (limited to 'backend/query.sql')
| -rw-r--r-- | backend/query.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/backend/query.sql b/backend/query.sql index e81a11b..61175ab 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -79,6 +79,14 @@ JOIN users ON game_main_players.user_id = users.user_id WHERE game_main_players.game_id = ANY($1::INT[]) ORDER BY game_main_players.user_id; +-- name: AddMainPlayer :exec +INSERT INTO game_main_players (game_id, user_id) +VALUES ($1, $2); + +-- name: RemoveAllMainPlayers :exec +DELETE FROM game_main_players +WHERE game_id = $1; + -- name: ListTestcasesByGameID :many SELECT * FROM testcases WHERE testcases.problem_id = (SELECT problem_id FROM games WHERE game_id = $1) |