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)
committerKyle M Hall <kyle@bywatersolutions.com>
Mon, 21 Nov 2016 16:33:16 +0000 (16:33 +0000)
commit9ca72539de083c9a62f16b2f114b9111a0f06636
treea2d1d19476e275b07a30373db65f43c57fbab5d7
parenta0416ff132469e6816554136707e398f114ab13e
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: Kyle M Hall <kyle@bywatersolutions.com>
installer/data/mysql/atomicupdate/bug17663.perl [new file with mode: 0644]
installer/data/mysql/userpermissions.sql