From 6e1167ee9e4ce2bef3c4a7f38efc362be1d750cd Mon Sep 17 00:00:00 2001 From: Ilion Beyst Date: Sun, 29 May 2022 11:41:52 +0200 Subject: save match winner in database --- .../migrations/2022-05-29-085905_add_winner_to_matches/down.sql | 3 +++ .../migrations/2022-05-29-085905_add_winner_to_matches/up.sql | 3 +++ 2 files changed, 6 insertions(+) create mode 100644 planetwars-server/migrations/2022-05-29-085905_add_winner_to_matches/down.sql create mode 100644 planetwars-server/migrations/2022-05-29-085905_add_winner_to_matches/up.sql (limited to 'planetwars-server/migrations/2022-05-29-085905_add_winner_to_matches') 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 -- cgit v1.2.3