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'; |