Line 0
Link Here
|
|
|
1 |
$DBversion = 'XXX'; |
2 |
if( CheckVersion( $DBversion ) ) { |
3 |
unless ( index_exists( 'branch_transfer_limits', 'itemtype_idx' ) ) { |
4 |
$dbh->do(q| |
5 |
ALTER TABLE branch_transfer_limits ADD KEY `itemtype_idx` (`itemtype`,`fromBranch`,`toBranch`); |
6 |
|); |
7 |
} |
8 |
unless ( index_exists( 'branch_transfer_limits', 'ccode_idx' ) ) { |
9 |
$dbh->do(q| |
10 |
ALTER TABLE branch_transfer_limits ADD KEY `ccode_idx` (`ccode`,`fromBranch`, `toBranch`); |
11 |
|); |
12 |
} |
13 |
NewVersion( $DBversion, 18861, "Add indexes for ccode and itemtype to branch_transfer_limits"); |
14 |
} |