View | Details | Raw Unified | Return to bug 16731
Collapse All | Expand All

(-)a/installer/data/mysql/updatedatabase.pl (-8 / +7 lines)
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
- 

Return to bug 16731