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

(-)a/installer/data/mysql/atomicupdate/bz_33488.pl (+15 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => "33488",
5
    description => "Add index to fromBranch for branch_transfer_limits",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        # Do you stuffs here
10
        unless ( index_exists( 'branch_transfer_limits', 'fromBranch_idx' ) ) {
11
            $dbh->do(q{CREATE INDEX fromBranch_idx ON branch_transfer_limits ( fromBranch )});
12
            say $out "Added new index on branch_transfer_limits.fromBranch";
13
        }
14
    },
15
};
(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 1510-1516 CREATE TABLE `branch_transfer_limits` ( Link Here
1510
  `fromBranch` varchar(10) NOT NULL,
1510
  `fromBranch` varchar(10) NOT NULL,
1511
  `itemtype` varchar(10) DEFAULT NULL,
1511
  `itemtype` varchar(10) DEFAULT NULL,
1512
  `ccode` varchar(80) DEFAULT NULL,
1512
  `ccode` varchar(80) DEFAULT NULL,
1513
  PRIMARY KEY (`limitId`)
1513
  PRIMARY KEY (`limitId`),
1514
  KEY `fromBranch_index` (`fromBranch`)
1514
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1515
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1515
/*!40101 SET character_set_client = @saved_cs_client */;
1516
/*!40101 SET character_set_client = @saved_cs_client */;
1516
1517
1517
- 

Return to bug 33488