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

(-)a/installer/data/mysql/updatedatabase.pl (-63 lines)
Lines 9005-9072 if ( CheckVersion($DBversion) ) { Link Here
9005
    SetVersion($DBversion);
9005
    SetVersion($DBversion);
9006
}
9006
}
9007
9007
9008
$DBversion = "3.17.00.036";
9009
if ( CheckVersion($DBversion) ) {
9010
    $dbh->do("DELETE FROM systempreferences WHERE variable='OpacShowLibrariesPulldownMobile'");
9011
    print "Upgrade to $DBversion done ( Bug 12513 - PROG/CCSR deprecation: Remove OpacShowLibrariesPulldownMobile system preference )\n";
9012
    SetVersion ($DBversion);
9013
}
9014
9015
$DBversion = "3.17.00.037";
9016
if ( CheckVersion($DBversion) ) {
9017
    $dbh->do("DELETE FROM systempreferences WHERE variable='OpacMainUserBlockMobile'");
9018
    print "Upgrade to $DBversion done ( Bug 12246 - PROG/CCSR deprecation: Remove OpacMainUserBlockMobile system preference )\n";
9019
    SetVersion ($DBversion);
9020
}
9021
9022
$DBversion = "3.17.00.038";
9023
if ( CheckVersion($DBversion) ) {
9024
    $dbh->do("DELETE FROM systempreferences WHERE variable='OPACMobileUserCSS'");
9025
    print "Upgrade to $DBversion done ( Bug 12245 - PROG/CCSR deprecation: Remove OPACMobileUserCSS system preference )\n";
9026
    SetVersion ($DBversion);
9027
}
9028
9029
$DBversion = "3.17.00.039";
9030
if ( CheckVersion($DBversion) ) {
9031
    $dbh->do("INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type) VALUES
9032
    ('OPACFallback', 'prog', 'bootstrap|prog', 'Define the fallback theme for the OPAC interface.', 'Themes')");
9033
    print "Upgrade to $DBversion done (Bug 12539 - PROG/CCSR deprecation: Remove hardcoded theme from C4/Templates.pm)\n";
9034
    SetVersion ($DBversion);
9035
}
9036
9037
$DBversion = "3.17.00.040";
9038
if ( CheckVersion($DBversion) ) {
9039
    my $opac_theme = C4::Context->preference( 'opacthemes' );
9040
    if ( $opac_theme eq 'prog' || $opac_theme eq 'ccsr' ) {
9041
        $dbh->do("UPDATE systempreferences SET value='bootstrap' WHERE variable='opacthemes'");
9042
    }
9043
    print "Upgrade to $DBversion done (Bug 12223: 'prog' and 'ccsr' themes removed)\n";
9044
    SetVersion($DBversion);
9045
}
9046
9047
$DBversion = "3.17.00.041";
9048
if ( CheckVersion($DBversion) ) {
9049
    print "Upgrade to $DBversion done (Bug 11346: Deprecate the 'prog' and 'CCSR' themes)\n";
9050
    SetVersion($DBversion);
9051
}
9052
9053
$DBversion = "3.17.00.042";
9054
if ( CheckVersion($DBversion) ) {
9055
    $dbh->do("DELETE FROM systempreferences WHERE variable='yuipath'");
9056
    print "Upgrade to $DBversion done (Bug 12494: Remove yuipath system preference)\n";
9057
    SetVersion ($DBversion);
9058
}
9059
9060
$DBversion = "3.17.00.043";
9061
if ( CheckVersion($DBversion) ) {
9062
    $dbh->do("
9063
        ALTER TABLE aqorders
9064
        ADD COLUMN cancellationreason TEXT DEFAULT NULL AFTER datecancellationprinted
9065
    ");
9066
    print "Upgrade to $DBversion done (Bug 7162: Add aqorders.cancellationreason)\n";
9067
    SetVersion ($DBversion);
9068
}
9069
9070
$DBversion = "3.17.00.XXX";
9008
$DBversion = "3.17.00.XXX";
9071
if ( CheckVersion($DBversion) ) {
9009
if ( CheckVersion($DBversion) ) {
9072
    $dbh->do(q{
9010
    $dbh->do(q{
9073
- 

Return to bug 8836