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

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +10 lines)
Lines 8787-8792 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
8787
        INSERT INTO permissions (module_bit, code, description)
8787
        INSERT INTO permissions (module_bit, code, description)
8788
          VALUES (11, 'order_receive_all', 'Receive all orders')
8788
          VALUES (11, 'order_receive_all', 'Receive all orders')
8789
    ");
8789
    ");
8790
8791
    # Add this new permission to all users that have 'order_receive' permission
8792
    $dbh->do(q{
8793
        INSERT INTO user_permissions (borrowernumber, module_bit, code)
8794
          SELECT borrowernumber, 11, 'order_receive_all'
8795
          FROM user_permissions
8796
          WHERE code = 'order_receive'
8797
          GROUP BY borrowernumber
8798
    });
8799
8790
    print "Upgrade to $DBversion done (Bug 7290: Add permission order_receive_all)\n";
8800
    print "Upgrade to $DBversion done (Bug 7290: Add permission order_receive_all)\n";
8791
    SetVersion($DBversion);
8801
    SetVersion($DBversion);
8792
}
8802
}
8793
- 

Return to bug 7290