aboutsummaryrefslogtreecommitdiff
path: root/planetwars-server/migrations
diff options
context:
space:
mode:
Diffstat (limited to 'planetwars-server/migrations')
-rw-r--r--planetwars-server/migrations/2022-05-29-085905_add_winner_to_matches/down.sql3
-rw-r--r--planetwars-server/migrations/2022-05-29-085905_add_winner_to_matches/up.sql3
2 files changed, 6 insertions, 0 deletions
diff --git a/planetwars-server/migrations/2022-05-29-085905_add_winner_to_matches/down.sql b/planetwars-server/migrations/2022-05-29-085905_add_winner_to_matches/down.sql
new file mode 100644
index 0000000..1deada2
--- /dev/null
+++ b/planetwars-server/migrations/2022-05-29-085905_add_winner_to_matches/down.sql
@@ -0,0 +1,3 @@
+-- This file should undo anything in `up.sql`
+ALTER TABLE matches
+DROP column winner; \ No newline at end of file
diff --git a/planetwars-server/migrations/2022-05-29-085905_add_winner_to_matches/up.sql b/planetwars-server/migrations/2022-05-29-085905_add_winner_to_matches/up.sql
new file mode 100644
index 0000000..6212ebd
--- /dev/null
+++ b/planetwars-server/migrations/2022-05-29-085905_add_winner_to_matches/up.sql
@@ -0,0 +1,3 @@
+-- Your SQL goes here
+ALTER TABLE matches
+ADD COLUMN winner integer; \ No newline at end of file