From d799993a4fe0d05aa72c9a48d4a76c6db2240038 Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
Date: Wed, 7 Aug 2024 22:44:08 +0900
Subject: feat(backend): make testcase_executions.testcase_id non-null

---
 backend/schema.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'backend/schema.sql')

diff --git a/backend/schema.sql b/backend/schema.sql
index d0b6c40..27a63d1 100644
--- a/backend/schema.sql
+++ b/backend/schema.sql
@@ -67,7 +67,7 @@ CREATE TABLE submissions (
 CREATE TABLE testcase_executions (
     testcase_execution_id SERIAL      PRIMARY KEY,
     submission_id         INT         NOT NULL,
-    testcase_id           INT,
+    testcase_id           INT         NOT NULL,
     status                VARCHAR(16) NOT NULL,
     stdout                TEXT        NOT NULL,
     stderr                TEXT        NOT NULL,
-- 
cgit v1.2.3-70-g09d2

