Bug 11911: Add a separate permission for managing suggestions

[koha.git] / installer / data / mysql / userpermissions.sql

diff --git a/installer/data/mysql/userpermissions.sql b/installer/data/mysql/userpermissions.sql
index 268e9e6..67b76e6 100644 (file)
--- a/installer/data/mysql/userpermissions.sql
+++ b/installer/data/mysql/userpermissions.sql
@@ -4,9 +4,11 @@ INSERT INTO permissions (module_bit, code, description) VALUES
    ( 1, 'overdues_report', 'Execute overdue items report'),
    ( 1, 'force_checkout', 'Force checkout if a limitation exists'),
    ( 1, 'manage_restrictions', 'Manage restrictions for accounts'),
-   ( 1, 'self_checkout', 'Perform self checkout at the OPAC. It should be used for the patron matching the AutoSelfCheckID'),
+   ( 1, 'manage_checkout_notes', 'Mark checkout notes as seen/not seen'),
    ( 3, 'parameters_remaining_permissions', 'Remaining system parameters permissions'),
    ( 3, 'manage_circ_rules', 'Manage circulation rules'),
+   ( 4, 'edit_borrowers', 'Add, modify and view patron information'),
+   ( 4, 'view_borrower_infos_from_any_libraries', 'View patron infos from any libraries'),
    ( 6, 'place_holds', 'Place holds for patrons'),
    ( 6, 'modify_holds_priority', 'Modify holds priority'),
    ( 9, 'edit_catalogue', 'Edit catalog (Modify bibliographic/holdings data)'),
@@ -16,18 +18,21 @@ INSERT INTO permissions (module_bit, code, description) VALUES
    ( 9, 'delete_all_items', 'Delete all items at once'),
    (10, 'writeoff', 'Write off fines and fees'),
    (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
+   (11, 'currencies_manage', 'Manage currencies and exchange rates'),
+   (11, 'suggestions_manage', 'Manage purchase suggestions'),
    (11, 'vendors_manage', 'Manage vendors'),
    (11, 'contracts_manage', 'Manage contracts'),
-   (11, 'period_manage', 'Manage periods'),
-   (11, 'budget_manage', 'Manage budgets'),
-   (11, 'budget_modify', 'Modify budget (can''t create lines, but can modify existing ones)'),
+   (11, 'period_manage', 'Manage budgets'),
+   (11, 'budget_manage', 'Manage funds'),
+   (11, 'budget_modify', 'Modify funds (can''t create lines, but can modify existing ones)'),
    (11, 'planning_manage', 'Manage budget plannings'),
-   (11, 'order_manage', 'Manage orders & basket'),
-   (11, 'order_manage_all', 'Manage all orders and baskets, regardless of restrictions on them'),
-   (11, 'group_manage', 'Manage orders & basketgroups'),
-   (11, 'order_receive', 'Manage orders & basket'),
-   (11, 'budget_add_del', 'Add and delete budgets (but can''t modify budgets)'),
-   (11, 'budget_manage_all', 'Manage all budgets'),
+   (11, 'order_manage', 'Manage baskets and order lines'),
+   (11, 'order_manage_all', 'Manage all baskets and order lines, regardless of restrictions on them'),
+   (11, 'group_manage', 'Manage basket groups'),
+   (11, 'order_receive', 'Receive orders and manage shipments'),
+   (11, 'budget_add_del', 'Add and delete funds (but can''t modify funds)'),
+   (11, 'budget_manage_all', 'Manage all funds'),
+   (11, 'edi_manage', 'Manage EDIFACT transmissions'),
    (13, 'edit_news', 'Write news for the OPAC and staff interfaces'),
    (13, 'label_creator', 'Create printable labels and barcodes from catalog and patron data'),
    (13, 'edit_calendar', 'Define days when the library is closed'),
@@ -56,6 +61,9 @@ INSERT INTO permissions (module_bit, code, description) VALUES
    (13, 'records_batchmod', 'Perform batch modification of records (biblios or authorities)'),
    (13, 'marc_modification_templates', 'Manage marc modification templates'),
    (13, 'records_batchdel', 'Perform batch deletion of records (bibliographic or authority)'),
+   (13, 'access_files', 'Access to the files stored on the server'),
+   (13, 'upload_general_files', 'Upload any file'),
+   (13, 'upload_manage', 'Manage uploaded files'),
    (15, 'check_expiration', 'Check the expiration of a serial'),
    (15, 'claim_serials', 'Claim missing serials'),
    (15, 'create_subscription', 'Create a new subscription'),
@@ -67,6 +75,7 @@ INSERT INTO permissions (module_bit, code, description) VALUES
    (15, 'superserials', 'Manage subscriptions from any branch (only applies when IndependentBranches is used)'),
    (16, 'execute_reports', 'Execute SQL reports'),
    (16, 'create_reports', 'Create SQL reports'),
+   (16, 'delete_reports', 'Delete SQL reports'),
    (18, 'manage_courses', 'Add, edit and delete courses'),
    (18, 'add_reserves', 'Add course reserves'),
    (18, 'delete_reserves', 'Remove course reserves'),
@@ -74,5 +83,10 @@ INSERT INTO permissions (module_bit, code, description) VALUES
    (19, 'tool', 'Use tool plugins'),
    (19, 'report', 'Use report plugins'),
    (19, 'configure', 'Configure plugins'),
-   (20, 'delete_public_lists', 'Delete public lists')
+   (20, 'delete_public_lists', 'Delete public lists'),
+   (21, 'edit_templates', 'Create and update club templates'),
+   (21, 'edit_clubs', 'Create and update clubs'),
+   (21, 'enroll', 'Enroll patrons in clubs'),
+   (23, 'self_checkin_module', 'Log into the self check-in module'),
+   (23, 'self_checkout_module', 'Perform self checkout at the OPAC. It should be used for the patron matching the AutoSelfCheckID')
 ;