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