[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