View | Details | Raw Unified | Return to bug 16978
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_16978.sql (-1 / +6 lines)
Lines 1-3 Link Here
1
INSERT IGNORE INTO `permissions`
1
INSERT IGNORE INTO `permissions`
2
    (module_bit, code,             description) VALUES
2
    (module_bit, code,             description) VALUES
3
    (16,         'delete_reports', 'Delete SQL reports');
3
    (16,         'delete_reports', 'Delete SQL reports');
4
- 
4
5
INSERT IGNORE INTO user_permissions
6
    (borrowernumber,      module_bit,code)
7
    SELECT borrowernumber,module_bit,'delete_reports'
8
        FROM user_permissions
9
        WHERE module_bit=16 AND code='create_reports';

Return to bug 16978