Lines 1620-1625
CREATE TABLE `borrowers` (
Link Here
|
1620 |
KEY `cardnumber_idx` (`cardnumber`), |
1620 |
KEY `cardnumber_idx` (`cardnumber`), |
1621 |
KEY `userid_idx` (`userid`), |
1621 |
KEY `userid_idx` (`userid`), |
1622 |
KEY `middle_name_idx` (`middle_name`(768)), |
1622 |
KEY `middle_name_idx` (`middle_name`(768)), |
|
|
1623 |
KEY `preferred_name_idx` (`preferred_name`), |
1623 |
CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`), |
1624 |
CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`), |
1624 |
CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`), |
1625 |
CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`), |
1625 |
CONSTRAINT `borrowers_ibfk_3` FOREIGN KEY (`sms_provider_id`) REFERENCES `sms_providers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE |
1626 |
CONSTRAINT `borrowers_ibfk_3` FOREIGN KEY (`sms_provider_id`) REFERENCES `sms_providers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE |
1626 |
- |
|
|