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