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

(-)a/installer/data/mysql/kohastructure.sql (-1 lines)
Lines 917-923 CREATE TABLE `deleteditems` ( Link Here
917
  `enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)
917
  `enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)
918
  `copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)
918
  `copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)
919
  `stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)
919
  `stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)
920
  `marc` longblob, -- unused in Koha
921
  PRIMARY KEY  (`itemnumber`),
920
  PRIMARY KEY  (`itemnumber`),
922
  KEY `delitembarcodeidx` (`barcode`),
921
  KEY `delitembarcodeidx` (`barcode`),
923
  KEY `delitemstocknumberidx` (`stocknumber`),
922
  KEY `delitemstocknumberidx` (`stocknumber`),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +7 lines)
Lines 7853-7858 if ( CheckVersion($DBversion) ) { Link Here
7853
   SetVersion ($DBversion);
7853
   SetVersion ($DBversion);
7854
}
7854
}
7855
7855
7856
$DBversion = "3.15.00.XXX";
7857
if(CheckVersion($DBversion)) {
7858
    $dbh->do("ALTER TABLE deleteditems DROP COLUMN marc");
7859
    print "Upgrade to $DBversion done (Bug 6331: Obsolete marc column in deleteditems)\n";
7860
    SetVersion($DBversion);
7861
}
7862
7856
=head1 FUNCTIONS
7863
=head1 FUNCTIONS
7857
7864
7858
=head2 TableExists($table)
7865
=head2 TableExists($table)
7859
- 

Return to bug 6331