diff options
| author | nsfisis <nsfisis@gmail.com> | 2025-03-15 21:44:10 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2025-03-15 21:44:10 +0900 |
| commit | 223891066ab3f727f2270e3674d93888405ca4d5 (patch) | |
| tree | 8c0221b775e6983f4946b93f4456f2d24741412c /backend/query.sql | |
| parent | 074c7feb19efeb936025410ba6ec95ac01884f5e (diff) | |
| download | iosdc-japan-2025-albatross-223891066ab3f727f2270e3674d93888405ca4d5.tar.gz iosdc-japan-2025-albatross-223891066ab3f727f2270e3674d93888405ca4d5.tar.zst iosdc-japan-2025-albatross-223891066ab3f727f2270e3674d93888405ca4d5.zip | |
feat(backen): allow admin to edit main players
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) |