@@ -, +, @@ - Go to Administration > Library transfer limits - Check page load is faster - Uncheck a checkbox - Save - Change branch and same tests --- installer/data/mysql/atomicupdate/bug_18861.sql | 2 ++ installer/data/mysql/kohastructure.sql | 4 +++- 2 files changed, 5 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_18861.sql --- a/installer/data/mysql/atomicupdate/bug_18861.sql +++ a/installer/data/mysql/atomicupdate/bug_18861.sql @@ -0,0 +1,2 @@ +ALTER TABLE branch_transfer_limits ADD KEY `itemtype_idx` (`itemtype`,`fromBranch`,`toBranch`); +ALTER TABLE branch_transfer_limits ADD KEY `ccode_idx` (`ccode`,`fromBranch`, `toBranch`); --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -2667,7 +2667,9 @@ CREATE TABLE branch_transfer_limits ( fromBranch varchar(10) NOT NULL, itemtype varchar(10) NULL, ccode varchar(10) NULL, - PRIMARY KEY (limitId) + PRIMARY KEY (limitId), + KEY `itemtype_idx` (`itemtype`,`fromBranch`,`toBranch`), + KEY `ccode_idx` (`ccode`,`fromBranch`, `toBranch`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- --