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

(-)a/installer/data/mysql/atomicupdate/bug_15788.perl (-6 / +3 lines)
Lines 9-20 if ( CheckVersion($DBversion) ) { Link Here
9
    }
9
    }
10
    );
10
    );
11
11
12
    $dbh->do(
12
    $dbh->do(q{
13
        qq{
14
        INSERT IGNORE INTO user_permissions (borrowernumber, module_bit, code)
13
        INSERT IGNORE INTO user_permissions (borrowernumber, module_bit, code)
15
        SELECT borrowernumber, 4, 'delete_borrowers' FROM borrowers WHERE borrowernumber IN ( SELECT borrowernumber FROM user_permissions WHERE code = 'edit_borrowers')
14
        SELECT borrowernumber, 4, 'delete_borrowers' FROM user_permissions WHERE code = 'edit_borrowers'
16
    }
15
    });
17
    );
18
16
19
    NewVersion( $DBversion, 15788, "Split edit_borrowers permission" );
17
    NewVersion( $DBversion, 15788, "Split edit_borrowers permission" );
20
}
18
}
21
- 

Return to bug 15788