aboutsummaryrefslogtreecommitdiff
path: root/planetwars-server/migrations/2022-05-29-085905_add_winner_to_matches
diff options
context:
space:
mode:
authorIlion Beyst <ilion.beyst@gmail.com>2022-05-29 11:41:52 +0200
committerIlion Beyst <ilion.beyst@gmail.com>2022-05-29 11:41:52 +0200
commit6e1167ee9e4ce2bef3c4a7f38efc362be1d750cd (patch)
treee50eef4b59704f552158829793c745fe90452bff /planetwars-server/migrations/2022-05-29-085905_add_winner_to_matches
parent80c60ac69c9b0d86a4536eeac82cf266eb4430bc (diff)
downloadplanetwars.dev-6e1167ee9e4ce2bef3c4a7f38efc362be1d750cd.tar.xz
planetwars.dev-6e1167ee9e4ce2bef3c4a7f38efc362be1d750cd.zip
save match winner in database
Diffstat (limited to 'planetwars-server/migrations/2022-05-29-085905_add_winner_to_matches')
-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