Lines 2656-2661
CREATE TABLE `deleteditems` (
Link Here
|
2656 |
`coded_location_qualifier` varchar(10) DEFAULT NULL COMMENT 'coded location qualifier(MARC21 952$f)', |
2656 |
`coded_location_qualifier` varchar(10) DEFAULT NULL COMMENT 'coded location qualifier(MARC21 952$f)', |
2657 |
`issues` smallint(6) DEFAULT 0 COMMENT 'number of times this item has been checked out', |
2657 |
`issues` smallint(6) DEFAULT 0 COMMENT 'number of times this item has been checked out', |
2658 |
`renewals` smallint(6) DEFAULT NULL COMMENT 'number of times this item has been renewed', |
2658 |
`renewals` smallint(6) DEFAULT NULL COMMENT 'number of times this item has been renewed', |
|
|
2659 |
`localuse` smallint(6) DEFAULT NULL COMMENT 'number of times this item has been recorded as localuse', |
2659 |
`reserves` smallint(6) DEFAULT NULL COMMENT 'number of times this item has been placed on hold/reserved', |
2660 |
`reserves` smallint(6) DEFAULT NULL COMMENT 'number of times this item has been placed on hold/reserved', |
2660 |
`restricted` tinyint(1) DEFAULT NULL COMMENT 'authorized value defining use restrictions for this item (MARC21 952$5)', |
2661 |
`restricted` tinyint(1) DEFAULT NULL COMMENT 'authorized value defining use restrictions for this item (MARC21 952$5)', |
2661 |
`itemnotes` longtext DEFAULT NULL COMMENT 'public notes on this item (MARC21 952$z)', |
2662 |
`itemnotes` longtext DEFAULT NULL COMMENT 'public notes on this item (MARC21 952$z)', |
Lines 3625-3630
CREATE TABLE `items` (
Link Here
|
3625 |
`coded_location_qualifier` varchar(10) DEFAULT NULL COMMENT 'coded location qualifier(MARC21 952$f)', |
3626 |
`coded_location_qualifier` varchar(10) DEFAULT NULL COMMENT 'coded location qualifier(MARC21 952$f)', |
3626 |
`issues` smallint(6) DEFAULT 0 COMMENT 'number of times this item has been checked out/issued', |
3627 |
`issues` smallint(6) DEFAULT 0 COMMENT 'number of times this item has been checked out/issued', |
3627 |
`renewals` smallint(6) DEFAULT NULL COMMENT 'number of times this item has been renewed', |
3628 |
`renewals` smallint(6) DEFAULT NULL COMMENT 'number of times this item has been renewed', |
|
|
3629 |
`localuse` smallint(6) DEFAULT NULL COMMENT 'number of times this item has been recorded as localuse', |
3628 |
`reserves` smallint(6) DEFAULT NULL COMMENT 'number of times this item has been placed on hold/reserved', |
3630 |
`reserves` smallint(6) DEFAULT NULL COMMENT 'number of times this item has been placed on hold/reserved', |
3629 |
`restricted` tinyint(1) DEFAULT NULL COMMENT 'authorized value defining use restrictions for this item (MARC21 952$5)', |
3631 |
`restricted` tinyint(1) DEFAULT NULL COMMENT 'authorized value defining use restrictions for this item (MARC21 952$5)', |
3630 |
`itemnotes` longtext DEFAULT NULL COMMENT 'public notes on this item (MARC21 952$z)', |
3632 |
`itemnotes` longtext DEFAULT NULL COMMENT 'public notes on this item (MARC21 952$z)', |
3631 |
- |
|
|