Attachment #19485 for bug #9673

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

Lines 7032-7040 INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES ( Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-2 / +2 lines)
7032	$DBversion = "3.13.00.XXX";	7032	$DBversion = "3.13.00.XXX";
7033	if ( CheckVersion($DBversion) ) {	7033	if ( CheckVersion($DBversion) ) {
7034	$dbh->do("ALTER TABLE items ADD itemlost_on DATETIME NULL AFTER itemlost");	7034	$dbh->do("ALTER TABLE items ADD itemlost_on DATETIME NULL AFTER itemlost");
7035	$dbh->do("ALTER TABLE items ADD wthdrawn_on DATETIME NULL AFTER wthdrawn");	7035	$dbh->do("ALTER TABLE items ADD withdrawn_on DATETIME NULL AFTER wthdrawn");
7036	$dbh->do("ALTER TABLE deleteditems ADD itemlost_on DATETIME NULL AFTER itemlost");	7036	$dbh->do("ALTER TABLE deleteditems ADD itemlost_on DATETIME NULL AFTER itemlost");
7037	$dbh->do("ALTER TABLE deleteditems ADD wthdrawn_on DATETIME NULL AFTER wthdrawn");	7037	$dbh->do("ALTER TABLE deleteditems ADD withdrawn_on DATETIME NULL AFTER wthdrawn");
7038	print "Upgrade to $DBversion done (Bug 9673 - Track when items are marked as lost or withdrawn)\n";	7038	print "Upgrade to $DBversion done (Bug 9673 - Track when items are marked as lost or withdrawn)\n";
7039	SetVersion ($DBversion);	7039	SetVersion ($DBversion);
7040	}	7040	}

Lines 166-172 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/moredetail.tt (-2 / +1 lines)
166	</form>	166	</form>
167	[% END %]	167	[% END %]
168	</li>	168	</li>
169	[% IF ITEM_DAT.wthdrawn_on %]<li><span class="label">Withdrawn on:</span>[% ITEM_DAT.wthdrawn_on \| $KohaDates %]  </li>[% END %]	169	[% IF ITEM_DAT.withdrawn_on %]<li><span class="label">Withdrawn on:</span>[% ITEM_DAT.withdrawn_on \| $KohaDates %]  </li>[% END %]
170	</ol></div>	170	</ol></div>
171	<div class="listgroup"><h4>History</h4>	171	<div class="listgroup"><h4>History</h4>
172	<ol class="bibliodetails">	172	<ol class="bibliodetails">
173	-

Return to bug 9673

Lines 868-874 CREATE TABLE `deleteditems` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
868	`itemlost` tinyint(1) NOT NULL default 0, -- authorized value defining this item as lost (MARC21 952$1)	868	`itemlost` tinyint(1) NOT NULL default 0, -- authorized value defining this item as lost (MARC21 952$1)
869	`itemlost_on` datetime DEFAULT NULL, -- the date and time an item was last marked as lost, NULL if not lost	869	`itemlost_on` datetime DEFAULT NULL, -- the date and time an item was last marked as lost, NULL if not lost
870	`wthdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining this item as withdrawn (MARC21 952$0)	870	`wthdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining this item as withdrawn (MARC21 952$0)
871	`wthdrawn_on` datetime DEFAULT NULL, -- the date and time an item was last marked as withdrawn, NULL if not withdrawn	871	`withdrawn_on` datetime DEFAULT NULL, -- the date and time an item was last marked as withdrawn, NULL if not withdrawn
872	`itemcallnumber` varchar(255) default NULL, -- call number for this item (MARC21 952$o)	872	`itemcallnumber` varchar(255) default NULL, -- call number for this item (MARC21 952$o)
873	`coded_location_qualifier` varchar(10) default NULL, -- coded location qualifier(MARC21 952$f)	873	`coded_location_qualifier` varchar(10) default NULL, -- coded location qualifier(MARC21 952$f)
874	`issues` smallint(6) default NULL, -- number of times this item has been checked out	874	`issues` smallint(6) default NULL, -- number of times this item has been checked out
Lines 1162-1168 CREATE TABLE `items` ( -- holdings/item information Link Here
1162	`itemlost` tinyint(1) NOT NULL default 0, -- authorized value defining this item as lost (MARC21 952$1)	1162	`itemlost` tinyint(1) NOT NULL default 0, -- authorized value defining this item as lost (MARC21 952$1)
1163	`itemlost_on` datetime DEFAULT NULL, -- the date and time an item was last marked as lost, NULL if not lost	1163	`itemlost_on` datetime DEFAULT NULL, -- the date and time an item was last marked as lost, NULL if not lost
1164	`wthdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining this item as withdrawn (MARC21 952$0)	1164	`wthdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining this item as withdrawn (MARC21 952$0)
1165	`wthdrawn_on` datetime DEFAULT NULL, -- the date and time an item was last marked as withdrawn, NULL if not withdrawn	1165	`withdrawn_on` datetime DEFAULT NULL, -- the date and time an item was last marked as withdrawn, NULL if not withdrawn
1166	`itemcallnumber` varchar(255) default NULL, -- call number for this item (MARC21 952$o)	1166	`itemcallnumber` varchar(255) default NULL, -- call number for this item (MARC21 952$o)
1167	`coded_location_qualifier` varchar(10) default NULL, -- coded location qualifier(MARC21 952$f)	1167	`coded_location_qualifier` varchar(10) default NULL, -- coded location qualifier(MARC21 952$f)
1168	`issues` smallint(6) default NULL, -- number of times this item has been checked out/issued	1168	`issues` smallint(6) default NULL, -- number of times this item has been checked out/issued