2 if( CheckVersion( $DBversion ) ) {
3 unless( column_exists( 'issues', 'note' ) ) {
4 $dbh->do(q|ALTER TABLE issues ADD note mediumtext default NULL AFTER onsite_checkout|);
6 unless( column_exists( 'issues', 'notedate' ) ) {
7 $dbh->do(q|ALTER TABLE issues ADD notedate datetime default NULL AFTER note|);
9 unless( column_exists( 'old_issues', 'note' ) ) {
10 $dbh->do(q|ALTER TABLE old_issues ADD note mediumtext default NULL AFTER onsite_checkout|);
12 unless( column_exists( 'old_issues', 'notedate' ) ) {
13 $dbh->do(q|ALTER TABLE old_issues ADD notedate datetime default NULL AFTER note|);
16 SetVersion( $DBversion );
17 print "Upgrade to $DBversion done (Bug 14224: Add column issues.note and issues.notedate)\n";