@@ -, +, @@ 'order_receive' permission --- installer/data/mysql/updatedatabase.pl | 15 ++++++++++++--- 1 file changed, 12 insertions(+), 3 deletions(-) --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -8579,12 +8579,21 @@ if ( CheckVersion($DBversion) ) { $DBversion = "XXX"; if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { - $dbh->do(" + $dbh->do(q{ INSERT IGNORE INTO permissions (module_bit, code, description) VALUES (11, 'order_claim_for_all', 'Claim for all orders') - "); + }); + + # Add this new permission to all users that have 'order_receive' permission + $dbh->do(q{ + INSERT INTO user_permissions (borrowernumber, module_bit, code) + SELECT borrowernumber, 11, 'order_claim_for_all' + FROM user_permissions + WHERE code = 'order_receive' + GROUP BY borrowernumber + }); - print "Upgrade to $DBversion done (Add permission order_claim_for_all)\n"; + print "Upgrade to $DBversion done (Bug 7292: Add permission order_claim_for_all)\n"; SetVersion($DBversion); } --