Lines 679-686
CREATE TABLE `deleteditems` (
Link Here
|
679 |
`renewals` smallint(6) default NULL, -- number of times this item has been renewed |
679 |
`renewals` smallint(6) default NULL, -- number of times this item has been renewed |
680 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
680 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
681 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
681 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
682 |
`itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$x) |
682 |
`itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z) |
683 |
`itemnotes_nonpublic` LONGTEXT default NULL, |
683 |
`itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x) |
684 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
684 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
685 |
`paidfor` LONGTEXT, |
685 |
`paidfor` LONGTEXT, |
686 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
686 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
Lines 942-949
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
942 |
`renewals` smallint(6) default NULL, -- number of times this item has been renewed |
942 |
`renewals` smallint(6) default NULL, -- number of times this item has been renewed |
943 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
943 |
`reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved |
944 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
944 |
`restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) |
945 |
`itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$x) |
945 |
`itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z) |
946 |
`itemnotes_nonpublic` LONGTEXT default NULL, |
946 |
`itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x) |
947 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
947 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) |
948 |
`paidfor` LONGTEXT, |
948 |
`paidfor` LONGTEXT, |
949 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
949 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered |
950 |
- |
|
|