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