Lines 269-275
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
269 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
269 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
270 |
KEY `categorycode` (`categorycode`), |
270 |
KEY `categorycode` (`categorycode`), |
271 |
KEY `branchcode` (`branchcode`), |
271 |
KEY `branchcode` (`branchcode`), |
272 |
KEY `userid` (`userid`), |
272 |
UNIQUE KEY `userid` (`userid`), |
273 |
KEY `guarantorid` (`guarantorid`), |
273 |
KEY `guarantorid` (`guarantorid`), |
274 |
KEY `surname_idx` (`surname`(255)), |
274 |
KEY `surname_idx` (`surname`(255)), |
275 |
KEY `firstname_idx` (`firstname`(255)), |
275 |
KEY `firstname_idx` (`firstname`(255)), |