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

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
Lines 762-767 CREATE TABLE `deleteditems` ( Link Here
762
  `itemlost` tinyint(1) NOT NULL default 0, -- authorized value defining this item as lost (MARC21 952$1)
762
  `itemlost` tinyint(1) NOT NULL default 0, -- authorized value defining this item as lost (MARC21 952$1)
763
  `wthdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining this item as withdrawn (MARC21 952$0)
763
  `wthdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining this item as withdrawn (MARC21 952$0)
764
  `itemcallnumber` varchar(255) default NULL, -- call number for this item (MARC21 952$o)
764
  `itemcallnumber` varchar(255) default NULL, -- call number for this item (MARC21 952$o)
765
  `coded_location_qualifier` varchar(10) default NULL, -- coded location qualifier(MARC21 952$f)
765
  `issues` smallint(6) default NULL, -- number of times this item has been checked out
766
  `issues` smallint(6) default NULL, -- number of times this item has been checked out
766
  `renewals` smallint(6) default NULL, -- number of times this item has been renewed
767
  `renewals` smallint(6) default NULL, -- number of times this item has been renewed
767
  `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved
768
  `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +6 lines)
Lines 6048-6053 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
6048
   SetVersion ($DBversion);
6048
   SetVersion ($DBversion);
6049
}
6049
}
6050
6050
6051
$DBversion = "3.09.00.XXX";
6052
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
6053
   $dbh->do('ALTER TABLE deleteditems ADD coded_location_qualifier varchar(10) default NULL');
6054
   print "Upgrade to $DBversion done (Bug 6428: Added coded_location_qualifier to the deleteditems table)\n";
6055
   SetVersion ($DBversion);
6056
}
6051
6057
6052
=head1 FUNCTIONS
6058
=head1 FUNCTIONS
6053
6059
6054
- 

Return to bug 6428