Lines 2797-2802
CREATE TABLE `deleteditems` (
Link Here
|
2797 |
`stocknumber` varchar(32) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', |
2797 |
`stocknumber` varchar(32) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', |
2798 |
`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.', |
2798 |
`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.', |
2799 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority', |
2799 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority', |
|
|
2800 |
`sort1` varchar(50) default NULL, |
2801 |
`sort2` varchar(50) default NULL, |
2800 |
PRIMARY KEY (`itemnumber`), |
2802 |
PRIMARY KEY (`itemnumber`), |
2801 |
KEY `delitembarcodeidx` (`barcode`), |
2803 |
KEY `delitembarcodeidx` (`barcode`), |
2802 |
KEY `delitemstocknumberidx` (`stocknumber`), |
2804 |
KEY `delitemstocknumberidx` (`stocknumber`), |
Lines 4055-4060
CREATE TABLE `items` (
Link Here
|
4055 |
`stocknumber` varchar(32) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', |
4057 |
`stocknumber` varchar(32) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)', |
4056 |
`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.', |
4058 |
`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.', |
4057 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority', |
4059 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude this item from local holds priority', |
|
|
4060 |
`sort1` varchar(50) default NULL, |
4061 |
`sort2` varchar(50) default NULL, |
4058 |
PRIMARY KEY (`itemnumber`), |
4062 |
PRIMARY KEY (`itemnumber`), |
4059 |
UNIQUE KEY `itembarcodeidx` (`barcode`), |
4063 |
UNIQUE KEY `itembarcodeidx` (`barcode`), |
4060 |
KEY `itemstocknumberidx` (`stocknumber`), |
4064 |
KEY `itemstocknumberidx` (`stocknumber`), |
4061 |
- |
|
|