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