Lines 144-153
CREATE TABLE `accountlines` (
Link Here
|
144 |
KEY `debit_type_code` (`debit_type_code`), |
144 |
KEY `debit_type_code` (`debit_type_code`), |
145 |
KEY `itemnumber` (`itemnumber`), |
145 |
KEY `itemnumber` (`itemnumber`), |
146 |
KEY `branchcode` (`branchcode`), |
146 |
KEY `branchcode` (`branchcode`), |
147 |
KEY `issue_id` (`issue_id`), |
|
|
148 |
KEY `old_issue_id` (`old_issue_id`), |
149 |
KEY `manager_id` (`manager_id`), |
147 |
KEY `manager_id` (`manager_id`), |
150 |
KEY `accountlines_ibfk_registers` (`register_id`), |
148 |
KEY `accountlines_ibfk_registers` (`register_id`), |
|
|
149 |
KEY `accountlines_ibfk_old_issues` (`old_issue_id`), |
150 |
KEY `accountlines_ibfk_issues` (`issue_id`), |
151 |
CONSTRAINT `accountlines_ibfk_borrowers` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
151 |
CONSTRAINT `accountlines_ibfk_borrowers` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
152 |
CONSTRAINT `accountlines_ibfk_borrowers_2` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
152 |
CONSTRAINT `accountlines_ibfk_borrowers_2` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
153 |
CONSTRAINT `accountlines_ibfk_branches` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE, |
153 |
CONSTRAINT `accountlines_ibfk_branches` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE, |
154 |
- |
|
|