View | Details | Raw Unified | Return to bug 18861
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_18861.sql (+2 lines)
Line 0 Link Here
1
ALTER TABLE branch_transfer_limits ADD KEY `itemtype_idx` (`itemtype`,`fromBranch`,`toBranch`);
2
ALTER TABLE branch_transfer_limits ADD KEY `ccode_idx` (`ccode`,`fromBranch`, `toBranch`);
(-)a/installer/data/mysql/kohastructure.sql (-2 / +3 lines)
Lines 2667-2673 CREATE TABLE branch_transfer_limits ( Link Here
2667
    fromBranch varchar(10) NOT NULL,
2667
    fromBranch varchar(10) NOT NULL,
2668
    itemtype varchar(10) NULL,
2668
    itemtype varchar(10) NULL,
2669
    ccode varchar(10) NULL,
2669
    ccode varchar(10) NULL,
2670
    PRIMARY KEY  (limitId)
2670
    PRIMARY KEY  (limitId),
2671
    KEY `itemtype_idx` (`itemtype`,`fromBranch`,`toBranch`),
2672
    KEY `ccode_idx` (`ccode`,`fromBranch`, `toBranch`)
2671
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2673
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2672
2674
2673
--
2675
--
2674
- 

Return to bug 18861