From 00579b0f77a05530a4ac705f5050944f9962eabb Mon Sep 17 00:00:00 2001 From: Kelly Rauchenberger Date: Wed, 28 Mar 2018 21:12:27 -0400 Subject: Added db index for images table --- schema.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/schema.sql b/schema.sql index c4724f8..373bd55 100644 --- a/schema.sql +++ b/schema.sql @@ -31,3 +31,5 @@ CREATE TABLE `images` ( `game_id` INTEGER NOT NULL, `filename` VARCHAR(255) NOT NULL ); + +CREATE INDEX `game_images` ON `images`(`game_id`,`image_id`); -- cgit 1.4.1