aboutsummaryrefslogtreecommitdiffhomepage
path: root/backend/query.sql
diff options
context:
space:
mode:
authornsfisis <nsfisis@gmail.com>2025-03-04 23:39:26 +0900
committernsfisis <nsfisis@gmail.com>2025-03-04 23:39:26 +0900
commitefd34b970d0d1f88fa7d7e9d69e569f039867ca2 (patch)
treeba1e5a51e2fac9ecbe7b9b3e0e197bdb327f2a4e /backend/query.sql
parentbd9c2e8b587c733059d44f642c53536eb7fe1ec9 (diff)
downloadphperkaigi-2025-albatross-efd34b970d0d1f88fa7d7e9d69e569f039867ca2.tar.gz
phperkaigi-2025-albatross-efd34b970d0d1f88fa7d7e9d69e569f039867ca2.tar.zst
phperkaigi-2025-albatross-efd34b970d0d1f88fa7d7e9d69e569f039867ca2.zip
rm registration token
Diffstat (limited to 'backend/query.sql')
-rw-r--r--backend/query.sql6
1 files changed, 0 insertions, 6 deletions
diff --git a/backend/query.sql b/backend/query.sql
index dc5f384..fcff758 100644
--- a/backend/query.sql
+++ b/backend/query.sql
@@ -32,12 +32,6 @@ LIMIT 1;
INSERT INTO user_auths (user_id, auth_type)
VALUES ($1, $2);
--- name: IsRegistrationTokenValid :one
-SELECT EXISTS (
- SELECT 1 FROM registration_tokens
- WHERE token = $1
-);
-
-- name: ListGames :many
SELECT * FROM games
JOIN problems ON games.problem_id = problems.problem_id