| 
      
            Lines 1-9
          
      
      
        Link Here
      
     | 
  
        
          | 1 | 
          $DBversion = 'XXX'; # will be replaced by the RM  | 
          1 | 
          $DBversion = 'XXX'; # will be replaced by the RM  | 
        
        
          | 2 | 
          if( CheckVersion( $DBversion ) ) { | 
          2 | 
          if( CheckVersion( $DBversion ) ) { | 
        
          
            
              | 3 | 
                  $dbh->do(q|  | 
              3 | 
                  unless ( column_exists('article_requests', 'format') ) { | 
            
            
              | 4 | 
                      ALTER TABLE article_requests  | 
              4 | 
                      $dbh->do(q|  | 
            
            
              | 5 | 
                      ADD COLUMN `format` enum('PHOTOCOPY', 'SCAN') NOT NULL DEFAULT 'PHOTOCOPY' AFTER notes, | 
              5 | 
                          ALTER TABLE article_requests  | 
            
            
              | 6 | 
                      ADD COLUMN `urls` MEDIUMTEXT AFTER format  | 
              6 | 
                          ADD COLUMN `format` enum('PHOTOCOPY', 'SCAN') NOT NULL DEFAULT 'PHOTOCOPY' AFTER notes | 
            
            
              | 7 | 
                  |);  | 
              7 | 
                      |);  | 
            
            
               | 
               | 
              8 | 
                  }  | 
            
            
              | 9 | 
                  unless ( column_exists('article_requests', 'urls') ) { | 
            
            
              | 10 | 
                      $dbh->do(q|  | 
            
            
              | 11 | 
                          ALTER TABLE article_requests  | 
            
            
              | 12 | 
                          ADD COLUMN `urls` MEDIUMTEXT AFTER format  | 
            
            
              | 13 | 
                      |);  | 
            
            
              | 14 | 
                  }  | 
            
        
          | 8 | 
              NewVersion( $DBversion, 20472, "Add columns format and urls in article_requests table");  | 
          15 | 
              NewVersion( $DBversion, 20472, "Add columns format and urls in article_requests table");  | 
        
        
          | 9 | 
          }  | 
          16 | 
          }  | 
        
            
              | 10 | 
              -   | 
               | 
               |