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

(-)a/installer/data/mysql/kohastructure.sql (-5 / +6 lines)
Lines 4041-4050 CREATE TABLE `issues` ( Link Here
4041
  KEY `branchcode_idx` (`branchcode`),
4041
  KEY `branchcode_idx` (`branchcode`),
4042
  KEY `bordate` (`borrowernumber`,`timestamp`),
4042
  KEY `bordate` (`borrowernumber`,`timestamp`),
4043
  KEY `issues_ibfk_borrowers_borrowernumber` (`issuer_id`),
4043
  KEY `issues_ibfk_borrowers_borrowernumber` (`issuer_id`),
4044
  KEY `issues_booking_id_fk` (`booking_id`),
4045
  CONSTRAINT `issues_booking_id_fk` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`booking_id`) ON DELETE SET NULL ON UPDATE CASCADE,
4044
  CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON UPDATE CASCADE,
4046
  CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON UPDATE CASCADE,
4045
  CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON UPDATE CASCADE,
4047
  CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON UPDATE CASCADE,
4046
  CONSTRAINT `issues_ibfk_borrowers_borrowernumber` FOREIGN KEY (`issuer_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
4048
  CONSTRAINT `issues_ibfk_borrowers_borrowernumber` FOREIGN KEY (`issuer_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE
4047
  CONSTRAINT `issues_booking_id_fk` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`booking_id`) ON DELETE SET NULL ON UPDATE CASCADE
4048
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4049
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4049
/*!40101 SET character_set_client = @saved_cs_client */;
4050
/*!40101 SET character_set_client = @saved_cs_client */;
4050
4051
Lines 5098-5107 CREATE TABLE `old_issues` ( Link Here
5098
  KEY `branchcode_idx` (`branchcode`),
5099
  KEY `branchcode_idx` (`branchcode`),
5099
  KEY `old_bordate` (`borrowernumber`,`timestamp`),
5100
  KEY `old_bordate` (`borrowernumber`,`timestamp`),
5100
  KEY `old_issues_ibfk_borrowers_borrowernumber` (`issuer_id`),
5101
  KEY `old_issues_ibfk_borrowers_borrowernumber` (`issuer_id`),
5102
  KEY `old_issues_booking_id_fk` (`booking_id`),
5103
  CONSTRAINT `old_issues_booking_id_fk` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`booking_id`) ON DELETE SET NULL ON UPDATE CASCADE,
5101
  CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL,
5104
  CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL,
5102
  CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL,
5105
  CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL,
5103
  CONSTRAINT `old_issues_ibfk_borrowers_borrowernumber` FOREIGN KEY (`issuer_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
5106
  CONSTRAINT `old_issues_ibfk_borrowers_borrowernumber` FOREIGN KEY (`issuer_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE
5104
  CONSTRAINT `old_issues_booking_id_fk` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`booking_id`) ON DELETE SET NULL ON UPDATE CASCADE
5105
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5107
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5106
/*!40101 SET character_set_client = @saved_cs_client */;
5108
/*!40101 SET character_set_client = @saved_cs_client */;
5107
5109
5108
- 

Return to bug 40665