Attachment #99317 for bug #24131

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





$DBversion = '19.11.00.000';
if( CheckVersion( $DBversion ) ) {
    NewVersion( $DBversion, undef, '19.11.00 release' );
}

$DBversion = '19.12.00.000';

    if ( !column_exists( 'marc_tag_structure', 'important') ){
        $dbh->do("ALTER TABLE marc_tag_structure ADD COLUMN important TINYINT(4) NOT NULL DEFAULT 0  AFTER mandatory");
    }

    NewVersion( $DBversion, 8643, 'Add important constraint to marc subfields' );
}

$DBversion = '19.12.00.021';

          ( 'Lost Item Found' )
    });

    NewVersion( $DBversion, 24592, 'Update LOST_RETURN to LOST_FOUND');
    print "Upgrade to $DBversion done (Bug 24592 - Update LOST_RETURN to LOST_FOUND)\n";
}

$DBversion = '19.12.00.022';

    $dbh->do( "ALTER TABLE items MODIFY COLUMN uri MEDIUMTEXT" );
    $dbh->do( "ALTER TABLE deleteditems MODIFY COLUMN uri MEDIUMTEXT" );

    NewVersion( $DBversion, 20882, 'items.uri to MEDIUMTEXT');
    print "Upgrade to $DBversion done (Bug 20882 - items.uri to MEDIUMTEXT)\n";
}

$DBversion = '19.12.00.023';
if( CheckVersion( $DBversion ) ) {
    $dbh->do( "ALTER TABLE quotes MODIFY timestamp datetime NULL" );

    NewVersion( $DBversion, 24640, 'Allow quotes.timestamp to be NULL');
    print "Upgrade to $DBversion done (Bug 24640 - Allow quotes.timestamp to be NULL)\n";
}

$DBversion = '19.12.00.024';

        explanation = "Choose the fines mode, 'off' (do not accrue fines) or 'production' (accrue overdue fines).  Requires accruefines cronjob or CalculateFinesOnReturn system preference."
        WHERE variable = 'finesMode'
    });

    NewVersion( $DBversion, 21633, 'Remove finesMode "test"');
}

$DBversion = '19.12.00.025';

        INSERT IGNORE INTO `systempreferences` (variable,value,options,explanation,type)
        VALUES ('DumpSearchQueryTemplate',0,'','Add the search query being passed to the search engine into the template for debugging','YesNo')
    });

    NewVersion( $DBversion, 24103, 'add DumpSearchQueryTemplate syspref');
}

$DBversion = '19.12.00.026';

        $dbh->do( "ALTER TABLE z3950servers ADD COLUMN attributes VARCHAR(255) after add_xslt" );
    }

    NewVersion( $DBversion, 11297, 'Add support for custom PQF attributes for Z39.50 server searches');
    print "Upgrade to $DBversion done (Bug 11297 - Add support for custom PQF attributes for Z39.50 server searches)\n";
}

$DBversion = '19.12.00.027';

        debit_type_code IS NOT NULL
    });

    NewVersion( $DBversion, 24532, 'Fix pathological cases of negative debits');
    SetVersion( $DBversion );
    print "Upgrade to $DBversion done (Bug 24532 - Fix pathological cases of negative debits)\n";
}

$DBversion = '19.12.00.028';

        VALUES
        ('OpacBrowseSearch', '0',NULL, "Elasticsearch only: add a page allowing users to 'browse' all items in the collection",'YesNo')
    });

    NewVersion( $DBversion, 14567, 'Add OpacBrowseSearch syspref');
}

# SEE bug 13068
- 

Return to bug 24131

Lines 20228-20234 if( CheckVersion( $DBversion ) ) { Link Here

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