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

(-)a/installer/data/mysql/atomicupdate/bug_14224-add_new_issue_columns.perl (+18 lines)
Line 0 Link Here
1
$DBversion = 'XXX';
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|);
5
    }
6
    unless( column_exists( 'issues', 'notedate' ) ) {
7
        $dbh->do(q|ALTER TABLE issues ADD notedate datetime default NULL AFTER note|);
8
    }
9
    unless( column_exists( 'old_issues', 'note' ) ) {
10
        $dbh->do(q|ALTER TABLE old_issues ADD note mediumtext default NULL AFTER onsite_checkout|);
11
    }
12
    unless( column_exists( 'old_issues', 'notedate' ) ) {
13
        $dbh->do(q|ALTER TABLE old_issues ADD notedate datetime default NULL AFTER note|);
14
    }
15
16
    SetVersion( $DBversion );
17
    print "Upgrade to $DBversion done (Bug 14224: Add column issues.note and issues.notedate)\n";
18
}
(-)a/installer/data/mysql/atomicupdate/bug_14224-add_new_issue_columns.sql (-5 lines)
Lines 1-4 Link Here
1
ALTER IGNORE TABLE issues ADD `note` mediumtext default NULL AFTER `onsite_checkout`;
2
ALTER IGNORE TABLE issues ADD `notedate` datetime default NULL AFTER `note`;
3
ALTER IGNORE TABLE old_issues ADD `note` mediumtext default NULL AFTER `onsite_checkout`;
4
ALTER IGNORE TABLE old_issues ADD `notedate` datetime default NULL AFTER `note`;
5
- 

Return to bug 14224