From 567f9891ada9ff5ea89acc213c73d1df566dce31 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 | 4 ++++ 1 file changed, 4 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..1383190 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_14132-add_keys_suggestions.sql @@ -0,0 +1,4 @@ +ALTER TABLE `suggestions` + ADD KEY `status` (`STATUS`), + ADD KEY `biblionumber` (`biblionumber`), + ADD KEY `branchcode` (`branchcode`); -- 2.1.4