|
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 |
} |