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

(-)a/installer/data/mysql/db_revs/240600014.pl (-3 / +2 lines)
Lines 17-26 return { Link Here
17
        ) && say_success( $out, "Added new permissions suggestions_delete" );
17
        ) && say_success( $out, "Added new permissions suggestions_delete" );
18
18
19
        $dbh->do(
19
        $dbh->do(
20
            q{INSERT IGNORE INTO user_permissions (borrowernumber, module_bit, code) SELECT borrowernumber, 12, 'suggestions_create' FROM borrowers WHERE flags & (1 << 2)}
20
            q{INSERT IGNORE INTO user_permissions (borrowernumber, module_bit, code) SELECT borrowernumber, 12, 'suggestions_create' FROM borrowers WHERE flags & (1 << 12)}
21
        ) && say_success( $out, "Added new permissions suggestions_create to patrons with suggestions_manage" );
21
        ) && say_success( $out, "Added new permissions suggestions_create to patrons with suggestions_manage" );
22
        $dbh->do(
22
        $dbh->do(
23
            q{INSERT IGNORE INTO user_permissions (borrowernumber, module_bit, code) SELECT borrowernumber, 12, 'suggestions_delete' FROM borrowers WHERE flags & (1 << 2)}
23
            q{INSERT IGNORE INTO user_permissions (borrowernumber, module_bit, code) SELECT borrowernumber, 12, 'suggestions_delete' FROM borrowers WHERE flags & (1 << 12)}
24
        ) && say_success( $out, "Added new permissions suggestions_delete to patrons with suggestions_manage" );
24
        ) && say_success( $out, "Added new permissions suggestions_delete to patrons with suggestions_manage" );
25
25
26
    },
26
    },
27
- 

Return to bug 41045