From 63ce71a32b32873e2d48fe1ff4f0928d44bd15ef Mon Sep 17 00:00:00 2001 From: Bharat Mediratta Date: Sat, 25 Apr 2009 06:52:44 +0000 Subject: Add a key on item_id so that our query to find missing exif records is efficient --- modules/exif/helpers/exif_installer.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'modules/exif/helpers') 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); } -- cgit v1.2.3