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

(-)a/installer/data/mysql/atomicupdate/bug_10269.perl (+9 lines)
Line 0 Link Here
1 
$DBversion = 'XXX'; # will be replaced by the RM
2 
if( CheckVersion( $DBversion ) ) {
3 
    if (!column_exists('message_queue', 'reply_address')) {
4 
        $dbh->do('ALTER TABLE message_queue ADD COLUMN reply_address LONGTEXT AFTER from_address');
5 
    }
6 

            

            

              7
              
    SetVersion( $DBversion );

            

            

              8
              
    print "Upgrade to $DBversion done (Bug 22821 - Add reply_address to message_queue)\n";

            

            

              9
              
}

            



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




  

    
      
            Lines 2394-2399
          CREATE TABLE `message_queue` (
      
      
        Link Here
      
    
  

        

          2394
          
  `updated_on` timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

          2394
          
  `updated_on` timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

        

        

          2395
          
  `to_address` LONGTEXT,

          2395
          
  `to_address` LONGTEXT,

        

        

          2396
          
  `from_address` LONGTEXT,

          2396
          
  `from_address` LONGTEXT,

        

            

              
              
              2397
              
  `reply_address` LONGTEXT,

            

        

          2397
          
  `content_type` MEDIUMTEXT,

          2398
          
  `content_type` MEDIUMTEXT,

        

        

          2398
          
  PRIMARY KEY `message_id` (`message_id`),

          2399
          
  PRIMARY KEY `message_id` (`message_id`),

        

        

          2399
          
  KEY `borrowernumber` (`borrowernumber`),

          2400
          
  KEY `borrowernumber` (`borrowernumber`),

        

            

              2400
              
- 

              
              
            






  

  Return to bug 10269