From 47d81ffbd3e4fe178d2935325e312cef77276250 Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
Date: Wed, 7 Aug 2024 23:22:07 +0900
Subject: feat(backend): create submission_results table

---
 backend/query.sql | 4 ++++
 1 file changed, 4 insertions(+)

(limited to 'backend/query.sql')

diff --git a/backend/query.sql b/backend/query.sql
index 493fdb8..0d32944 100644
--- a/backend/query.sql
+++ b/backend/query.sql
@@ -68,6 +68,10 @@ SELECT * FROM testcases
 WHERE testcases.problem_id = (SELECT problem_id FROM games WHERE game_id = $1)
 ORDER BY testcases.testcase_id;
 
+-- name: CreateSubmissionResult :exec
+INSERT INTO submission_results (submission_id, status, stdout, stderr)
+VALUES ($1, $2, $3, $4);
+
 -- name: CreateTestcaseResult :exec
 INSERT INTO testcase_results (submission_id, testcase_id, status, stdout, stderr)
 VALUES ($1, $2, $3, $4, $5);
-- 
cgit v1.2.3-70-g09d2