From 9f8a609ece9093d3aaa62937c8035903bbd8a045 Mon Sep 17 00:00:00 2001 From: nsfisis Date: Wed, 2 Apr 2025 01:13:37 +0900 Subject: feat(backend): add admin tool to fix submission status --- backend/query.sql | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'backend/query.sql') 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; -- cgit v1.2.3-70-g09d2