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

(-)a/installer/data/mysql/atomicupdate/bug_23151.perl (+13 lines)
Line 0 Link Here
1 
use C4::Installer;
2 

            

            

              3
              
my $DBVersion = 'XXX';

            

            

              4
              
if ( CheckVersion( $DBversion ) ) {

            

            

              5
              
    print "Running... ";

            

            

              6
              
    unless ( column_exists( 'borrower_modifications', 'changed_fields' ) ) {

            

            

              7
              
        print "Running... ";

            

            

              8
              
        $dbh->do("ALTER TABLE borrower_modifications ADD changed_fields MEDIUMTEXT AFTER verification_token;");

            

            

              9
              
    }

            

            

              10
              
    print "Ran\n";

            

            

              11
              
    SetVersion( $DBversion );

            

            

              12
              
    print "Upgrade to $DBversion done (Bug 23151 - Add borrower_modifications.changed_fields column)\n";

            

            

              13
              
}

            



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




  

    
      
            Lines 3397-3402
          CREATE TABLE borrower_attribute_types_branches( -- association table between bor
      
      
        Link Here
      
    
  

        

          3397
          
CREATE TABLE IF NOT EXISTS `borrower_modifications` (

          3397
          
CREATE TABLE IF NOT EXISTS `borrower_modifications` (

        

        

          3398
          
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

          3398
          
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

        

        

          3399
          
  `verification_token` varchar(255) NOT NULL DEFAULT '',

          3399
          
  `verification_token` varchar(255) NOT NULL DEFAULT '',

        

            

              
              
              3400
              
  `changed_fields` MEDIUMTEXT NOT NULL DEFAULT '',

            

        

          3400
          
  `borrowernumber` int(11) NOT NULL DEFAULT '0',

          3401
          
  `borrowernumber` int(11) NOT NULL DEFAULT '0',

        

        

          3401
          
  `cardnumber` varchar(32) DEFAULT NULL,

          3402
          
  `cardnumber` varchar(32) DEFAULT NULL,

        

        

          3402
          
  `surname` LONGTEXT,

          3403
          
  `surname` LONGTEXT,

        

            

              3403
              
- 

              
              
            






  

  Return to bug 23151