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

(-)a/installer/data/mysql/atomicupdate/bug_24481.perl (+15 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
4
    $dbh->do(qq{
5
        UPDATE
6
          `permissions`
7
        SET
8
          `module_bit` = 3
9
        WHERE 
10
          `code` = 'manage_cash_registers'
11
    });
12
13
    SetVersion( $DBversion );
14
    print "Upgrade to $DBversion done (Bug 24481 - Move permission to correct module_bit)\n";
15
}
(-)a/installer/data/mysql/userpermissions.sql (-2 / +1 lines)
Lines 17-22 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
17
   ( 3, 'manage_patron_attributes', 'Manage extended patron attributes'),
17
   ( 3, 'manage_patron_attributes', 'Manage extended patron attributes'),
18
   ( 3, 'manage_transfers', 'Manage library transfer limits and transport cost matrix'),
18
   ( 3, 'manage_transfers', 'Manage library transfer limits and transport cost matrix'),
19
   ( 3, 'manage_item_circ_alerts', 'Manage item circulation alerts'),
19
   ( 3, 'manage_item_circ_alerts', 'Manage item circulation alerts'),
20
   ( 3, 'manage_cash_registers', 'Add and remove cash registers'),
20
   ( 3, 'manage_cities', 'Manage cities and towns'),
21
   ( 3, 'manage_cities', 'Manage cities and towns'),
21
   ( 3, 'manage_marc_frameworks', 'Manage MARC bibliographic and authority frameworks'),
22
   ( 3, 'manage_marc_frameworks', 'Manage MARC bibliographic and authority frameworks'),
22
   ( 3, 'manage_classifications', 'Manage classification sources'),
23
   ( 3, 'manage_classifications', 'Manage classification sources'),
Lines 120-125 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
120
   (23, 'self_checkout_module', 'Perform self checkout at the OPAC. It should be used for the patron matching the AutoSelfCheckID'),
121
   (23, 'self_checkout_module', 'Perform self checkout at the OPAC. It should be used for the patron matching the AutoSelfCheckID'),
121
   (24, 'manage_rotas', 'Create, edit and delete rotas'),
122
   (24, 'manage_rotas', 'Create, edit and delete rotas'),
122
   (24, 'manage_rota_items', 'Add and remove items from rotas'),
123
   (24, 'manage_rota_items', 'Add and remove items from rotas'),
123
   (25, 'manage_cash_registers', 'Add and remove cash registers'),
124
   (25, 'takepayment', 'Access the point of sale page and take payments')
124
   (25, 'takepayment', 'Access the point of sale page and take payments')
125
;
125
;
126
- 

Return to bug 24481