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

(-)a/installer/data/mysql/atomicupdate/bug_22987.perl (+11 lines)
Line 0 Link Here
1 
$DBversion = 'XXX'; # will be replaced by the RM
2 
if( CheckVersion( $DBversion ) ) {
3 
    $dbh->do(q{
4 
        ALTER TABLE biblioimages
5 
            ADD `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
6 
                AFTER `thumbnail`;
7 
    });
8 

            

            

              9
              
    SetVersion( $DBversion );

            

            

              10
              
    print "Upgrade to $DBversion done (Bug 22987 - Add biblioimages.timestamp)\n";

            

            

              11
              
}

            



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




  

    
      
            Lines 3305-3310
          CREATE TABLE `biblioimages` ( -- local cover images
      
      
        Link Here
      
    
  

        

          3305
          
 `mimetype` varchar(15) NOT NULL, -- image type

          3305
          
 `mimetype` varchar(15) NOT NULL, -- image type

        

        

          3306
          
 `imagefile` mediumblob NOT NULL, -- image file contents

          3306
          
 `imagefile` mediumblob NOT NULL, -- image file contents

        

        

          3307
          
 `thumbnail` mediumblob NOT NULL, -- thumbnail file contents

          3307
          
 `thumbnail` mediumblob NOT NULL, -- thumbnail file contents

        

            

              
              
              3308
              
 `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, -- image creation/update time

            

        

          3308
          
 PRIMARY KEY (`imagenumber`),

          3309
          
 PRIMARY KEY (`imagenumber`),

        

        

          3309
          
 CONSTRAINT `bibliocoverimage_fk1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE

          3310
          
 CONSTRAINT `bibliocoverimage_fk1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE

        

        

          3310
          
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

          3311
          
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

        

            

              3311
              
- 

              
              
            






  

  Return to bug 22987