Lines 11628-11634
if ( CheckVersion($DBversion) ) {
Link Here
|
11628 |
$DBversion = "3.23.00.012"; |
11628 |
$DBversion = "3.23.00.012"; |
11629 |
if ( CheckVersion($DBversion) ) { |
11629 |
if ( CheckVersion($DBversion) ) { |
11630 |
$dbh->do(q{ |
11630 |
$dbh->do(q{ |
11631 |
INSERT IGNORE INTO systempreferences ( `variable`, `value`, `explanation`, `options`, `type` ) VALUES('MaxSearchResultsItemsPerRecordStatusCheck','20','Max number of items per record for which to check transit and hold status','','Integer') |
11631 |
INSERT IGNORE INTO systempreferences ( `variable`, `value`, `explanation`, `options`, `type` ) VALUES('MaxSearchResultsItemsPerRecordStatusCheck','20','Max number of items per record for which to check transit and hold status','','Integer') |
11632 |
}); |
11632 |
}); |
11633 |
|
11633 |
|
11634 |
print "Upgrade to $DBversion done (Bug 15380 - Move the authority types related code to Koha::Authority::Type[s] - part 1)\n"; |
11634 |
print "Upgrade to $DBversion done (Bug 15380 - Move the authority types related code to Koha::Authority::Type[s] - part 1)\n"; |
Lines 11638-11644
if ( CheckVersion($DBversion) ) {
Link Here
|
11638 |
$DBversion = "3.23.00.013"; |
11638 |
$DBversion = "3.23.00.013"; |
11639 |
if ( CheckVersion($DBversion) ) { |
11639 |
if ( CheckVersion($DBversion) ) { |
11640 |
$dbh->do(q{ |
11640 |
$dbh->do(q{ |
11641 |
INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES ('StoreLastBorrower','0','','If ON, the last borrower to return an item will be stored in items.last_returned_by','YesNo') |
11641 |
INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES ('StoreLastBorrower','0','','If ON, the last borrower to return an item will be stored in items.last_returned_by','YesNo') |
11642 |
}); |
11642 |
}); |
11643 |
$dbh->do(q{ |
11643 |
$dbh->do(q{ |
11644 |
CREATE TABLE IF NOT EXISTS `items_last_borrower` ( |
11644 |
CREATE TABLE IF NOT EXISTS `items_last_borrower` ( |
Lines 11662-11668
if ( CheckVersion($DBversion) ) {
Link Here
|
11662 |
$DBversion = "3.23.00.014"; |
11662 |
$DBversion = "3.23.00.014"; |
11663 |
if ( CheckVersion($DBversion) ) { |
11663 |
if ( CheckVersion($DBversion) ) { |
11664 |
$dbh->do(q{ |
11664 |
$dbh->do(q{ |
11665 |
INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) |
11665 |
INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) |
11666 |
VALUES ('ClaimsBccCopy','0','','Bcc the ClaimAcquisition and ClaimIssues alerts','YesNo') |
11666 |
VALUES ('ClaimsBccCopy','0','','Bcc the ClaimAcquisition and ClaimIssues alerts','YesNo') |
11667 |
}); |
11667 |
}); |
11668 |
|
11668 |
|
Lines 11972-11978
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
Link Here
|
11972 |
$DBversion = "3.23.00.036"; |
11972 |
$DBversion = "3.23.00.036"; |
11973 |
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { |
11973 |
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { |
11974 |
$dbh->do(q{ |
11974 |
$dbh->do(q{ |
11975 |
INSERT INTO systempreferences (variable,value,explanation,type) VALUES ('HoldsQueueSkipClosed', '0', 'If enabled, any libraries that are closed when the holds queue is built will be ignored for the purpose of filling holds.', 'YesNo'); |
11975 |
INSERT IGNORE INTO systempreferences (variable,value,explanation,type) VALUES ('HoldsQueueSkipClosed', '0', 'If enabled, any libraries that are closed when the holds queue is built will be ignored for the purpose of filling holds.', 'YesNo'); |
11976 |
}); |
11976 |
}); |
11977 |
print "Upgrade to $DBversion done (Bug 12803 - Add ability to skip closed libraries when generating the holds queue)\n"; |
11977 |
print "Upgrade to $DBversion done (Bug 12803 - Add ability to skip closed libraries when generating the holds queue)\n"; |
11978 |
SetVersion($DBversion); |
11978 |
SetVersion($DBversion); |
Lines 12006-12012
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
Link Here
|
12006 |
$DBversion = "3.23.00.038"; |
12006 |
$DBversion = "3.23.00.038"; |
12007 |
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { |
12007 |
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { |
12008 |
$dbh->do(q{ |
12008 |
$dbh->do(q{ |
12009 |
INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES ('decreaseLoanHighHoldsControl', 'static', 'static|dynamic', "Chooses between static and dynamic high holds checking", 'Choice'), ('decreaseLoanHighHoldsIgnoreStatuses', '', 'damaged|itemlost|notforloan|withdrawn', "Ignore items with these statuses for dynamic high holds checking", 'Choice'); |
12009 |
INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES ('decreaseLoanHighHoldsControl', 'static', 'static|dynamic', "Chooses between static and dynamic high holds checking", 'Choice'), ('decreaseLoanHighHoldsIgnoreStatuses', '', 'damaged|itemlost|notforloan|withdrawn', "Ignore items with these statuses for dynamic high holds checking", 'Choice'); |
12010 |
}); |
12010 |
}); |
12011 |
print "Upgrade to $DBversion done (Bug 14694 - Make decreaseloanHighHolds more flexible)\n"; |
12011 |
print "Upgrade to $DBversion done (Bug 14694 - Make decreaseloanHighHolds more flexible)\n"; |
12012 |
SetVersion($DBversion); |
12012 |
SetVersion($DBversion); |
Lines 12085-12091
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
Link Here
|
12085 |
$DBversion = "3.23.00.044"; |
12085 |
$DBversion = "3.23.00.044"; |
12086 |
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { |
12086 |
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { |
12087 |
$dbh->do(q{ |
12087 |
$dbh->do(q{ |
12088 |
INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES |
12088 |
INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES |
12089 |
('GoogleOpenIDConnect', '0', NULL, 'if ON, allows the use of Google OpenID Connect for login', 'YesNo'), |
12089 |
('GoogleOpenIDConnect', '0', NULL, 'if ON, allows the use of Google OpenID Connect for login', 'YesNo'), |
12090 |
('GoogleOAuth2ClientID', '', NULL, 'Client ID for the web app registered with Google', 'Free'), |
12090 |
('GoogleOAuth2ClientID', '', NULL, 'Client ID for the web app registered with Google', 'Free'), |
12091 |
('GoogleOAuth2ClientSecret', '', NULL, 'Client Secret for the web app registered with Google', 'Free'), |
12091 |
('GoogleOAuth2ClientSecret', '', NULL, 'Client Secret for the web app registered with Google', 'Free'), |
Lines 12473-12479
if ( CheckVersion($DBversion) ) {
Link Here
|
12473 |
$DBversion = "3.23.00.056"; |
12473 |
$DBversion = "3.23.00.056"; |
12474 |
if ( CheckVersion($DBversion) ) { |
12474 |
if ( CheckVersion($DBversion) ) { |
12475 |
$dbh->do(q{ |
12475 |
$dbh->do(q{ |
12476 |
INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES |
12476 |
INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES |
12477 |
('NoIssuesChargeGuarantees','','','Define maximum amount withstanding before check outs are blocked','Integer'); |
12477 |
('NoIssuesChargeGuarantees','','','Define maximum amount withstanding before check outs are blocked','Integer'); |
12478 |
}); |
12478 |
}); |
12479 |
|
12479 |
|
12480 |
- |
|
|