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