From c3a0faa7ce03f55834d7ea6adfe9c8560f0d6f22 Mon Sep 17 00:00:00 2001 From: Didier Gautheron 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