summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBharat Mediratta <bharat@menalto.com>2009-04-25 22:17:06 +0000
committerBharat Mediratta <bharat@menalto.com>2009-04-25 22:17:06 +0000
commitf51765a4b25ae66e0554e72f9342724313a6c3b6 (patch)
tree31f9b26ced13c3966a5a06a73176278782b2d453
parentbab514a48df6b7c4f1044580ff8eb1dc4b0e8100 (diff)
Drop the item_id key; we don't need this level of strictness in most
cases and it slows down inserts.
-rw-r--r--modules/exif/helpers/exif_installer.php3
1 files changed, 1 insertions, 2 deletions
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,