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

