|
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`), |