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