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