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

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

          4
          

        

            

              
              
              5
              
    $dbh->do(q{

            

            

              6
              
        INSERT INTO user_permissions ( borrowernumber, module_bit, code )

            

            

              7
              
        SELECT borrowernumber, '9', 'edit_any_item'

            

            

              8
              
        FROM user_permissions

            

            

              9
              
        WHERE module_bit = '9'

            

            

              10
              
          AND code = 'edit_items'

            

            

              11
              
    });

            

            

              12
              

            

        

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

          13
          
    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" );

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

        

        

          7
          
    }

          15
          
    }

        

            

              8
              
- 

              
              
            






  

  Return to bug 20256