From 69310ea532ea8b8703f527b5605f8a0a6c530d65 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 --- 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 b611f88..77e13ba 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -5257,6 +5257,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)"); -- 1.7.9.5