aboutsummaryrefslogtreecommitdiff
path: root/planetwars-server/migrations/2022-01-02-105610_matches/up.sql
diff options
context:
space:
mode:
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.sql5
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
);