aboutsummaryrefslogtreecommitdiff
path: root/planetwars-server/migrations
diff options
context:
space:
mode:
Diffstat (limited to 'planetwars-server/migrations')
-rw-r--r--planetwars-server/migrations/2021-12-18-130837_bots/down.sql4
-rw-r--r--planetwars-server/migrations/2021-12-18-130837_bots/up.sql5
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