Lines 5103-5109
CREATE TABLE `tmp_holdsqueue` (
Link Here
|
5103 |
`notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
5103 |
`notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
5104 |
`item_level_request` tinyint(4) NOT NULL DEFAULT 0, |
5104 |
`item_level_request` tinyint(4) NOT NULL DEFAULT 0, |
5105 |
KEY `tmp_holdsqueue_ibfk_1` (`itemnumber`), |
5105 |
KEY `tmp_holdsqueue_ibfk_1` (`itemnumber`), |
5106 |
CONSTRAINT `tmp_holdsqueue_ibfk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE |
5106 |
CONSTRAINT `tmp_holdsqueue_ibfk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
|
5107 |
CONSTRAINT `tmp_holdsqueue_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
5108 |
CONSTRAINT `tmp_holdsqueue_ibfk_3` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE |
5107 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
5109 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
5108 |
/*!40101 SET character_set_client = @saved_cs_client */; |
5110 |
/*!40101 SET character_set_client = @saved_cs_client */; |
5109 |
|
5111 |
|
5110 |
- |
|
|