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

(-)a/installer/data/mysql/atomicupdate/bug_20256.perl (+11 lines)
Line 0 Link Here
1 
$DBversion = 'XXX'; # will be replaced by the RM
2 
if( CheckVersion( $DBversion ) ) {
3 
    $dbh->do( "INSERT IGNORE INTO permissions (module_bit, code, description) VALUES ( 9, 'edit_any_item', 'Edit any item reguardless of home library');" );
4 

            

            

              5
              
    if ( !column_exists( 'library_groups', 'ft_limit_item_editing' ) ) {

            

            

              6
              
        $dbh->do( "ALTER TABLE library_groups ADD COLUMN ft_limit_item_editing tinyint(1) NOT NULL DEFAULT 0 AFTER ft_hide_patron_info" );

            

            

              7
              
    }

            

            

              8
              

            

            

              9
              
    SetVersion( $DBversion );

            

            

              10
              
    print "Upgrade to $DBversion done (Bug 20256 - Add ability to limit editing of items to home library)\n";

            

            

              11
              
}

            



(-)a/installer/data/mysql/kohastructure.sql
      (-1 / +2 lines)




  

    
      
            Lines 4202-4209
          CREATE TABLE library_groups (
      
      
        Link Here
      
    
  

        

          4202
          
    title VARCHAR(100) NULL DEFAULT NULL,     -- Short description of the goup

          4202
          
    title VARCHAR(100) NULL DEFAULT NULL,     -- Short description of the goup

        

        

          4203
          
    description MEDIUMTEXT NULL DEFAULT NULL,    -- Longer explanation of the group, if necessary

          4203
          
    description MEDIUMTEXT NULL DEFAULT NULL,    -- Longer explanation of the group, if necessary

        

        

          4204
          
    ft_hide_patron_info tinyint(1) NOT NULL DEFAULT 0, -- Turn on the feature "Hide patron's info" for this group

          4204
          
    ft_hide_patron_info tinyint(1) NOT NULL DEFAULT 0, -- Turn on the feature "Hide patron's info" for this group

        

            

              
              
              4205
              
    ft_limit_item_editing tinyint(1) NOT NULL DEFAULT 0, -- Turn on the feature "Hide patron's info" for this group

            

        

          4205
          
    ft_search_groups_opac tinyint(1) NOT NULL DEFAULT 0, -- Use this group for staff side search groups

          4206
          
    ft_search_groups_opac tinyint(1) NOT NULL DEFAULT 0, -- Use this group for staff side search groups

        

          
            

              4206
              
     ft_search_groups_staff tinyint(1) NOT NULL DEFAULT 0, -- Use this group for opac side search groups


              4207
              
    ft_search_groups_staff tinyint(1) NOT NULL DEFAULT 0, -- Use this group for opac side search groups

            

        

          4207
          
    created_on TIMESTAMP NULL,             -- Date and time of creation

          4208
          
    created_on TIMESTAMP NULL,             -- Date and time of creation

        

        

          4208
          
    updated_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- Date and time of last

          4209
          
    updated_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- Date and time of last

        

        

          4209
          
    PRIMARY KEY id ( id ),

          4210
          
    PRIMARY KEY id ( id ),

        



(-)a/installer/data/mysql/userpermissions.sql
      (-1 / +1 lines)




  

    
      
            Lines 41-46
          INSERT INTO permissions (module_bit, code, description) VALUES
      
      
        Link Here
      
    
  

        

          41
          
   ( 9, 'edit_items', 'Edit items'),

          41
          
   ( 9, 'edit_items', 'Edit items'),

        

        

          42
          
   ( 9, 'edit_items_restricted', 'Limit item modification to subfields defined in the SubfieldsToAllowForRestrictedEditing preference (please note that edit_item is still required)'),

          42
          
   ( 9, 'edit_items_restricted', 'Limit item modification to subfields defined in the SubfieldsToAllowForRestrictedEditing preference (please note that edit_item is still required)'),

        

        

          43
          
   ( 9, 'delete_all_items', 'Delete all items at once'),

          43
          
   ( 9, 'delete_all_items', 'Delete all items at once'),

        

            

              
              
              44
              
   ( 9, 'edit_any_item', 'Edit any item reguardless of home library'),

            

        

          44
          
   (10, 'writeoff', 'Write off fines and fees'),

          45
          
   (10, 'writeoff', 'Write off fines and fees'),

        

        

          45
          
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),

          46
          
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),

        

        

          46
          
   (11, 'currencies_manage', 'Manage currencies and exchange rates'),

          47
          
   (11, 'currencies_manage', 'Manage currencies and exchange rates'),

        

            

              47
              
- 

              
              
            






  

  Return to bug 20256