From 2705f09f5c52b25af07a1d7ccec546de68ff32e9 Mon Sep 17 00:00:00 2001 From: nsfisis Date: Mon, 5 Aug 2024 02:18:22 +0900 Subject: feat(backend): add `game_type` column to `games` --- backend/schema.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'backend/schema.sql') 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, -- cgit v1.2.3-70-g09d2