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

(-)a/installer/data/mysql/atomicupdate/bug_27944.perl (-2 / +2 lines)
Lines 5-10 if ( CheckVersion($DBversion) ) { Link Here
5 
    $dbh->do(
 5 
    $dbh->do(
6 
"ALTER TABLE `article_requests` MODIFY `status` enum('REQUESTED', 'PENDING','PROCESSING','COMPLETED','CANCELED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'REQUESTED'"
 6 
"ALTER TABLE `article_requests` MODIFY `status` enum('REQUESTED', 'PENDING','PROCESSING','COMPLETED','CANCELED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'REQUESTED'"
7 
    );
 7 
    );
8 
    $dbh->do(q|UPDATE article_requests SET status='REQUESTED' WHERE status='PENDING'|);
8 

          9
          

        

        

          9
          
    $dbh->do(

          10
          
    $dbh->do(

        

        

          10
          
        q{

          11
          
        q{

        

  

    
      
            Lines 14-20
          if ( CheckVersion($DBversion) ) {
      
      
        Link Here
      
    
  

        

          14
          
        WHERE   `module` = 'circulation'

          15
          
        WHERE   `module` = 'circulation'

        

        

          15
          
                AND `code` = 'AR_PENDING'

          16
          
                AND `code` = 'AR_PENDING'

        

        

          16
          
    }

          17
          
    }

        

          
            

              17
              
    );


              18
              
    ) if ( $dbh->selectrow_array('SELECT COUNT(*) FROM letter WHERE code=?', undef, 'AR_REQUESTED') )[0] == 0; # Check to make idempotent

            

        

          18
          

          19
          

        

        

          19
          
    $dbh->do(

          20
          
    $dbh->do(

        

        

          20
          
        q{

          21
          
        q{

        

            

              21
              
- 

              
              
            






  

  Return to bug 27944