From a2fe50ce3936443f5794c2b33f422d504985b9f4 Mon Sep 17 00:00:00 2001 From: Fridolin Somers Date: Mon, 4 May 2015 13:49:53 +0200 Subject: [PATCH] Bug 14132 - suggestions table is missing indexes - atomicupdate --- installer/data/mysql/atomicupdate/bug_14132-add_keys_suggestions.sql | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_14132-add_keys_suggestions.sql diff --git a/installer/data/mysql/atomicupdate/bug_14132-add_keys_suggestions.sql b/installer/data/mysql/atomicupdate/bug_14132-add_keys_suggestions.sql new file mode 100644 index 0000000..2523fd7 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_14132-add_keys_suggestions.sql @@ -0,0 +1,3 @@ +ALTER IGNORE TABLE `suggestions` ADD KEY `status` (`STATUS`); +ALTER IGNORE TABLE `suggestions` ADD KEY `biblionumber` (`biblionumber`); +ALTER IGNORE TABLE `suggestions` ADD KEY `branchcode` (`branchcode`); -- 2.1.4