|
Lines 21-27
return {
Link Here
|
| 21 |
} |
21 |
} |
| 22 |
say $out "item_bundles table added"; |
22 |
say $out "item_bundles table added"; |
| 23 |
|
23 |
|
| 24 |
my ($lost_val) = $dbh->selectrow_array( "SELECT MAX(authorised_value) FROM authorised_values WHERE category = 'LOST'", {} ); |
24 |
my ($lost_val) = $dbh->selectrow_array( "SELECT MAX(CAST(authorised_value AS SIGNED)) FROM authorised_values WHERE category = 'LOST'", {} ); |
| 25 |
$lost_val++; |
25 |
$lost_val++; |
| 26 |
|
26 |
|
| 27 |
$dbh->do(qq{ |
27 |
$dbh->do(qq{ |
|
Lines 29-35
return {
Link Here
|
| 29 |
}); |
29 |
}); |
| 30 |
say $out "Missing from bundle LOST AV added"; |
30 |
say $out "Missing from bundle LOST AV added"; |
| 31 |
|
31 |
|
| 32 |
my ($nfl_val) = $dbh->selectrow_array( "SELECT MAX(authorised_value) FROM authorised_values WHERE category = 'NOT_LOAN'", {} ); |
32 |
my ($nfl_val) = $dbh->selectrow_array( "SELECT MAX(CAST(authorised_value AS SIGNED)) FROM authorised_values WHERE category = 'NOT_LOAN'", {} ); |
| 33 |
$nfl_val++; |
33 |
$nfl_val++; |
| 34 |
|
34 |
|
| 35 |
$dbh->do(qq{ |
35 |
$dbh->do(qq{ |
| 36 |
- |
|
|