From 8a47b948eb88f1e0ff649880a70f9416306bac92 Mon Sep 17 00:00:00 2001 From: Ilion Beyst 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 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