From 3c251a72da6d47a6294eddd27ad61d18f2955ba0 Mon Sep 17 00:00:00 2001 From: Julian Maurice Date: Thu, 9 Oct 2014 10:15:16 +0200 Subject: [PATCH] Bug 7290: Add new permission to users that have 'order_receive' --- installer/data/mysql/updatedatabase.pl | 10 ++++++++++ 1 file changed, 10 insertions(+) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 33880f4..6e7b4ce 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -8787,6 +8787,16 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { INSERT INTO permissions (module_bit, code, description) VALUES (11, 'order_receive_all', 'Receive 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_receive_all' + FROM user_permissions + WHERE code = 'order_receive' + GROUP BY borrowernumber + }); + print "Upgrade to $DBversion done (Bug 7290: Add permission order_receive_all)\n"; SetVersion($DBversion); } -- 1.9.1