[Koha-patches] [PATCH] bug_8083: Explanation of update query

Srdjan srdjan at catalyst.net.nz
Wed Jul 18 07:56:35 CEST 2012


---
 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



More information about the Koha-patches mailing list