diff options
Diffstat (limited to 'planetwars-server/migrations/2022-01-02-105610_matches/up.sql')
-rw-r--r-- | planetwars-server/migrations/2022-01-02-105610_matches/up.sql | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/planetwars-server/migrations/2022-01-02-105610_matches/up.sql b/planetwars-server/migrations/2022-01-02-105610_matches/up.sql index 88c8c9e..ace13fd 100644 --- a/planetwars-server/migrations/2022-01-02-105610_matches/up.sql +++ b/planetwars-server/migrations/2022-01-02-105610_matches/up.sql @@ -1,5 +1,8 @@ +CREATE TYPE match_state AS ENUM ('playing', 'ended'); + CREATE TABLE matches ( - id SERIAL PRIMARY KEY, + id SERIAL PRIMARY KEY NOT NULL, + state match_state NOT NULL, log_path text NOT NULL, created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ); |