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 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
# SEE bug 13068
20883
# SEE bug 13068
20890
- 

Return to bug 24131