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

(-)a/installer/data/mysql/atomicupdate/Bug22532_remove_import_records_z39random.perl (+10 lines)
Line 0 Link Here
1 
$DBversion = 'XXX'; # will be replaced by the RM
2 
if( CheckVersion( $DBversion ) ) {
3 
    if( column_exists( 'import_records', 'z3950random' ) ) {
4 
        $dbh->do( "ALTER TABLE import_records DROP COLUMN z3950random" );
5 
    }
6 

            

            

              7
              
    # Always end with this (adjust the bug info)

            

            

              8
              
    SetVersion( $DBversion );

            

            

              9
              
    print "Upgrade to $DBversion done (Bug 22532 - Remove import_records z3950random column)\n";

            

            

              10
              
}

            



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




  

    
      
            Lines 738-744
          CREATE TABLE `import_records` (
      
      
        Link Here
      
    
  

        

          738
          
  `status` enum('error', 'staged', 'imported', 'reverted', 'items_reverted', 'ignored') NOT NULL default 'staged',

          738
          
  `status` enum('error', 'staged', 'imported', 'reverted', 'items_reverted', 'ignored') NOT NULL default 'staged',

        

        

          739
          
  `import_error` LONGTEXT,

          739
          
  `import_error` LONGTEXT,

        

        

          740
          
  `encoding` varchar(40) NOT NULL default '',

          740
          
  `encoding` varchar(40) NOT NULL default '',

        

            

              741
              
  `z3950random` varchar(40) default NULL,

              
              
            

        

          742
          
  PRIMARY KEY (`import_record_id`),

          741
          
  PRIMARY KEY (`import_record_id`),

        

        

          743
          
  CONSTRAINT `import_records_ifbk_1` FOREIGN KEY (`import_batch_id`)

          742
          
  CONSTRAINT `import_records_ifbk_1` FOREIGN KEY (`import_batch_id`)

        

        

          744
          
             REFERENCES `import_batches` (`import_batch_id`) ON DELETE CASCADE ON UPDATE CASCADE,

          743
          
             REFERENCES `import_batches` (`import_batch_id`) ON DELETE CASCADE ON UPDATE CASCADE,

        

            

              745
              
- 

              
              
            






  

  Return to bug 22532