aboutsummaryrefslogtreecommitdiff
path: root/planetwars-server/migrations/2022-07-04-200149_code_bundle_to_bot_version/down.sql
diff options
context:
space:
mode:
Diffstat (limited to 'planetwars-server/migrations/2022-07-04-200149_code_bundle_to_bot_version/down.sql')
-rw-r--r--planetwars-server/migrations/2022-07-04-200149_code_bundle_to_bot_version/down.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/planetwars-server/migrations/2022-07-04-200149_code_bundle_to_bot_version/down.sql b/planetwars-server/migrations/2022-07-04-200149_code_bundle_to_bot_version/down.sql
index bc2d7d6..89058fe 100644
--- a/planetwars-server/migrations/2022-07-04-200149_code_bundle_to_bot_version/down.sql
+++ b/planetwars-server/migrations/2022-07-04-200149_code_bundle_to_bot_version/down.sql
@@ -1,4 +1,6 @@
+ALTER TABLE match_players RENAME COLUMN bot_version_id TO code_bundle_id;
+
ALTER TABLE bot_versions DROP COLUMN container_digest;
-ALTER TABLE bot_versions RENAME COLUMN code_bundle_path to path;
+ALTER TABLE bot_versions RENAME COLUMN code_bundle_path TO path;
ALTER TABLE bot_versions ALTER COLUMN path SET NOT NULL;
ALTER TABLE bot_versions RENAME TO code_bundles;