|
Lines 2828-2834
CREATE TABLE `deleteditems` (
Link Here
|
| 2828 |
`more_subfields_xml` longtext DEFAULT NULL COMMENT 'additional 952 subfields in XML format', |
2828 |
`more_subfields_xml` longtext DEFAULT NULL COMMENT 'additional 952 subfields in XML format', |
| 2829 |
`enumchron` mediumtext DEFAULT NULL COMMENT 'serial enumeration/chronology for the item (MARC21 952$h)', |
2829 |
`enumchron` mediumtext DEFAULT NULL COMMENT 'serial enumeration/chronology for the item (MARC21 952$h)', |
| 2830 |
`copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)', |
2830 |
`copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)', |
| 2831 |
`stocknumber` varchar(32) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', |
2831 |
`stocknumber` varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', |
| 2832 |
`new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.', |
2832 |
`new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.', |
| 2833 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority', |
2833 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority', |
| 2834 |
PRIMARY KEY (`itemnumber`), |
2834 |
PRIMARY KEY (`itemnumber`), |
|
Lines 4149-4155
CREATE TABLE `items` (
Link Here
|
| 4149 |
`more_subfields_xml` longtext DEFAULT NULL COMMENT 'additional 952 subfields in XML format', |
4149 |
`more_subfields_xml` longtext DEFAULT NULL COMMENT 'additional 952 subfields in XML format', |
| 4150 |
`enumchron` mediumtext DEFAULT NULL COMMENT 'serial enumeration/chronology for the item (MARC21 952$h)', |
4150 |
`enumchron` mediumtext DEFAULT NULL COMMENT 'serial enumeration/chronology for the item (MARC21 952$h)', |
| 4151 |
`copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)', |
4151 |
`copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)', |
| 4152 |
`stocknumber` varchar(32) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', |
4152 |
`stocknumber` varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', |
| 4153 |
`new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.', |
4153 |
`new_status` varchar(32) DEFAULT NULL COMMENT '''new'' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.', |
| 4154 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority', |
4154 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority', |
| 4155 |
PRIMARY KEY (`itemnumber`), |
4155 |
PRIMARY KEY (`itemnumber`), |
| 4156 |
- |
|
|