Lines 868-874
CREATE TABLE `deleteditems` (
Link Here
|
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 |
`withdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining this item as withdrawn (MARC21 952$0) |
870 |
`withdrawn` 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 1160-1172
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
1160 |
`notforloan` tinyint(1) NOT NULL default 0, -- authorized value defining why this item is not for loan (MARC21 952$7) |
1160 |
`notforloan` tinyint(1) NOT NULL default 0, -- authorized value defining why this item is not for loan (MARC21 952$7) |
1161 |
`damaged` tinyint(1) NOT NULL default 0, -- authorized value defining this item as damaged (MARC21 952$4) |
1161 |
`damaged` tinyint(1) NOT NULL default 0, -- authorized value defining this item as damaged (MARC21 952$4) |
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 |
<<<<<<< HEAD |
|
|
1164 |
`withdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining this item as withdrawn (MARC21 952$0) |
1165 |
======= |
1166 |
`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 |
1167 |
`wthdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining this item as withdrawn (MARC21 952$0) |
1164 |
`withdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining this item as withdrawn (MARC21 952$0) |
1168 |
`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 |
1169 |
>>>>>>> Bug 9673 - Track when items are marked as lost or withdrawn |
|
|
1170 |
`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) |
1171 |
`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) |
1172 |
`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 |