Lines 917-923
CREATE TABLE `deleteditems` (
Link Here
|
917 |
`enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h) |
917 |
`enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h) |
918 |
`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t) |
918 |
`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t) |
919 |
`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i) |
919 |
`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i) |
920 |
`new` VARCHAR(32) DEFAULT NULL, -- new flag |
920 |
`new` VARCHAR(32) DEFAULT NULL, -- 'new' value, you can put whatever free-text information. This field is intented to be managed by the toggle_new_status cronjob. |
921 |
PRIMARY KEY (`itemnumber`), |
921 |
PRIMARY KEY (`itemnumber`), |
922 |
KEY `delitembarcodeidx` (`barcode`), |
922 |
KEY `delitembarcodeidx` (`barcode`), |
923 |
KEY `delitemstocknumberidx` (`stocknumber`), |
923 |
KEY `delitemstocknumberidx` (`stocknumber`), |
Lines 1212-1218
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
1212 |
`enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h) |
1212 |
`enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h) |
1213 |
`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t) |
1213 |
`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t) |
1214 |
`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i) |
1214 |
`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i) |
1215 |
`new` VARCHAR(32) DEFAULT NULL, -- new flag |
1215 |
`new` VARCHAR(32) DEFAULT NULL, -- 'new' value, you can put whatever free-text information. This field is intended to be managed by the toggle_new_status cronjob. |
1216 |
PRIMARY KEY (`itemnumber`), |
1216 |
PRIMARY KEY (`itemnumber`), |
1217 |
UNIQUE KEY `itembarcodeidx` (`barcode`), |
1217 |
UNIQUE KEY `itembarcodeidx` (`barcode`), |
1218 |
KEY `itemstocknumberidx` (`stocknumber`), |
1218 |
KEY `itemstocknumberidx` (`stocknumber`), |
1219 |
- |
|
|