Lines 2756-2761
CREATE TABLE `deleteditems` (
Link Here
|
2756 |
`coded_location_qualifier` varchar(10) DEFAULT NULL COMMENT 'coded location qualifier(MARC21 952$f)', |
2756 |
`coded_location_qualifier` varchar(10) DEFAULT NULL COMMENT 'coded location qualifier(MARC21 952$f)', |
2757 |
`issues` smallint(6) DEFAULT 0 COMMENT 'number of times this item has been checked out', |
2757 |
`issues` smallint(6) DEFAULT 0 COMMENT 'number of times this item has been checked out', |
2758 |
`renewals` smallint(6) DEFAULT NULL COMMENT 'number of times this item has been renewed', |
2758 |
`renewals` smallint(6) DEFAULT NULL COMMENT 'number of times this item has been renewed', |
|
|
2759 |
`localuse` smallint(6) DEFAULT NULL COMMENT 'number of times this item has been recorded as localuse', |
2759 |
`reserves` smallint(6) DEFAULT NULL COMMENT 'number of times this item has been placed on hold/reserved', |
2760 |
`reserves` smallint(6) DEFAULT NULL COMMENT 'number of times this item has been placed on hold/reserved', |
2760 |
`restricted` tinyint(1) DEFAULT NULL COMMENT 'authorized value defining use restrictions for this item (MARC21 952$5)', |
2761 |
`restricted` tinyint(1) DEFAULT NULL COMMENT 'authorized value defining use restrictions for this item (MARC21 952$5)', |
2761 |
`itemnotes` longtext DEFAULT NULL COMMENT 'public notes on this item (MARC21 952$z)', |
2762 |
`itemnotes` longtext DEFAULT NULL COMMENT 'public notes on this item (MARC21 952$z)', |
Lines 3983-3988
CREATE TABLE `items` (
Link Here
|
3983 |
`coded_location_qualifier` varchar(10) DEFAULT NULL COMMENT 'coded location qualifier(MARC21 952$f)', |
3984 |
`coded_location_qualifier` varchar(10) DEFAULT NULL COMMENT 'coded location qualifier(MARC21 952$f)', |
3984 |
`issues` smallint(6) DEFAULT 0 COMMENT 'number of times this item has been checked out/issued', |
3985 |
`issues` smallint(6) DEFAULT 0 COMMENT 'number of times this item has been checked out/issued', |
3985 |
`renewals` smallint(6) DEFAULT NULL COMMENT 'number of times this item has been renewed', |
3986 |
`renewals` smallint(6) DEFAULT NULL COMMENT 'number of times this item has been renewed', |
|
|
3987 |
`localuse` smallint(6) DEFAULT NULL COMMENT 'number of times this item has been recorded as localuse', |
3986 |
`reserves` smallint(6) DEFAULT NULL COMMENT 'number of times this item has been placed on hold/reserved', |
3988 |
`reserves` smallint(6) DEFAULT NULL COMMENT 'number of times this item has been placed on hold/reserved', |
3987 |
`restricted` tinyint(1) DEFAULT NULL COMMENT 'authorized value defining use restrictions for this item (MARC21 952$5)', |
3989 |
`restricted` tinyint(1) DEFAULT NULL COMMENT 'authorized value defining use restrictions for this item (MARC21 952$5)', |
3988 |
`itemnotes` longtext DEFAULT NULL COMMENT 'public notes on this item (MARC21 952$z)', |
3990 |
`itemnotes` longtext DEFAULT NULL COMMENT 'public notes on this item (MARC21 952$z)', |
3989 |
- |
|
|