|
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 |
`marc` longblob, -- unused in Koha |
|
|
| 921 |
PRIMARY KEY (`itemnumber`), |
920 |
PRIMARY KEY (`itemnumber`), |
| 922 |
KEY `delitembarcodeidx` (`barcode`), |
921 |
KEY `delitembarcodeidx` (`barcode`), |
| 923 |
KEY `delitemstocknumberidx` (`stocknumber`), |
922 |
KEY `delitemstocknumberidx` (`stocknumber`), |