From d94c9eb68e65d53f09bf3dd26ec4d61d245882ad Mon Sep 17 00:00:00 2001 From: nsfisis Date: Thu, 8 Aug 2024 20:33:40 +0900 Subject: feat(backend): add `code_hash` to `submissions` table --- backend/query.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'backend/query.sql') diff --git a/backend/query.sql b/backend/query.sql index e767746..f0e4034 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -59,8 +59,8 @@ SET WHERE game_id = $1; -- name: CreateSubmission :one -INSERT INTO submissions (game_id, user_id, code, code_size) -VALUES ($1, $2, $3, $4) +INSERT INTO submissions (game_id, user_id, code, code_size, code_hash) +VALUES ($1, $2, $3, $4, $5) RETURNING submission_id; -- name: ListTestcasesByGameID :many -- cgit v1.2.3-70-g09d2