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

(-)a/installer/data/mysql/de-DE/mandatory/userpermissions.sql (+3 lines)
Lines 11-16 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
11 
   ( 9, 'edit_catalogue', 'Katalogdaten bearbeiten (Titel- und Exemplardaten ändern)'),
 11 
   ( 9, 'edit_catalogue', 'Katalogdaten bearbeiten (Titel- und Exemplardaten ändern)'),
12 
   ( 9, 'fast_cataloging', 'Schnellaufnahmen anlegen'),
 12 
   ( 9, 'fast_cataloging', 'Schnellaufnahmen anlegen'),
13 
   ( 9, 'edit_items', 'Exemplare bearbeiten'),
 13 
   ( 9, 'edit_items', 'Exemplare bearbeiten'),
14 
   ( 9, 'edit_items_restricted', 'Limit item modification to barcode, status and note (please note that edit_item is still required)'),
15 
   ( 9, 'delete_all_items', 'Delete all items at once'),
14 
   (10, 'writeoff', 'Gebühren erlassen'),
 16 
   (10, 'writeoff', 'Gebühren erlassen'),
15 
   (10, 'remaining_permissions', 'Verbleibende Berechtigungen für die Verwaltung von Gebühren'),
 17 
   (10, 'remaining_permissions', 'Verbleibende Berechtigungen für die Verwaltung von Gebühren'),
16 
   (11, 'vendors_manage', 'Lieferanten verwalten'),
 18 
   (11, 'vendors_manage', 'Lieferanten verwalten'),
Lines 43-48 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
43 
   (13, 'batch_upload_patron_images', 'Benutzerfotos einzeln oder im Stapel hochladen'),
 45 
   (13, 'batch_upload_patron_images', 'Benutzerfotos einzeln oder im Stapel hochladen'),
44 
   (13, 'schedule_tasks', 'Aufgabenplaner verwenden'),
 46 
   (13, 'schedule_tasks', 'Aufgabenplaner verwenden'),
45 
   (13, 'items_batchmod', 'Stapelbearbeitung von Exemplaren durchführen'),
 47 
   (13, 'items_batchmod', 'Stapelbearbeitung von Exemplaren durchführen'),
48 
   (13, 'items_batchmod_restricted', 'Limit batch item modification to item status (please note that items_batchmod is still required)'),
46 
   (13, 'items_batchdel', 'Stapellöschung von Exemplaren durchführen'),
 49 
   (13, 'items_batchdel', 'Stapellöschung von Exemplaren durchführen'),
47 
   (13, 'manage_csv_profiles', 'CSV-Profile für Export verwalten'),
 50 
   (13, 'manage_csv_profiles', 'CSV-Profile für Export verwalten'),
48 
   (13, 'moderate_tags', 'Von Benutzern vergebene Tags moderieren'),
 51 
   (13, 'moderate_tags', 'Von Benutzern vergebene Tags moderieren'),
(-)a/installer/data/mysql/en/mandatory/userpermissions.sql (+3 lines)
Lines 11-16 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
11 
   ( 9, 'edit_catalogue', 'Edit catalog (Modify bibliographic/holdings data)'),
 11 
   ( 9, 'edit_catalogue', 'Edit catalog (Modify bibliographic/holdings data)'),
12 
   ( 9, 'fast_cataloging', 'Fast cataloging'),
 12 
   ( 9, 'fast_cataloging', 'Fast cataloging'),
13 
   ( 9, 'edit_items', 'Edit Items'),
 13 
   ( 9, 'edit_items', 'Edit Items'),
14 
   ( 9, 'edit_items_restricted', 'Limit item modification to barcode, status and note (please note that edit_item is still required)'),
15 
   ( 9, 'delete_all_items', 'Delete all items at once'),
14 
   (10, 'writeoff', 'Write off fines and fees'),
 16 
   (10, 'writeoff', 'Write off fines and fees'),
15 
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
 17 
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
16 
   (11, 'vendors_manage', 'Manage vendors'),
 18 
   (11, 'vendors_manage', 'Manage vendors'),
Lines 43-48 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
43 
   (13, 'batch_upload_patron_images', 'Upload patron images in a batch or one at a time'),
 45 
   (13, 'batch_upload_patron_images', 'Upload patron images in a batch or one at a time'),
44 
   (13, 'schedule_tasks', 'Schedule tasks to run'),
 46 
   (13, 'schedule_tasks', 'Schedule tasks to run'),
45 
   (13, 'items_batchmod', 'Perform batch modification of items'),
 47 
   (13, 'items_batchmod', 'Perform batch modification of items'),
48 
   (13, 'items_batchmod_restricted', 'Limit batch item modification to item status (please note that items_batchmod is still required)'),
46 
   (13, 'items_batchdel', 'Perform batch deletion of items'),
 49 
   (13, 'items_batchdel', 'Perform batch deletion of items'),
47 
   (13, 'manage_csv_profiles', 'Manage CSV export profiles'),
 50 
   (13, 'manage_csv_profiles', 'Manage CSV export profiles'),
48 
   (13, 'moderate_tags', 'Moderate patron tags'),
 51 
   (13, 'moderate_tags', 'Moderate patron tags'),
(-)a/installer/data/mysql/es-ES/mandatory/userpermissions.sql (+3 lines)
Lines 11-16 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
11 
   ( 9, 'edit_catalogue', 'Edit catalog (Modify bibliographic/holdings data)'),
 11 
   ( 9, 'edit_catalogue', 'Edit catalog (Modify bibliographic/holdings data)'),
12 
   ( 9, 'fast_cataloging', 'Fast cataloging'),
 12 
   ( 9, 'fast_cataloging', 'Fast cataloging'),
13 
   ( 9, 'edit_items', 'Edit Items'),
 13 
   ( 9, 'edit_items', 'Edit Items'),
14 
   ( 9, 'edit_items_restricted', 'Limit item modification to barcode, status and note (please note that edit_item is still required)'),
15 
   ( 9, 'delete_all_items', 'Delete all items at once'),
14 
   (10, 'writeoff', 'Write off fines and fees'),
 16 
   (10, 'writeoff', 'Write off fines and fees'),
15 
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
 17 
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
16 
   (11, 'vendors_manage', 'Manage vendors'),
 18 
   (11, 'vendors_manage', 'Manage vendors'),
Lines 43-48 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
43 
   (13, 'batch_upload_patron_images', 'Upload patron images in a batch or one at a time'),
 45 
   (13, 'batch_upload_patron_images', 'Upload patron images in a batch or one at a time'),
44 
   (13, 'schedule_tasks', 'Schedule tasks to run'),
 46 
   (13, 'schedule_tasks', 'Schedule tasks to run'),
45 
   (13, 'items_batchmod', 'Perform batch modification of items'),
 47 
   (13, 'items_batchmod', 'Perform batch modification of items'),
48 
   (13, 'items_batchmod_restricted', 'Limit batch item modification to item status (please note that items_batchmod is still required)'),
46 
   (13, 'items_batchdel', 'Perform batch deletion of items'),
 49 
   (13, 'items_batchdel', 'Perform batch deletion of items'),
47 
   (13, 'manage_csv_profiles', 'Manage CSV export profiles'),
 50 
   (13, 'manage_csv_profiles', 'Manage CSV export profiles'),
48 
   (13, 'moderate_tags', 'Moderate patron tags'),
 51 
   (13, 'moderate_tags', 'Moderate patron tags'),
(-)a/installer/data/mysql/fr-FR/1-Obligatoire/userpermissions.sql (+3 lines)
Lines 11-16 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
11 
   ( 9, 'edit_catalogue', 'Ajouter et modifier des notices au catalogue'),
 11 
   ( 9, 'edit_catalogue', 'Ajouter et modifier des notices au catalogue'),
12 
   ( 9, 'fast_cataloging', 'Catalogage rapide'),
 12 
   ( 9, 'fast_cataloging', 'Catalogage rapide'),
13 
   ( 9, 'edit_items', 'Modifier des exemplaires'),
 13 
   ( 9, 'edit_items', 'Modifier des exemplaires'),
14 
   ( 9, 'edit_items_restricted', 'Limit item modification to barcode, status and note (please note that edit_item is still required)'),
15 
   ( 9, 'delete_all_items', 'Delete all items at once'),
14 
   (10, 'writeoff', 'Write off fines and fees'),
 16 
   (10, 'writeoff', 'Write off fines and fees'),
15 
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
 17 
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
16 
   (13, 'edit_news', 'Ecrire des nouvelles pour l''OPAC et l''interface professionnelle'),
 18 
   (13, 'edit_news', 'Ecrire des nouvelles pour l''OPAC et l''interface professionnelle'),
Lines 47-52 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
47 
   (13, 'moderate_tags', 'Modérer les tags des adhérents'),
 49 
   (13, 'moderate_tags', 'Modérer les tags des adhérents'),
48 
   (13, 'rotating_collections', 'Gérer les collections tournantes'),
 50 
   (13, 'rotating_collections', 'Gérer les collections tournantes'),
49 
   (13, 'items_batchmod', 'Modifier les exemplaires par lot'),
 51 
   (13, 'items_batchmod', 'Modifier les exemplaires par lot'),
52 
   (13, 'items_batchmod_restricted', 'Limit batch item modification to item status (please note that items_batchmod is still required)'),
50 
   (13, 'items_batchdel', 'Supprimer les exemplaires par lot'),
 53 
   (13, 'items_batchdel', 'Supprimer les exemplaires par lot'),
51 
   (13, 'upload_local_cover_images', 'Téléchargement des images de couverture'),
 54 
   (13, 'upload_local_cover_images', 'Téléchargement des images de couverture'),
52 
   (13, 'manage_patron_lists', 'Add, edit and delete patron lists and their contents'),
 55 
   (13, 'manage_patron_lists', 'Add, edit and delete patron lists and their contents'),
(-)a/installer/data/mysql/it-IT/necessari/userpermissions.sql (+3 lines)
Lines 13-18 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
13 
   ( 9, 'edit_catalogue', 'Cataloga (crea/modifica dati bibliografici e di copia)'),
 13 
   ( 9, 'edit_catalogue', 'Cataloga (crea/modifica dati bibliografici e di copia)'),
14 
   ( 9, 'fast_cataloging', 'Catalogazione veloce'),
 14 
   ( 9, 'fast_cataloging', 'Catalogazione veloce'),
15 
   ( 9, 'edit_items', 'Crea/modifica copie'),
 15 
   ( 9, 'edit_items', 'Crea/modifica copie'),
16 
   ( 9, 'edit_items_restricted', 'Limit item modification to barcode, status and note (please note that edit_item is still required)'),
17 
   ( 9, 'delete_all_items', 'Delete all items at once'),
16 
   (10, 'writeoff', 'Write off fines and fees'),
 18 
   (10, 'writeoff', 'Write off fines and fees'),
17 
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
 19 
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
18 
   (11, 'vendors_manage', 'Crea/modifica fornitori'),
 20 
   (11, 'vendors_manage', 'Crea/modifica fornitori'),
Lines 45-50 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
45 
   (13, 'batch_upload_patron_images', 'Aggiorna le foto utente in modalità batch o al momento'),
 47 
   (13, 'batch_upload_patron_images', 'Aggiorna le foto utente in modalità batch o al momento'),
46 
   (13, 'schedule_tasks', 'Schedula i task da far andare'),
 48 
   (13, 'schedule_tasks', 'Schedula i task da far andare'),
47 
   (13, 'items_batchmod', 'Abilita alla modifica batch delle copie'),
 49 
   (13, 'items_batchmod', 'Abilita alla modifica batch delle copie'),
50 
   (13, 'items_batchmod_restricted', 'Limit batch item modification to item status (please note that items_batchmod is still required)'),
48 
   (13, 'items_batchdel', 'Abilita alla cancellazione via batch delle copie'),
 51 
   (13, 'items_batchdel', 'Abilita alla cancellazione via batch delle copie'),
49 
   (13, 'manage_csv_profiles', 'Gestisci i profili CSV di export'),
 52 
   (13, 'manage_csv_profiles', 'Gestisci i profili CSV di export'),
50 
   (13, 'moderate_tags', 'Modera i tag inseriti dagli utenti'),
 53 
   (13, 'moderate_tags', 'Modera i tag inseriti dagli utenti'),
(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/userpermissions.sql (+3 lines)
Lines 31-36 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
31 
   ( 9, 'edit_catalogue', 'Endre katalogen (Endre bibliografiske poster og eksemplaropplysninger)'),
 31 
   ( 9, 'edit_catalogue', 'Endre katalogen (Endre bibliografiske poster og eksemplaropplysninger)'),
32 
   ( 9, 'fast_cataloging', 'Hurtigkatalogisering'),
 32 
   ( 9, 'fast_cataloging', 'Hurtigkatalogisering'),
33 
   ( 9, 'edit_items', 'Endre eksmeplarer'),
 33 
   ( 9, 'edit_items', 'Endre eksmeplarer'),
34 
   ( 9, 'edit_items_restricted', 'Limit item modification to barcode, status and note (please note that edit_item is still required)'),
35 
   ( 9, 'delete_all_items', 'Delete all items at once'),
34 
   (10, 'writeoff', 'Write off fines and fees'),
 36 
   (10, 'writeoff', 'Write off fines and fees'),
35 
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
 37 
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
36 
   (11, 'vendors_manage', 'Administrere leverandører'),
 38 
   (11, 'vendors_manage', 'Administrere leverandører'),
Lines 63-68 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
63 
   (13, 'batch_upload_patron_images', 'Laste opp bilder av lånere enkeltvis eller en masse'),
 65 
   (13, 'batch_upload_patron_images', 'Laste opp bilder av lånere enkeltvis eller en masse'),
64 
   (13, 'schedule_tasks', 'Planlegge oppgaver som skal kjøres'),
 66 
   (13, 'schedule_tasks', 'Planlegge oppgaver som skal kjøres'),
65 
   (13, 'items_batchmod', 'Utføre masseendringer av eksemplarer'),
 67 
   (13, 'items_batchmod', 'Utføre masseendringer av eksemplarer'),
68 
   (13, 'items_batchmod_restricted', 'Limit batch item modification to item status (please note that items_batchmod is still required)'),
66 
   (13, 'items_batchdel', 'Utføre masseslettinger av eksemplarer'),
 69 
   (13, 'items_batchdel', 'Utføre masseslettinger av eksemplarer'),
67 
   (13, 'manage_csv_profiles', 'Administrere CSV eksportprofiler'),
 70 
   (13, 'manage_csv_profiles', 'Administrere CSV eksportprofiler'),
68 
   (13, 'moderate_tags', 'Behandle tagger fra lånere'),
 71 
   (13, 'moderate_tags', 'Behandle tagger fra lånere'),
(-)a/installer/data/mysql/pl-PL/mandatory/userpermissions.sql (+3 lines)
Lines 11-16 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
11 
   ( 9, 'edit_catalogue', 'Edit catalogue'),
 11 
   ( 9, 'edit_catalogue', 'Edit catalogue'),
12 
   ( 9, 'fast_cataloging', 'Szybkie katalogowanie'),
 12 
   ( 9, 'fast_cataloging', 'Szybkie katalogowanie'),
13 
   ( 9, 'edit_items', 'Edit Items'),
 13 
   ( 9, 'edit_items', 'Edit Items'),
14 
   ( 9, 'edit_items_restricted', 'Limit item modification to barcode, status and note (please note that edit_item is still required)'),
15 
   ( 9, 'delete_all_items', 'Delete all items at once'),
14 
   (10, 'writeoff', 'Write off fines and fees'),
 16 
   (10, 'writeoff', 'Write off fines and fees'),
15 
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
 17 
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
16 
   (11, 'vendors_manage', 'Zarządzanei dostawcami'),
 18 
   (11, 'vendors_manage', 'Zarządzanei dostawcami'),
Lines 43-48 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
43 
   (13, 'batch_upload_patron_images', 'Upload patron images in a batch or one at a time'),
 45 
   (13, 'batch_upload_patron_images', 'Upload patron images in a batch or one at a time'),
44 
   (13, 'schedule_tasks', 'Schedule tasks to run'),
 46 
   (13, 'schedule_tasks', 'Schedule tasks to run'),
45 
   (13, 'items_batchmod', 'Perform batch modification of items'),
 47 
   (13, 'items_batchmod', 'Perform batch modification of items'),
48 
   (13, 'items_batchmod_restricted', 'Limit batch item modification to item status (please note that items_batchmod is still required)'),
46 
   (13, 'items_batchdel', 'Perform batch deletion of items'),
 49 
   (13, 'items_batchdel', 'Perform batch deletion of items'),
47 
   (13, 'manage_csv_profiles', 'Manage CSV export profiles'),
 50 
   (13, 'manage_csv_profiles', 'Manage CSV export profiles'),
48 
   (13, 'moderate_tags', 'Moderate patron tags'),
 51 
   (13, 'moderate_tags', 'Moderate patron tags'),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +22 lines)
Lines 8216-8221 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
8216 
    SetVersion($DBversion);
 8216 
    SetVersion($DBversion);
8217 
}
 8217 
}
8218 

          8218
          

        

            

              
              
              8219
              
$DBversion = "3.15.00.XXX";

            

            

              8220
              
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {

            

            

              8221
              
    $dbh->do(q{

            

            

              8222
              
        INSERT INTO permissions (module_bit, code, description) VALUES ('9', 'edit_items_restricted', 'Limit item modification to barcode, status and note (please note that edit_item is still required)');

            

            

              8223
              
    });

            

            

              8224
              

            

            

              8225
              
    $dbh->do(q{

            

            

              8226
              
        INSERT INTO permissions (module_bit, code, description) VALUES ('9', 'delete_all_items', 'Delete all items at once');

            

            

              8227
              
    });

            

            

              8228
              

            

            

              8229
              
    $dbh->do(q{

            

            

              8230
              
        INSERT INTO permissions (module_bit, code, description) VALUES ('13', 'items_batchmod_restricted', 'Limit batch item modification to item status (please note that items_batchmod is still required)');

            

            

              8231
              
    });

            

            

              8232
              

            

            

              8233
              
    # The delete_all_items permission should be added to users having the edit_items permission.

            

            

              8234
              
    $dbh->do(q{

            

            

              8235
              
        INSERT INTO user_permissions (borrowernumber, module_bit, code) SELECT borrowernumber, module_bit, "delete_all_items" FROM user_permissions WHERE code="edit_items";

            

            

              8236
              
    });

            

            

              8237
              
    print "Upgrade to $DBversion done (Bug 7673: Adds new permissions edit_items_restricted, delete_all_items and items_batchmod_restricted)\n";

            

            

              8238
              
    SetVersion($DBversion);

            

            

              8239
              
}

            

            

              8240
              

            

        

          8219
          
=head1 FUNCTIONS

          8241
          
=head1 FUNCTIONS

        

        

          8220
          

          8242
          

        

        

          8221
          
=head2 TableExists($table)

          8243
          
=head2 TableExists($table)

        

            

              8222
              
- 

              
              
            






  

  Return to bug 7673