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

(-)a/installer/data/mysql/atomicupdate/bug_28633.perl (-1 / +28 lines)
Line 0 Link Here
0
- 
1
$DBversion = 'XXX'; 
2
if( CheckVersion( $DBversion ) ) {
3
    if( !column_exists( 'borrowers', 'preferredname' ) ) {
4
        $dbh->do(q{
5
            ALTER TABLE borrowers 
6
            ADD COLUMN preferredname longtext NULL DEFAULT NULL 
7
            COMMENT "patron/borrower's preferred name"
8
            AFTER firstname 
9
        });
10
    }
11
    if( !column_exists( 'deletedborrowers', 'preferredname' ) ) {
12
        $dbh->do(q{
13
            ALTER TABLE deletedborrowers 
14
            ADD COLUMN preferredname longtext NULL DEFAULT NULL 
15
            COMMENT "patron/borrower's preferred name"
16
            AFTER firstname 
17
        });
18
    }
19
    if( !column_exists( 'borrower_modifications', 'preferredname' ) ) {
20
        $dbh->do(q{
21
            ALTER TABLE borrower_modifications
22
            ADD COLUMN preferredname longtext NULL DEFAULT NULL
23
            COMMENT "patron/borrower's preferred name"
24
            AFTER firstname
25
        });
26
    }
27
    NewVersion( $DBversion, 28633, "Add preferredname to borrowers tables");
28
}

Return to bug 28633