From dc190d3cf4142df9371ac07779325b58d16632dc Mon Sep 17 00:00:00 2001 From: Fridolin Somers Date: Mon, 4 May 2015 13:49:53 +0200 Subject: [PATCH] [SIGNED-OFF] Bug 14132: suggestions table is missing indexes - atomicupdate Signed-off-by: Bernardo Gonzalez Kriegel Sorry but removed backticks No errors --- .../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..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.9.5