1 files changed, 8 insertions, 0 deletions
diff --git a/backend/schema.sql b/backend/schema.sql
index f0b5b37..7f98d91 100644
--- a/backend/schema.sql
+++ b/backend/schema.sql
@@ -39,3 +39,11 @@ CREATE TABLE problems (
     title       VARCHAR(255) NOT NULL,
     description TEXT         NOT NULL
 );
+
+CREATE TABLE testcases (
+    testcase_id SERIAL PRIMARY KEY,
+    problem_id  INT    NOT NULL,
+    stdin       TEXT   NOT NULL,
+    stdout      TEXT   NOT NULL,
+    CONSTRAINT fk_problem_id FOREIGN KEY(problem_id) REFERENCES problems(problem_id)
+);