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