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