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

(-)a/installer/data/mysql/kohastructure.sql (-1 lines)
Lines 912-918 CREATE TABLE `deleteditems` ( Link Here
912 
  `enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)
 912 
  `enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)
913 
  `copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)
 913 
  `copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)
914 
  `stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)
 914 
  `stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)
915 
  `marc` longblob, -- unused in Koha
916 
  PRIMARY KEY  (`itemnumber`),
 915 
  PRIMARY KEY  (`itemnumber`),
917 
  KEY `delitembarcodeidx` (`barcode`),
 916 
  KEY `delitembarcodeidx` (`barcode`),
918 
  KEY `delitemstocknumberidx` (`stocknumber`),
 917 
  KEY `delitemstocknumberidx` (`stocknumber`),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +7 lines)
Lines 7778-7783 if(CheckVersion($DBversion)) { Link Here
7778 
    SetVersion($DBversion);
 7778 
    SetVersion($DBversion);
7779 
}
 7779 
}
7780 

          7780
          

        

            

              
              
              7781
              
$DBversion = "3.15.00.XXX";

            

            

              7782
              
if(CheckVersion($DBversion)) {

            

            

              7783
              
    $dbh->do("ALTER TABLE deleteditems DROP COLUMN marc");

            

            

              7784
              
    print "Upgrade to $DBversion done (Bug 6331: Obsolete marc column in deleteditems)\n";

            

            

              7785
              
    SetVersion($DBversion);

            

            

              7786
              
}

            

            

              7787
              

            

        

          7781
          
=head1 FUNCTIONS

          7788
          
=head1 FUNCTIONS

        

        

          7782
          

          7789
          

        

        

          7783
          
=head2 TableExists($table)

          7790
          
=head2 TableExists($table)

        

            

              7784
              
- 

              
              
            






  

  Return to bug 6331