diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-08-05 02:18:22 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-08-05 03:02:06 +0900 |
| commit | 2705f09f5c52b25af07a1d7ccec546de68ff32e9 (patch) | |
| tree | cc5974fc9041411e842744b6cd527f29db2024ac /backend/schema.sql | |
| parent | ff959dadb1f990173b9df3105ccfc96b1c6c092e (diff) | |
| download | phperkaigi-2025-albatross-2705f09f5c52b25af07a1d7ccec546de68ff32e9.tar.gz phperkaigi-2025-albatross-2705f09f5c52b25af07a1d7ccec546de68ff32e9.tar.zst phperkaigi-2025-albatross-2705f09f5c52b25af07a1d7ccec546de68ff32e9.zip | |
feat(backend): add `game_type` column to `games`
Diffstat (limited to 'backend/schema.sql')
| -rw-r--r-- | backend/schema.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/backend/schema.sql b/backend/schema.sql index 4c63511..4a1d4b0 100644 --- a/backend/schema.sql +++ b/backend/schema.sql @@ -25,6 +25,7 @@ CREATE TABLE problems ( CREATE TABLE games ( game_id SERIAL PRIMARY KEY, + game_type VARCHAR(16) NOT NULL, state VARCHAR(32) NOT NULL, display_name VARCHAR(255) NOT NULL, duration_seconds INT NOT NULL, |