From 0e8410f39e91b3b11063cb940926107639a2bc89 Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
Date: Wed, 7 Aug 2024 23:21:16 +0900
Subject: feat(backend): add created_at column to testcase_results

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

(limited to 'backend/schema.sql')

diff --git a/backend/schema.sql b/backend/schema.sql
index 3cc7ed9..53c68ec 100644
--- a/backend/schema.sql
+++ b/backend/schema.sql
@@ -71,6 +71,7 @@ CREATE TABLE testcase_results (
     status             VARCHAR(16) NOT NULL,
     stdout             TEXT        NOT NULL,
     stderr             TEXT        NOT NULL,
+    created_at         TIMESTAMP   NOT NULL DEFAULT NOW(),
     CONSTRAINT fk_submission_id FOREIGN KEY(submission_id) REFERENCES submissions(submission_id),
     CONSTRAINT fk_testcase_id FOREIGN KEY(testcase_id) REFERENCES testcases(testcase_id)
 );
-- 
cgit v1.2.3-70-g09d2

