Lines 912-917
CREATE TABLE `deleteditems` (
Link Here
|
912 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
912 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
913 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
913 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
914 |
`itemnotes` mediumtext, -- public notes on this item (MARC21 952$x) |
914 |
`itemnotes` mediumtext, -- public notes on this item (MARC21 952$x) |
|
|
915 |
`itemnotes_nonpublic` mediumtext default NULL, |
915 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
916 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
916 |
`paidfor` mediumtext, |
917 |
`paidfor` mediumtext, |
917 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
918 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
Lines 1211-1216
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
1211 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
1212 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
1212 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
1213 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
1213 |
`itemnotes` mediumtext, -- public notes on this item (MARC21 952$x) |
1214 |
`itemnotes` mediumtext, -- public notes on this item (MARC21 952$x) |
|
|
1215 |
`itemnotes_nonpublic` mediumtext default NULL, |
1214 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
1216 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
1215 |
`paidfor` mediumtext, |
1217 |
`paidfor` mediumtext, |
1216 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
1218 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |