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

(-)a/installer/data/mysql/updatedatabase.pl (-21 / +14 lines)
Lines 20228-20234 if( CheckVersion( $DBversion ) ) { Link Here
20228
20228
20229
$DBversion = '19.11.00.000';
20229
$DBversion = '19.11.00.000';
20230
if( CheckVersion( $DBversion ) ) {
20230
if( CheckVersion( $DBversion ) ) {
20231
    NewVersion( $DBversion, undef '19.11.00 release' );
20231
    NewVersion( $DBversion, undef, '19.11.00 release' );
20232
}
20232
}
20233
20233
20234
$DBversion = '19.12.00.000';
20234
$DBversion = '19.12.00.000';
Lines 20724-20731 if ( CheckVersion($DBversion) ) { Link Here
20724
    if ( !column_exists( 'marc_tag_structure', 'important') ){
20724
    if ( !column_exists( 'marc_tag_structure', 'important') ){
20725
        $dbh->do("ALTER TABLE marc_tag_structure ADD COLUMN important TINYINT(4) NOT NULL DEFAULT 0  AFTER mandatory");
20725
        $dbh->do("ALTER TABLE marc_tag_structure ADD COLUMN important TINYINT(4) NOT NULL DEFAULT 0  AFTER mandatory");
20726
    }
20726
    }
20727
    SetVersion($DBversion);
20727
20728
    print "Upgrade to $DBversion done (Bug 8643 - Add important constraint to marc subfields)\n";
20728
    NewVersion( $DBversion, 8643, 'Add important constraint to marc subfields' );
20729
}
20729
}
20730
20730
20731
$DBversion = '19.12.00.021';
20731
$DBversion = '19.12.00.021';
Lines 20774-20781 if( CheckVersion( $DBversion ) ) { Link Here
20774
          ( 'Lost Item Found' )
20774
          ( 'Lost Item Found' )
20775
    });
20775
    });
20776
20776
20777
    SetVersion( $DBversion );
20777
    NewVersion( $DBversion, 24592, 'Update LOST_RETURN to LOST_FOUND');
20778
    print "Upgrade to $DBversion done (Bug 24592 - Update LOST_RETURN to LOST_FOUND)\n";
20779
}
20778
}
20780
20779
20781
$DBversion = '19.12.00.022';
20780
$DBversion = '19.12.00.022';
Lines 20783-20798 if( CheckVersion( $DBversion ) ) { Link Here
20783
    $dbh->do( "ALTER TABLE items MODIFY COLUMN uri MEDIUMTEXT" );
20782
    $dbh->do( "ALTER TABLE items MODIFY COLUMN uri MEDIUMTEXT" );
20784
    $dbh->do( "ALTER TABLE deleteditems MODIFY COLUMN uri MEDIUMTEXT" );
20783
    $dbh->do( "ALTER TABLE deleteditems MODIFY COLUMN uri MEDIUMTEXT" );
20785
20784
20786
    SetVersion( $DBversion );
20785
    NewVersion( $DBversion, 20882, 'items.uri to MEDIUMTEXT');
20787
    print "Upgrade to $DBversion done (Bug 20882 - items.uri to MEDIUMTEXT)\n";
20788
}
20786
}
20789
20787
20790
$DBversion = '19.12.00.023';
20788
$DBversion = '19.12.00.023';
20791
if( CheckVersion( $DBversion ) ) {
20789
if( CheckVersion( $DBversion ) ) {
20792
    $dbh->do( "ALTER TABLE quotes MODIFY timestamp datetime NULL" );
20790
    $dbh->do( "ALTER TABLE quotes MODIFY timestamp datetime NULL" );
20793
20791
20794
    SetVersion( $DBversion );
20792
    NewVersion( $DBversion, 24640, 'Allow quotes.timestamp to be NULL');
20795
    print "Upgrade to $DBversion done (Bug 24640 - Allow quotes.timestamp to be NULL)\n";
20796
}
20793
}
20797
20794
20798
$DBversion = '19.12.00.024';
20795
$DBversion = '19.12.00.024';
Lines 20806-20813 if( CheckVersion( $DBversion ) ) { Link Here
20806
        explanation = "Choose the fines mode, 'off' (do not accrue fines) or 'production' (accrue overdue fines).  Requires accruefines cronjob or CalculateFinesOnReturn system preference."
20803
        explanation = "Choose the fines mode, 'off' (do not accrue fines) or 'production' (accrue overdue fines).  Requires accruefines cronjob or CalculateFinesOnReturn system preference."
20807
        WHERE variable = 'finesMode'
20804
        WHERE variable = 'finesMode'
20808
    });
20805
    });
20809
    SetVersion( $DBversion );
20806
20810
    print "Upgrade to $DBversion done (Bug 21633  - Remove finesMode 'test')\n";
20807
    NewVersion( $DBversion, 21633, 'Remove finesMode "test"');
20811
}
20808
}
20812
20809
20813
$DBversion = '19.12.00.025';
20810
$DBversion = '19.12.00.025';
Lines 20816-20823 if( CheckVersion( $DBversion ) ) { Link Here
20816
        INSERT IGNORE INTO `systempreferences` (variable,value,options,explanation,type)
20813
        INSERT IGNORE INTO `systempreferences` (variable,value,options,explanation,type)
20817
        VALUES ('DumpSearchQueryTemplate',0,'','Add the search query being passed to the search engine into the template for debugging','YesNo')
20814
        VALUES ('DumpSearchQueryTemplate',0,'','Add the search query being passed to the search engine into the template for debugging','YesNo')
20818
    });
20815
    });
20819
    SetVersion( $DBversion );
20816
20820
    print "Upgrade to $DBversion done (Bug 24103 - add DumpSearchQueryTemplate syspref)\n";
20817
    NewVersion( $DBversion, 24103, 'add DumpSearchQueryTemplate syspref');
20821
}
20818
}
20822
20819
20823
$DBversion = '19.12.00.026';
20820
$DBversion = '19.12.00.026';
Lines 20826-20833 if( CheckVersion( $DBversion ) ) { Link Here
20826
        $dbh->do( "ALTER TABLE z3950servers ADD COLUMN attributes VARCHAR(255) after add_xslt" );
20823
        $dbh->do( "ALTER TABLE z3950servers ADD COLUMN attributes VARCHAR(255) after add_xslt" );
20827
    }
20824
    }
20828
20825
20829
    SetVersion( $DBversion );
20826
    NewVersion( $DBversion, 11297, 'Add support for custom PQF attributes for Z39.50 server searches');
20830
    print "Upgrade to $DBversion done (Bug 11297 - Add support for custom PQF attributes for Z39.50 server searches)\n";
20831
}
20827
}
20832
20828
20833
$DBversion = '19.12.00.027';
20829
$DBversion = '19.12.00.027';
Lines 20869-20877 if( CheckVersion( $DBversion ) ) { Link Here
20869
        debit_type_code IS NOT NULL
20865
        debit_type_code IS NOT NULL
20870
    });
20866
    });
20871
20867
20872
    # Always end with this (adjust the bug info)
20868
    NewVersion( $DBversion, 24532, 'Fix pathological cases of negative debits');
20873
    SetVersion( $DBversion );
20874
    print "Upgrade to $DBversion done (Bug 24532 - Fix pathological cases of negative debits)\n";
20875
}
20869
}
20876
20870
20877
$DBversion = '19.12.00.028';
20871
$DBversion = '19.12.00.028';
Lines 20881-20888 if( CheckVersion( $DBversion ) ) { Link Here
20881
        VALUES
20875
        VALUES
20882
        ('OpacBrowseSearch', '0',NULL, "Elasticsearch only: add a page allowing users to 'browse' all items in the collection",'YesNo')
20876
        ('OpacBrowseSearch', '0',NULL, "Elasticsearch only: add a page allowing users to 'browse' all items in the collection",'YesNo')
20883
    });
20877
    });
20884
    SetVersion( $DBversion );
20878
20885
    print "Upgrade to $DBversion done (Bug 14567: Add OpacBrowseSearch syspref)\n";
20879
    NewVersion( $DBversion, 14567, 'Add OpacBrowseSearch syspref');
20886
}
20880
}
20887
20881
20888
$DBversion = '19.12.00.029';
20882
$DBversion = '19.12.00.029';
20889
- 

Return to bug 24131