From 06017781ae19100673fb4f8ced6da793d424dcb4 Mon Sep 17 00:00:00 2001
From: Fridolin Somers <fridolin.somers@biblibre.com>
Date: Mon, 4 May 2015 13:49:53 +0200
Subject: [PATCH] Bug 14132: suggestions table is missing indexes -
 atomicupdate

Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Sorry but removed backticks
No errors

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@gmail.com>
---
 .../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 0000000000..cd55763c05
--- /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.39.5