|
Lines 922-927
CREATE TABLE `deleteditems` (
Link Here
|
| 922 |
`enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h) |
922 |
`enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h) |
| 923 |
`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t) |
923 |
`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t) |
| 924 |
`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i) |
924 |
`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i) |
|
|
925 |
`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. |
| 925 |
PRIMARY KEY (`itemnumber`), |
926 |
PRIMARY KEY (`itemnumber`), |
| 926 |
KEY `delitembarcodeidx` (`barcode`), |
927 |
KEY `delitembarcodeidx` (`barcode`), |
| 927 |
KEY `delitemstocknumberidx` (`stocknumber`), |
928 |
KEY `delitemstocknumberidx` (`stocknumber`), |
|
Lines 1221-1226
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
| 1221 |
`enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h) |
1222 |
`enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h) |
| 1222 |
`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t) |
1223 |
`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t) |
| 1223 |
`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i) |
1224 |
`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i) |
|
|
1225 |
`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. |
| 1224 |
PRIMARY KEY (`itemnumber`), |
1226 |
PRIMARY KEY (`itemnumber`), |
| 1225 |
UNIQUE KEY `itembarcodeidx` (`barcode`), |
1227 |
UNIQUE KEY `itembarcodeidx` (`barcode`), |
| 1226 |
KEY `itemstocknumberidx` (`stocknumber`), |
1228 |
KEY `itemstocknumberidx` (`stocknumber`), |