|
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 |
- |
|
|