diff options
Diffstat (limited to 'backend/schema.sql')
| -rw-r--r-- | backend/schema.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/backend/schema.sql b/backend/schema.sql index 2779eaf..dc49363 100644 --- a/backend/schema.sql +++ b/backend/schema.sql @@ -37,7 +37,7 @@ CREATE TABLE games ( duration_seconds INT NOT NULL, created_at TIMESTAMP NOT NULL DEFAULT NOW(), started_at TIMESTAMP, - problem_id INT, + problem_id INT NOT NULL, CONSTRAINT fk_problem_id FOREIGN KEY(problem_id) REFERENCES problems(problem_id) ); CREATE INDEX idx_games_problem_id ON games(problem_id); |
