1 files changed, 2 insertions, 0 deletions
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`);

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` (
31	`game_id` INTEGER NOT NULL,	31	`game_id` INTEGER NOT NULL,
32	`filename` VARCHAR(255) NOT NULL	32	`filename` VARCHAR(255) NOT NULL
33	);	33	);
		34
		35	CREATE INDEX `game_images` ON `images`(`game_id`,`image_id`);