Bugzilla – Attachment 110735 Details for
Bug 26535
Remove issues old_issues redundant indexes
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 26535: Remove issues tables redundant indexes
Bug-26535-Remove-issues-tables-redundant-indexes.patch (text/plain), 1.64 KB, created by
Didier Gautheron
on 2020-09-25 09:44:13 UTC
(
hide
)
Description:
Bug 26535: Remove issues tables redundant indexes
Filename:
MIME Type:
Creator:
Didier Gautheron
Created:
2020-09-25 09:44:13 UTC
Size:
1.64 KB
patch
obsolete
>From c3a0faa7ce03f55834d7ea6adfe9c8560f0d6f22 Mon Sep 17 00:00:00 2001 >From: Didier Gautheron <didier.gautheron@biblibre.com> >Date: Fri, 25 Sep 2020 11:43:08 +0200 >Subject: [PATCH] Bug 26535: Remove issues tables redundant indexes > >--- > installer/data/mysql/kohastructure.sql | 3 --- > 1 file changed, 3 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 08cc35dcd6..19f70d0987 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -1635,8 +1635,6 @@ CREATE TABLE `issues` ( -- information related to check outs or issues > `noteseen` int(1) default NULL, -- describes whether checkout note has been seen 1, not been seen 0 or doesn't exist null > PRIMARY KEY (`issue_id`), > UNIQUE KEY `itemnumber` (`itemnumber`), >- KEY `issuesborridx` (`borrowernumber`), >- KEY `itemnumber_idx` (`itemnumber`), > KEY `branchcode_idx` (`branchcode`), > KEY `bordate` (`borrowernumber`,`timestamp`), > CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE RESTRICT ON UPDATE CASCADE, >@@ -1666,7 +1664,6 @@ CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r > `notedate` datetime default NULL, -- datetime of issue note (yyyy-mm-dd hh:mm::ss) > `noteseen` int(1) default NULL, -- describes whether checkout note has been seen 1, not been seen 0 or doesn't exist null > PRIMARY KEY (`issue_id`), >- KEY `old_issuesborridx` (`borrowernumber`), > KEY `old_issuesitemidx` (`itemnumber`), > KEY `branchcode_idx` (`branchcode`), > KEY `old_bordate` (`borrowernumber`,`timestamp`), >-- >2.11.0
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 26535
: 110735