From 00579b0f77a05530a4ac705f5050944f9962eabb Mon Sep 17 00:00:00 2001
From: Kelly Rauchenberger <fefferburbia@gmail.com>
Date: Wed, 28 Mar 2018 21:12:27 -0400
Subject: Added db index for images table

---
 schema.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'schema.sql')

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

