diff options
| author | nsfisis <nsfisis@gmail.com> | 2025-04-02 01:13:37 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2025-04-02 01:13:37 +0900 |
| commit | 9f8a609ece9093d3aaa62937c8035903bbd8a045 (patch) | |
| tree | cc329ca4e5ef24496e8b9a542b537d0354623fd9 /backend/query.sql | |
| parent | 626ab209bc5b1b9f3a608a1c2a536ead3cd27a7f (diff) | |
| download | phperkaigi-2025-albatross-9f8a609ece9093d3aaa62937c8035903bbd8a045.tar.gz phperkaigi-2025-albatross-9f8a609ece9093d3aaa62937c8035903bbd8a045.tar.zst phperkaigi-2025-albatross-9f8a609ece9093d3aaa62937c8035903bbd8a045.zip | |
feat(backend): add admin tool to fix submission status
Diffstat (limited to 'backend/query.sql')
| -rw-r--r-- | backend/query.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/backend/query.sql b/backend/query.sql index 49fe2c1..4a06ee7 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -188,3 +188,9 @@ SET best_score_submission_id = ( LIMIT 1 ) WHERE game_id = $1 AND user_id = $2; + +-- name: ListSubmissionIDs :many +SELECT submission_id FROM submissions; + +-- name: ListGameStateIDs :many +SELECT game_id, user_id FROM game_states; |