2 files changed, 7 insertions, 2 deletions
diff --git a/planetwars-server/migrations/2021-12-18-130837_bots/down.sql b/planetwars-server/migrations/2021-12-18-130837_bots/down.sql
index 3d14604..a1309ff 100644
--- a/planetwars-server/migrations/2021-12-18-130837_bots/down.sql
+++ b/planetwars-server/migrations/2021-12-18-130837_bots/down.sql
@@ -1,3 +1,5 @@
+DROP INDEX code_bundles_bot_id_index;
+DROP INDEX code_bundles_created_at_index;
+
 DROP TABLE code_bundles;
-DROP INDEX bots_index;
 DROP TABLE bots;
 \ No newline at end of file
diff --git a/planetwars-server/migrations/2021-12-18-130837_bots/up.sql b/planetwars-server/migrations/2021-12-18-130837_bots/up.sql
index b158940..a1f3f59 100644
--- a/planetwars-server/migrations/2021-12-18-130837_bots/up.sql
+++ b/planetwars-server/migrations/2021-12-18-130837_bots/up.sql
@@ -9,4 +9,7 @@ CREATE TABLE code_bundles (
     bot_id integer REFERENCES bots(id),
     path text NOT NULL,
     created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
-);
-\ No newline at end of file
+);
+
+CREATE INDEX code_bundles_bot_id_index ON code_bundles(bot_id);
+CREATE INDEX code_bundles_created_at_index ON code_bundles(created_at);
+\ No newline at end of file