From 8a47b948eb88f1e0ff649880a70f9416306bac92 Mon Sep 17 00:00:00 2001
From: Ilion Beyst <ilion.beyst@gmail.com>
Date: Tue, 5 Jul 2022 20:33:39 +0200
Subject: migrate code_bundles to bot_versions

---
 .../migrations/2022-07-04-200149_code_bundle_to_bot_version/down.sql  | 4 ++++
 1 file changed, 4 insertions(+)
 create mode 100644 planetwars-server/migrations/2022-07-04-200149_code_bundle_to_bot_version/down.sql

(limited to 'planetwars-server/migrations/2022-07-04-200149_code_bundle_to_bot_version/down.sql')

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
new file mode 100644
index 0000000..bc2d7d6
--- /dev/null
+++ b/planetwars-server/migrations/2022-07-04-200149_code_bundle_to_bot_version/down.sql
@@ -0,0 +1,4 @@
+ALTER TABLE bot_versions DROP COLUMN container_digest;
+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;
-- 
cgit v1.2.3


From d7b7585dd70f9d41184cf88c2ecbd88341898c38 Mon Sep 17 00:00:00 2001
From: Ilion Beyst <ilion.beyst@gmail.com>
Date: Wed, 6 Jul 2022 22:41:27 +0200
Subject: rename code_bundle to bot_version

---
 .../migrations/2022-07-04-200149_code_bundle_to_bot_version/down.sql  | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'planetwars-server/migrations/2022-07-04-200149_code_bundle_to_bot_version/down.sql')

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;
-- 
cgit v1.2.3

