From f51765a4b25ae66e0554e72f9342724313a6c3b6 Mon Sep 17 00:00:00 2001 From: Bharat Mediratta Date: Sat, 25 Apr 2009 22:17:06 +0000 Subject: Drop the item_id key; we don't need this level of strictness in most cases and it slows down inserts. --- modules/exif/helpers/exif_installer.php | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) (limited to 'modules/exif/helpers/exif_installer.php') diff --git a/modules/exif/helpers/exif_installer.php b/modules/exif/helpers/exif_installer.php index 595433e5..ae95ef3e 100644 --- a/modules/exif/helpers/exif_installer.php +++ b/modules/exif/helpers/exif_installer.php @@ -31,8 +31,7 @@ class exif_installer { `item_id` int(9) NOT NULL, `name` varchar(64) NOT NULL, `value` varbinary(1024) NOT NULL, - PRIMARY KEY (`id`), - UNIQUE KEY(`item_id`, `name`)) + PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;"); $db->query("CREATE TABLE IF NOT EXISTS {exif_records} ( `id` int(9) NOT NULL auto_increment, -- cgit v1.2.3