From da3d7ed02d995794d5c8aab2563e4d0f53d33416 Mon Sep 17 00:00:00 2001
From: Ilion Beyst <ilion.beyst@gmail.com>
Date: Sun, 27 Feb 2022 22:58:11 +0100
Subject: create code bundle indices

---
 planetwars-server/migrations/2021-12-18-130837_bots/up.sql | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

(limited to 'planetwars-server/migrations/2021-12-18-130837_bots/up.sql')

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

