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

(-)a/installer/data/mysql/kohastructure.sql (-5 / +6 lines)
Lines 4002-4011 CREATE TABLE `issues` ( Link Here
4002
  KEY `branchcode_idx` (`branchcode`),
4002
  KEY `branchcode_idx` (`branchcode`),
4003
  KEY `bordate` (`borrowernumber`,`timestamp`),
4003
  KEY `bordate` (`borrowernumber`,`timestamp`),
4004
  KEY `issues_ibfk_borrowers_borrowernumber` (`issuer_id`),
4004
  KEY `issues_ibfk_borrowers_borrowernumber` (`issuer_id`),
4005
  KEY `issues_booking_id_fk` (`booking_id`),
4006
  CONSTRAINT `issues_booking_id_fk` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`booking_id`) ON DELETE SET NULL ON UPDATE CASCADE,
4005
  CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON UPDATE CASCADE,
4007
  CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON UPDATE CASCADE,
4006
  CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON UPDATE CASCADE,
4008
  CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON UPDATE CASCADE,
4007
  CONSTRAINT `issues_ibfk_borrowers_borrowernumber` FOREIGN KEY (`issuer_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
4009
  CONSTRAINT `issues_ibfk_borrowers_borrowernumber` FOREIGN KEY (`issuer_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE
4008
  CONSTRAINT `issues_booking_id_fk` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`booking_id`) ON DELETE SET NULL ON UPDATE CASCADE
4009
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4010
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4010
/*!40101 SET character_set_client = @saved_cs_client */;
4011
/*!40101 SET character_set_client = @saved_cs_client */;
4011
4012
Lines 5059-5068 CREATE TABLE `old_issues` ( Link Here
5059
  KEY `branchcode_idx` (`branchcode`),
5060
  KEY `branchcode_idx` (`branchcode`),
5060
  KEY `old_bordate` (`borrowernumber`,`timestamp`),
5061
  KEY `old_bordate` (`borrowernumber`,`timestamp`),
5061
  KEY `old_issues_ibfk_borrowers_borrowernumber` (`issuer_id`),
5062
  KEY `old_issues_ibfk_borrowers_borrowernumber` (`issuer_id`),
5063
  KEY `old_issues_booking_id_fk` (`booking_id`),
5064
  CONSTRAINT `old_issues_booking_id_fk` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`booking_id`) ON DELETE SET NULL ON UPDATE CASCADE,
5062
  CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL,
5065
  CONSTRAINT `old_issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL,
5063
  CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL,
5066
  CONSTRAINT `old_issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL,
5064
  CONSTRAINT `old_issues_ibfk_borrowers_borrowernumber` FOREIGN KEY (`issuer_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
5067
  CONSTRAINT `old_issues_ibfk_borrowers_borrowernumber` FOREIGN KEY (`issuer_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE
5065
  CONSTRAINT `old_issues_booking_id_fk` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`booking_id`) ON DELETE SET NULL ON UPDATE CASCADE
5066
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5068
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5067
/*!40101 SET character_set_client = @saved_cs_client */;
5069
/*!40101 SET character_set_client = @saved_cs_client */;
5068
5070
5069
- 

Return to bug 40665