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

(-)a/installer/data/mysql/atomicupdate/bug_33363.pl (-5 / +6 lines)
Lines 1-4 Link Here
1
use Modern::Perl;
1
use Modern::Perl;
2
use Koha::Installer::Output qw(say_warning say_failure say_success say_info);
2
3
3
return {
4
return {
4
    bug_number  => "33363",
5
    bug_number  => "33363",
Lines 10-25 return { Link Here
10
11
11
        $dbh->do(
12
        $dbh->do(
12
            q{INSERT IGNORE INTO permissions (module_bit, code, description) VALUES (12, 'suggestions_create', 'Create purchase suggestions')}
13
            q{INSERT IGNORE INTO permissions (module_bit, code, description) VALUES (12, 'suggestions_create', 'Create purchase suggestions')}
13
        );
14
        ) && say_success($out, "Added new permissions suggestions_create");
14
        $dbh->do(
15
        $dbh->do(
15
            q{INSERT IGNORE INTO permissions (module_bit, code, description) VALUES (12, 'suggestions_delete', 'Update purchase suggestions')}
16
            q{INSERT IGNORE INTO permissions (module_bit, code, description) VALUES (12, 'suggestions_delete', 'Update purchase suggestions')}
16
        );
17
        ) && say_success($out, "Added new permissions suggestions_delete");
17
18
18
        $dbh->do(
19
        $dbh->do(
19
            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 << 2)}
20
        );
21
        ) && say_success($out, "Added new permissions suggestions_create to patrons with suggestions_manage");
21
        $dbh->do(
22
        $dbh->do(
22
            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 << 2)}
23
        );
24
        ) && say_success($out, "Added new permissions suggestions_delete to patrons with suggestions_manage");
25
24
    },
26
    },
25
};
27
};
26
- 

Return to bug 33363