From a2bce7a1a996a74f6317324c944d59fabd455855 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@biblibre.com>
Date: Mon, 31 Mar 2014 14:06:22 +0200
Subject: [PATCH] Bug 7673: Add permission delete_all_items if user has
 edit_items

The delete_all_items permission should be added to users having the
edit_items permission.
---
 installer/data/mysql/updatedatabase.pl |    4 ++++
 1 file changed, 4 insertions(+)

diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
index 0086cd6..df3fa68 100755
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -8105,6 +8105,10 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
        INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES ('SubfieldsToAllowForLimitedBatchmod','','Define a list of subfields for which edition is authorized when items_limited_batchmod permission is enabled, separated by spaces. Example: 995\$f 995\$h 995\$j','','Free');
    });
 
+    $dbh->do(q{
+        INSERT INTO user_permissions (borrowernumber, module_bit, code) SELECT borrowernumber, module_bit, "delete_all_items" FROM user_permissions WHERE code="edit_items";
+    });
+
     print "Upgrade to $DBversion done (Bug 7673: Adds new permissions for cataloguing and batch item modification)\n";
 
     SetVersion($DBversion);
-- 
1.7.10.4