From d7f29d131e8b810b24d97d85b633fc5cce985b89 Mon Sep 17 00:00:00 2001 From: Julian Maurice Date: Fri, 28 Mar 2014 11:19:34 +0100 Subject: [PATCH] Bug 7292: Add new permission to users that have 'order_receive' permission --- installer/data/mysql/updatedatabase.pl | 15 ++++++++++++--- 1 file changed, 12 insertions(+), 3 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index ae3cfd3..030e99e 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -8485,12 +8485,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); } -- 1.7.10.4