|
Line 0
Link Here
|
| 0 |
- |
1 |
$DBversion = 'XXX'; |
|
|
2 |
if( CheckVersion( $DBversion ) ) { |
| 3 |
$dbh->do(q{ |
| 4 |
INSERT IGNORE INTO permissions (module_bit, code, description) VALUES |
| 5 |
( 3, 'manage_sysprefs', 'Manage global system preferences'), |
| 6 |
( 3, 'manage_libraries', 'Manage libraries and library groups'), |
| 7 |
( 3, 'manage_itemtypes', 'Manage item types'), |
| 8 |
( 3, 'manage_auth_values', 'Manage authorized values'), |
| 9 |
( 3, 'manage_patron_categories', 'Manage patron categories'), |
| 10 |
( 3, 'manage_patron_attributes', 'Manage extended patron attributes'), |
| 11 |
( 3, 'manage_transfers', 'Manage library transfer limits and transport cost matrix'), |
| 12 |
( 3, 'manage_item_circ_alerts', 'Manage item circulation alerts'), |
| 13 |
( 3, 'manage_cities', 'Manage cities and towns'), |
| 14 |
( 3, 'manage_marc_frameworks', 'Manage MARC bibliographic and authority frameworks'), |
| 15 |
( 3, 'manage_keywords2koha_mappings', 'Manage keywords to Koha mappings'), |
| 16 |
( 3, 'manage_classifications', 'Manage classification sources'), |
| 17 |
( 3, 'manage_matching_rules', 'Manage record matching rules'), |
| 18 |
( 3, 'manage_oai_sets', 'Manage OAI sets'), |
| 19 |
( 3, 'manage_item_search_fields', 'Manage item search fields'), |
| 20 |
( 3, 'manage_search_engine_config', 'Manage search engine configuration'), |
| 21 |
( 3, 'manage_search_targets', 'Manage Z39.50 and SRU server configuration'), |
| 22 |
( 3, 'manage_didyoumean', 'Manage Did you mean? configuration'), |
| 23 |
( 3, 'manage_column_config', 'Manage column configuration'), |
| 24 |
( 3, 'manage_sms_providers', 'Manage SMS cellular providers'), |
| 25 |
( 3, 'manage_audio_alerts', 'Manage audio alerts'), |
| 26 |
( 3, 'manage_usage_stats', 'Manage usage statistics settings'); |
| 27 |
}); |
| 28 |
$dbh->do(q{ |
| 29 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
| 30 |
SELECT borrowernumber, 3, 'manage_sysprefs' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
| 31 |
}); |
| 32 |
$dbh->do(q{ |
| 33 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
| 34 |
SELECT borrowernumber, 3, 'manage_libraries' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
| 35 |
}); |
| 36 |
$dbh->do(q{ |
| 37 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
| 38 |
SELECT borrowernumber, 3, 'manage_itemtypes' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
| 39 |
}); |
| 40 |
$dbh->do(q{ |
| 41 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
| 42 |
SELECT borrowernumber, 3, 'manage_auth_values' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
| 43 |
}); |
| 44 |
$dbh->do(q{ |
| 45 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
| 46 |
SELECT borrowernumber, 3, 'manage_patron_categories' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
| 47 |
}); |
| 48 |
$dbh->do(q{ |
| 49 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
| 50 |
SELECT borrowernumber, 3, 'manage_patron_attributes' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
| 51 |
}); |
| 52 |
$dbh->do(q{ |
| 53 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
| 54 |
SELECT borrowernumber, 3, 'manage_transfers' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
| 55 |
}); |
| 56 |
$dbh->do(q{ |
| 57 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
| 58 |
SELECT borrowernumber, 3, 'manage_item_circ_alerts' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
| 59 |
}); |
| 60 |
$dbh->do(q{ |
| 61 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
| 62 |
SELECT borrowernumber, 3, 'manage_cities' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
| 63 |
}); |
| 64 |
$dbh->do(q{ |
| 65 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
| 66 |
SELECT borrowernumber, 3, 'manage_marc_frameworks' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
| 67 |
}); |
| 68 |
$dbh->do(q{ |
| 69 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
| 70 |
SELECT borrowernumber, 3, 'manage_keywords2koha_mappings' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
| 71 |
}); |
| 72 |
$dbh->do(q{ |
| 73 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
| 74 |
SELECT borrowernumber, 3, 'manage_classifications' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
| 75 |
}); |
| 76 |
$dbh->do(q{ |
| 77 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
| 78 |
SELECT borrowernumber, 3, 'manage_matching_rules' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
| 79 |
}); |
| 80 |
$dbh->do(q{ |
| 81 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
| 82 |
SELECT borrowernumber, 3, 'manage_oai_sets' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
| 83 |
}); |
| 84 |
$dbh->do(q{ |
| 85 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
| 86 |
SELECT borrowernumber, 3, 'manage_item_search_fields' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
| 87 |
}); |
| 88 |
$dbh->do(q{ |
| 89 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
| 90 |
SELECT borrowernumber, 3, 'manage_search_engine_config' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
| 91 |
}); |
| 92 |
$dbh->do(q{ |
| 93 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
| 94 |
SELECT borrowernumber, 3, 'manage_search_targets' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
| 95 |
}); |
| 96 |
$dbh->do(q{ |
| 97 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
| 98 |
SELECT borrowernumber, 3, 'manage_didyoumean' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
| 99 |
}); |
| 100 |
$dbh->do(q{ |
| 101 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
| 102 |
SELECT borrowernumber, 3, 'manage_column_config' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
| 103 |
}); |
| 104 |
$dbh->do(q{ |
| 105 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
| 106 |
SELECT borrowernumber, 3, 'manage_sms_providers' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
| 107 |
}); |
| 108 |
$dbh->do(q{ |
| 109 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
| 110 |
SELECT borrowernumber, 3, 'manage_audio_alerts' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
| 111 |
}); |
| 112 |
$dbh->do(q{ |
| 113 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
| 114 |
SELECT borrowernumber, 3, 'manage_usage_stats' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
| 115 |
}); |
| 116 |
$dbh->do(q{ |
| 117 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
| 118 |
SELECT borrowernumber, 3, 'manage_item_search_fields' |
| 119 |
FROM borrowers |
| 120 |
WHERE borrowernumber IN |
| 121 |
(SELECT borrowernumber FROM user_permissions WHERE code = 'catalogue'); |
| 122 |
}); |
| 123 |
SetVersion( $DBversion ); |
| 124 |
print "Upgrade to $DBversion done (Bug 14391: Add granular permissions to the administration module)\n"; |
| 125 |
} |