Bug 17663: Forgotten userpermissions from bug 14686
authorMarcel de Rooy <m.de.rooy@rijksmuseum.nl>
Sun, 20 Nov 2016 15:35:53 +0000 (16:35 +0100)
committerMason James <mtj@kohaaloha.com>
Mon, 12 Dec 2016 01:54:14 +0000 (14:54 +1300)
commitd02b7cf5297b4efbc763e5e79fc8e7d8e4088918
tree36ec5d4c1c4b9aacbadbcfe4f580439a2b5f1cbb
parentcb640e0dbfa2d440ae98411e845a6cc20bfcc7e7
Bug 17663: Forgotten userpermissions from bug 14686

Bug 14686 added in a dbrev:
    (13, 'upload_general_files', 'Upload any file'),
    (13, 'upload_manage', 'Manage uploaded files');

But these were not added in userpermissions.sql somehow :)
So, what now?

This patch:
[1] adds them to userpermissions.sql as should have been done,
[2] adds a dbrev to add them for newer installs that did not run the
    14686 dbrev.

Test plan:
[1] Run this sql statement:
    DELETE FROM permissions WHERE code = 'upload_general_files' OR
        code = 'upload_manage'
[2] Run the db rev.
[3] Check if you see Tools/Upload (with sufficient perms).

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com>
Signed-off-by: Mason James <mtj@kohaaloha.com>
installer/data/mysql/atomicupdate/bug17663.perl [new file with mode: 0644]
installer/data/mysql/userpermissions.sql