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 1523-1529 CREATE TABLE `branch_transfer_limits` ( Link Here
1523
  `fromBranch` varchar(10) NOT NULL,
1523
  `fromBranch` varchar(10) NOT NULL,
1524
  `itemtype` varchar(10) DEFAULT NULL,
1524
  `itemtype` varchar(10) DEFAULT NULL,
1525
  `ccode` varchar(80) DEFAULT NULL,
1525
  `ccode` varchar(80) DEFAULT NULL,
1526
  PRIMARY KEY (`limitId`)
1526
  PRIMARY KEY (`limitId`),
1527
  KEY `fromBranch_index` (`fromBranch`)
1527
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1528
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1528
/*!40101 SET character_set_client = @saved_cs_client */;
1529
/*!40101 SET character_set_client = @saved_cs_client */;
1529
1530
1530
- 

Return to bug 33488