Bugzilla – Attachment 38842 Details for
Bug 14132
suggestions table is missing indexes
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 14132 - suggestions table is missing indexes - atomicupdate
Bug-14132---suggestions-table-is-missing-indexes--.patch (text/plain), 969 bytes, created by
Fridolin Somers
on 2015-05-05 07:38:08 UTC
(
hide
)
Description:
Bug 14132 - suggestions table is missing indexes - atomicupdate
Filename:
MIME Type:
Creator:
Fridolin Somers
Created:
2015-05-05 07:38:08 UTC
Size:
969 bytes
patch
obsolete
>From a2fe50ce3936443f5794c2b33f422d504985b9f4 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 > >--- > 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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 14132
:
38806
|
38807
|
38841
|
38842
|
38937
|
38938
|
38975
|
38976