Lines 1488-1493
CREATE TABLE `borrowers` (
Link Here
|
1488 |
KEY `firstname_idx` (`firstname`(191)), |
1488 |
KEY `firstname_idx` (`firstname`(191)), |
1489 |
KEY `othernames_idx` (`othernames`(191)), |
1489 |
KEY `othernames_idx` (`othernames`(191)), |
1490 |
KEY `sms_provider_id` (`sms_provider_id`), |
1490 |
KEY `sms_provider_id` (`sms_provider_id`), |
|
|
1491 |
KEY `cardnumber_idx` (`cardnumber`), |
1492 |
KEY `userid_idx` (`userid`), |
1493 |
KEY `middle_name_idx` (`middle_name`(768)), |
1491 |
CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`), |
1494 |
CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`), |
1492 |
CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`), |
1495 |
CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`), |
1493 |
CONSTRAINT `borrowers_ibfk_3` FOREIGN KEY (`sms_provider_id`) REFERENCES `sms_providers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE |
1496 |
CONSTRAINT `borrowers_ibfk_3` FOREIGN KEY (`sms_provider_id`) REFERENCES `sms_providers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE |
1494 |
- |
|
|