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

(-)a/installer/data/mysql/updatedatabase.pl (-2 / +13 lines)
Lines 6478-6484 if ( CheckVersion($DBversion) ) { Link Here
6478
6478
6479
$DBversion = "3.11.00.XXX";
6479
$DBversion = "3.11.00.XXX";
6480
if ( CheckVersion($DBversion) ) {
6480
if ( CheckVersion($DBversion) ) {
6481
    $dbh->do("INSERT INTO  permissions ( module_bit, code, description ) VALUES  ( '1',  'overdues_report',  'Execute overdue items report' )");
6481
    $dbh->do(q{
6482
        INSERT INTO permissions ( module_bit, code, description )
6483
        VALUES  ( '1', 'overdues_report', 'Execute overdue items report' )
6484
    });
6485
    # add new permission for users with all report permissions and circulation remaining permission
6486
    my $sth = $dbh->prepare(q{
6487
        INSERT INTO user_permissions (borrowernumber, module_bit, code)
6488
        SELECT user_permissions.borrowernumber, 1, 'overdues_report'
6489
        FROM user_permissions
6490
        LEFT JOIN borrowers USING(borrowernumber)
6491
        WHERE borrowers.flags & (1 << 16)
6492
        AND user_permissions.code = 'circulate_remaining_permissions'
6493
    });
6482
    print "Upgrade to $DBversion done ( Add circ permission overdues_report )\n";
6494
    print "Upgrade to $DBversion done ( Add circ permission overdues_report )\n";
6483
    SetVersion($DBversion);
6495
    SetVersion($DBversion);
6484
}
6496
}
6485
- 

Return to bug 6898