diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-08-07 23:21:16 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-08-08 04:02:37 +0900 |
| commit | 0e8410f39e91b3b11063cb940926107639a2bc89 (patch) | |
| tree | 9ebf0e392411f2deaadb1afab0eb283eea2f029b | |
| parent | 4295abfd48ad8ce217b251d07102deb8aee413d5 (diff) | |
| download | iosdc-japan-2024-albatross-0e8410f39e91b3b11063cb940926107639a2bc89.tar.gz iosdc-japan-2024-albatross-0e8410f39e91b3b11063cb940926107639a2bc89.tar.zst iosdc-japan-2024-albatross-0e8410f39e91b3b11063cb940926107639a2bc89.zip | |
feat(backend): add created_at column to testcase_results
| -rw-r--r-- | backend/db/models.go | 1 | ||||
| -rw-r--r-- | backend/schema.sql | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/backend/db/models.go b/backend/db/models.go index a8729e4..49e4b52 100644 --- a/backend/db/models.go +++ b/backend/db/models.go @@ -53,6 +53,7 @@ type TestcaseResult struct { Status string Stdout string Stderr string + CreatedAt pgtype.Timestamp } type User struct { 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) ); |