Add a key on item_id so that our query to find missing exif records is efficient

1 files changed, 2 insertions, 1 deletions

diff --git a/modules/exif/helpers/exif_installer.php b/modules/exif/helpers/exif_installer.php
index b0173e41..7bc02a98 100644
--- a/modules/exif/helpers/exif_installer.php
+++ b/modules/exif/helpers/exif_installer.php
@@ -35,7 +35,8 @@ class exif_installer {
                    `id` int(9) NOT NULL auto_increment,
                    `item_id` int(9) NOT NULL,
                    `dirty` BOOLEAN default 1,
-                   PRIMARY KEY (`id`))
+                   PRIMARY KEY (`id`),
+                   KEY(`item_id`))
                  ENGINE=InnoDB DEFAULT CHARSET=utf8;");
       module::set_version("exif", 1);
     }