diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-08-11 20:39:48 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-08-11 20:39:48 +0900 |
| commit | 125e26b4d5c986f8531c098ecd5d291c1e1c7a76 (patch) | |
| tree | fee5d641a05dc972a6b80fb3620d156f13d9b137 /backend/schema.sql | |
| parent | e3502d9e649fe61bb0ba4046b2c23c0d78bc92e9 (diff) | |
| download | phperkaigi-2025-albatross-125e26b4d5c986f8531c098ecd5d291c1e1c7a76.tar.gz phperkaigi-2025-albatross-125e26b4d5c986f8531c098ecd5d291c1e1c7a76.tar.zst phperkaigi-2025-albatross-125e26b4d5c986f8531c098ecd5d291c1e1c7a76.zip | |
feat(backend): make `games.problem_id` non-null
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); |