Lines 946-951
CREATE TABLE `deleteditems` (
Link Here
|
946 |
`enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h) |
946 |
`enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h) |
947 |
`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t) |
947 |
`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t) |
948 |
`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i) |
948 |
`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i) |
|
|
949 |
`new` 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. |
949 |
PRIMARY KEY (`itemnumber`), |
950 |
PRIMARY KEY (`itemnumber`), |
950 |
KEY `delitembarcodeidx` (`barcode`), |
951 |
KEY `delitembarcodeidx` (`barcode`), |
951 |
KEY `delitemstocknumberidx` (`stocknumber`), |
952 |
KEY `delitemstocknumberidx` (`stocknumber`), |
Lines 1245-1250
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
1245 |
`enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h) |
1246 |
`enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h) |
1246 |
`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t) |
1247 |
`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t) |
1247 |
`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i) |
1248 |
`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i) |
|
|
1249 |
`new` 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. |
1248 |
PRIMARY KEY (`itemnumber`), |
1250 |
PRIMARY KEY (`itemnumber`), |
1249 |
UNIQUE KEY `itembarcodeidx` (`barcode`), |
1251 |
UNIQUE KEY `itembarcodeidx` (`barcode`), |
1250 |
KEY `itemstocknumberidx` (`stocknumber`), |
1252 |
KEY `itemstocknumberidx` (`stocknumber`), |