Lines 1020-1026
CREATE TABLE `items` (
Link Here
|
1020 |
`stocknumber` varchar(32) default NULL, |
1020 |
`stocknumber` varchar(32) default NULL, |
1021 |
PRIMARY KEY (`itemnumber`), |
1021 |
PRIMARY KEY (`itemnumber`), |
1022 |
UNIQUE KEY `itembarcodeidx` (`barcode`), |
1022 |
UNIQUE KEY `itembarcodeidx` (`barcode`), |
1023 |
UNIQUE KEY `itemstocknumberidx` (`stocknumber`), |
1023 |
KEY `itemstocknumberidx` (`stocknumber`), |
1024 |
KEY `itembinoidx` (`biblioitemnumber`), |
1024 |
KEY `itembinoidx` (`biblioitemnumber`), |
1025 |
KEY `itembibnoidx` (`biblionumber`), |
1025 |
KEY `itembibnoidx` (`biblionumber`), |
1026 |
KEY `homebranch` (`homebranch`), |
1026 |
KEY `homebranch` (`homebranch`), |