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

(-)a/installer/data/mysql/atomicupdate/bug_20472a.perl (-6 / +12 lines)
Lines 1-9 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do(q|
3
    unless ( column_exists('article_requests', 'format') ) {
4
        ALTER TABLE article_requests
4
        $dbh->do(q|
5
        ADD COLUMN `format` enum('PHOTOCOPY', 'SCAN') NOT NULL DEFAULT 'PHOTOCOPY' AFTER notes,
5
            ALTER TABLE article_requests
6
        ADD COLUMN `urls` MEDIUMTEXT AFTER format
6
            ADD COLUMN `format` enum('PHOTOCOPY', 'SCAN') NOT NULL DEFAULT 'PHOTOCOPY' AFTER notes
7
    |);
7
        |);
8
    }
9
    unless ( column_exists('article_requests', 'urls') ) {
10
        $dbh->do(q|
11
            ALTER TABLE article_requests
12
            ADD COLUMN `urls` MEDIUMTEXT AFTER format
13
        |);
14
    }
8
    NewVersion( $DBversion, 20472, "Add columns format and urls in article_requests table");
15
    NewVersion( $DBversion, 20472, "Add columns format and urls in article_requests table");
9
}
16
}
10
- 

Return to bug 20472