diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-08-07 22:49:33 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-08-08 04:02:37 +0900 |
| commit | 5a2217f7a9d01b925c3db6491a363e6e4db9ca42 (patch) | |
| tree | 9b6dcc019834a720a97348d26f1942eb05e84ec1 /backend/schema.sql | |
| parent | d799993a4fe0d05aa72c9a48d4a76c6db2240038 (diff) | |
| download | iosdc-japan-2024-albatross-5a2217f7a9d01b925c3db6491a363e6e4db9ca42.tar.gz iosdc-japan-2024-albatross-5a2217f7a9d01b925c3db6491a363e6e4db9ca42.tar.zst iosdc-japan-2024-albatross-5a2217f7a9d01b925c3db6491a363e6e4db9ca42.zip | |
feat(backend): rename testcase_executions to testcase_results
Diffstat (limited to 'backend/schema.sql')
| -rw-r--r-- | backend/schema.sql | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/backend/schema.sql b/backend/schema.sql index 27a63d1..3cc7ed9 100644 --- a/backend/schema.sql +++ b/backend/schema.sql @@ -64,14 +64,14 @@ CREATE TABLE submissions ( CONSTRAINT fk_user_id FOREIGN KEY(user_id) REFERENCES users(user_id) ); -CREATE TABLE testcase_executions ( - testcase_execution_id SERIAL PRIMARY KEY, - submission_id INT NOT NULL, - testcase_id INT NOT NULL, - status VARCHAR(16) NOT NULL, - stdout TEXT NOT NULL, - stderr TEXT NOT NULL, +CREATE TABLE testcase_results ( + testcase_result_id SERIAL PRIMARY KEY, + submission_id INT NOT NULL, + testcase_id INT NOT NULL, + status VARCHAR(16) NOT NULL, + stdout TEXT NOT NULL, + stderr TEXT NOT NULL, CONSTRAINT fk_submission_id FOREIGN KEY(submission_id) REFERENCES submissions(submission_id), CONSTRAINT fk_testcase_id FOREIGN KEY(testcase_id) REFERENCES testcases(testcase_id) ); -CREATE INDEX idx_testcase_executions_submission_id ON testcase_executions(submission_id); +CREATE INDEX idx_testcase_results_submission_id ON testcase_results(submission_id); |
