From cbb58bc5e5ae0630f321b584bb3fe776b728318c Mon Sep 17 00:00:00 2001 From: Fridolin Somers Date: Mon, 4 May 2015 13:49:53 +0200 Subject: [PATCH] [PASSED QA] Bug 14132: suggestions table is missing indexes - atomicupdate Signed-off-by: Bernardo Gonzalez Kriegel Sorry but removed backticks No errors Signed-off-by: Kyle M Hall --- .../bug_14132-add_keys_suggestions.sql | 3 +++ 1 files changed, 3 insertions(+), 0 deletions(-) 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..cd55763 --- /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); -- 1.7.2.5