From 10fdb7fe50b78a8cc1043e0d401b6066ee5a16de Mon Sep 17 00:00:00 2001 From: Srdjan Date: Wed, 18 Jul 2012 17:53:31 +1200 Subject: [PATCH] bug_8083: Explanation of update query Signed-off-by: Paul Poulain --- installer/data/mysql/updatedatabase.pl | 2 ++ 1 file changed, 2 insertions(+) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index e762b7cf7b..1c3c76bae4 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -5547,6 +5547,8 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { $dbh->do("INSERT INTO user_permissions (borrowernumber, module_bit, code) SELECT borrowernumber, 3, 'parameters_remaining_permissions' FROM borrowers WHERE flags & (1 << 3)"); + # Give new subpermissions to all users that have 'parameters' permission flag (bit 3) set + # see userflags table $dbh->do("INSERT INTO user_permissions (borrowernumber, module_bit, code) SELECT borrowernumber, 3, 'manage_circ_rules' FROM borrowers WHERE flags & (1 << 3)"); -- 2.39.5