Lines 2780-2785
CREATE TABLE `deleteditems` (
Link Here
|
2780 |
`copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)', |
2780 |
`copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)', |
2781 |
`stocknumber` varchar(32) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', |
2781 |
`stocknumber` varchar(32) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', |
2782 |
`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.', |
2782 |
`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.', |
|
|
2783 |
`checkin_alert` longtext DEFAULT NULL, -- Chekin alert field. Put html is this field, it will be displayed and printable while checkin item. |
2783 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority', |
2784 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority', |
2784 |
PRIMARY KEY (`itemnumber`), |
2785 |
PRIMARY KEY (`itemnumber`), |
2785 |
KEY `delitembarcodeidx` (`barcode`), |
2786 |
KEY `delitembarcodeidx` (`barcode`), |
Lines 4037-4042
CREATE TABLE `items` (
Link Here
|
4037 |
`copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)', |
4038 |
`copynumber` varchar(32) DEFAULT NULL COMMENT 'copy number (MARC21 952$t)', |
4038 |
`stocknumber` varchar(32) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', |
4039 |
`stocknumber` varchar(32) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', |
4039 |
`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.', |
4040 |
`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.', |
|
|
4041 |
`checkin_alert` longtext DEFAULT NULL, -- Chekin alert field. Put html is this field, it will be displayed and printable while checkin item. |
4040 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority', |
4042 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority', |
4041 |
PRIMARY KEY (`itemnumber`), |
4043 |
PRIMARY KEY (`itemnumber`), |
4042 |
UNIQUE KEY `itembarcodeidx` (`barcode`), |
4044 |
UNIQUE KEY `itembarcodeidx` (`barcode`), |