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