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

(-)a/installer/data/mysql/atomicupdate/bug_21336_followup.perl (-1 / +6 lines)
Lines 2-7 $DBversion = 'XXX'; Link Here
2
if( CheckVersion( $DBversion ) ) {
2
if( CheckVersion( $DBversion ) ) {
3
3
4
    if ( column_exists( 'borrowers', 'flgAnonymized' ) ) {
4
    if ( column_exists( 'borrowers', 'flgAnonymized' ) ) {
5
        $dbh->do(q{
6
            UPDATE borrowers SET flgAnonymized = 0 WHERE flgAnonymized IS NULL
7
        });
5
        $dbh->do(q{
8
        $dbh->do(q{
6
            ALTER TABLE borrowers
9
            ALTER TABLE borrowers
7
                CHANGE `flgAnonymized` `anonymized` TINYINT(1) NOT NULL DEFAULT 0
10
                CHANGE `flgAnonymized` `anonymized` TINYINT(1) NOT NULL DEFAULT 0
Lines 9-14 if( CheckVersion( $DBversion ) ) { Link Here
9
    }
12
    }
10
13
11
    if ( column_exists( 'deletedborrowers', 'flgAnonymized' ) ) {
14
    if ( column_exists( 'deletedborrowers', 'flgAnonymized' ) ) {
15
        $dbh->do(q{
16
            UPDATE deletedborrowers SET flgAnonymized = 0 WHERE flgAnonymized IS NULL
17
        });
12
        $dbh->do(q{
18
        $dbh->do(q{
13
            ALTER TABLE deletedborrowers
19
            ALTER TABLE deletedborrowers
14
                CHANGE `flgAnonymized` `anonymized` TINYINT(1) NOT NULL DEFAULT 0
20
                CHANGE `flgAnonymized` `anonymized` TINYINT(1) NOT NULL DEFAULT 0
15
- 

Return to bug 22729