Lines 4415-4420
CREATE TABLE `reserves` (
Link Here
|
4415 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4415 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4416 |
/*!40101 SET character_set_client = @saved_cs_client */; |
4416 |
/*!40101 SET character_set_client = @saved_cs_client */; |
4417 |
|
4417 |
|
|
|
4418 |
-- |
4419 |
-- Table structure for table `hold_cancellation_requests` |
4420 |
-- |
4421 |
|
4422 |
DROP TABLE IF EXISTS `hold_cancellation_requests`; |
4423 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
4424 |
/*!40101 SET character_set_client = utf8 */; |
4425 |
CREATE TABLE `hold_cancellation_requests` ( |
4426 |
`hold_cancellation_request_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique ID of the cancellation request', |
4427 |
`hold_id` int(11) NOT null COMMENT 'ID of the hold', |
4428 |
`requester_id` int(11) NULL DEFAULT NULL COMMENT 'ID of the user that made the cancellation request', |
4429 |
`creation_date` timestamp NULL DEFAULT NULL COMMENT 'Time and date the cancellation request was created', |
4430 |
`source` ENUM('owner') NOT NULL DEFAULT 'owner' COMMENT 'The source for the cancellation request', |
4431 |
`status` ENUM('requested','accepted','rejected') DEFAULT 'requested' COMMENT 'request status', |
4432 |
`resolution_date` timestamp NULL DEFAULT NULL COMMENT 'Time and date cancellation request was resolved', |
4433 |
`resolver_id` int(11) NULL DEFAULT NULL COMMENT 'ID of the staff member that resolved the request', |
4434 |
PRIMARY KEY (`hold_cancellation_request_id`), |
4435 |
UNIQUE KEY `hold_requester_uniq` (`hold_id`, `requester_id`), |
4436 |
CONSTRAINT `hc_requester_ibfk` FOREIGN KEY (`requester_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
4437 |
CONSTRAINT `hc_resolver_ibfk` FOREIGN KEY (`resolver_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE |
4438 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4439 |
/*!40101 SET character_set_client = @saved_cs_client */; |
4440 |
|
4418 |
-- |
4441 |
-- |
4419 |
-- Table structure for table `return_claims` |
4442 |
-- Table structure for table `return_claims` |
4420 |
-- |
4443 |
-- |
4421 |
- |
|
|