From 9f8a609ece9093d3aaa62937c8035903bbd8a045 Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
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

