|
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`), |