Lines 696-701
CREATE TABLE `deleteditems` (
Link Here
|
696 |
`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t) |
696 |
`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t) |
697 |
`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i) |
697 |
`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i) |
698 |
`new_status` VARCHAR(32) DEFAULT NULL, -- 'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob. |
698 |
`new_status` VARCHAR(32) DEFAULT NULL, -- 'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob. |
|
|
699 |
`link_text` VARCHAR(200) DEFAULT NULL, -- text displayed when uri present in item record. |
699 |
PRIMARY KEY (`itemnumber`), |
700 |
PRIMARY KEY (`itemnumber`), |
700 |
KEY `delitembarcodeidx` (`barcode`), |
701 |
KEY `delitembarcodeidx` (`barcode`), |
701 |
KEY `delitemstocknumberidx` (`stocknumber`), |
702 |
KEY `delitemstocknumberidx` (`stocknumber`), |
Lines 956-961
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
956 |
`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t) |
957 |
`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t) |
957 |
`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i) |
958 |
`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i) |
958 |
`new_status` VARCHAR(32) DEFAULT NULL, -- 'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob. |
959 |
`new_status` VARCHAR(32) DEFAULT NULL, -- 'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob. |
|
|
960 |
`link_text` VARCHAR(200) DEFAULT NULL, -- text displayed when uri present in item record. |
959 |
PRIMARY KEY (`itemnumber`), |
961 |
PRIMARY KEY (`itemnumber`), |
960 |
UNIQUE KEY `itembarcodeidx` (`barcode`), |
962 |
UNIQUE KEY `itembarcodeidx` (`barcode`), |
961 |
KEY `itemstocknumberidx` (`stocknumber`), |
963 |
KEY `itemstocknumberidx` (`stocknumber`), |