1 files changed, 4 insertions, 1 deletions
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