View | Details | Raw Unified | Return to bug 22421
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
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
- 

Return to bug 22421