|
Lines 2837-2842
CREATE TABLE `deleteditems` (
Link Here
|
| 2837 |
`copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)', |
2837 |
`copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)', |
| 2838 |
`stocknumber` varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', |
2838 |
`stocknumber` varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', |
| 2839 |
`new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intended to be managed by the automatic_item_modification_by_age cronjob.', |
2839 |
`new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intended to be managed by the automatic_item_modification_by_age cronjob.', |
|
|
2840 |
`other` varchar(32) DEFAULT NULL COMMENT 'this field can be used to map any marc data and use with OpacHiddenItems calculation', |
| 2840 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority', |
2841 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority', |
| 2841 |
PRIMARY KEY (`itemnumber`), |
2842 |
PRIMARY KEY (`itemnumber`), |
| 2842 |
KEY `delitembarcodeidx` (`barcode`), |
2843 |
KEY `delitembarcodeidx` (`barcode`), |
|
Lines 4224-4229
CREATE TABLE `items` (
Link Here
|
| 4224 |
`copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)', |
4225 |
`copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)', |
| 4225 |
`stocknumber` varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', |
4226 |
`stocknumber` varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', |
| 4226 |
`new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intended to be managed by the automatic_item_modification_by_age cronjob.', |
4227 |
`new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intended to be managed by the automatic_item_modification_by_age cronjob.', |
|
|
4228 |
`other` varchar(32) DEFAULT NULL COMMENT 'this field can be used to map any marc data and use with OpacHiddenItems calculation', |
| 4227 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority', |
4229 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority', |
| 4228 |
PRIMARY KEY (`itemnumber`), |
4230 |
PRIMARY KEY (`itemnumber`), |
| 4229 |
UNIQUE KEY `itembarcodeidx` (`barcode`), |
4231 |
UNIQUE KEY `itembarcodeidx` (`barcode`), |
| 4230 |
- |
|
|