Lines 766-771
CREATE TABLE `article_requests` (
Link Here
|
766 |
`patron_notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
766 |
`patron_notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
767 |
`status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING', |
767 |
`status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING', |
768 |
`notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
768 |
`notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
|
|
769 |
`debit_line_id` int(11) DEFAULT NULL COMMENT 'Debit line with cost for article scan request', |
769 |
`created_on` timestamp NULL DEFAULT NULL COMMENT 'Be careful with two timestamps in one table not allowing NULL', |
770 |
`created_on` timestamp NULL DEFAULT NULL COMMENT 'Be careful with two timestamps in one table not allowing NULL', |
770 |
`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), |
771 |
`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), |
771 |
PRIMARY KEY (`id`), |
772 |
PRIMARY KEY (`id`), |
Lines 776-782
CREATE TABLE `article_requests` (
Link Here
|
776 |
CONSTRAINT `article_requests_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
777 |
CONSTRAINT `article_requests_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
777 |
CONSTRAINT `article_requests_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
778 |
CONSTRAINT `article_requests_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
778 |
CONSTRAINT `article_requests_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
779 |
CONSTRAINT `article_requests_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
779 |
CONSTRAINT `article_requests_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE |
780 |
CONSTRAINT `article_requests_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE, |
|
|
781 |
CONSTRAINT `article_requests_ibfk_5` FOREIGN KEY (`debit_line_id`) REFERENCES `accountlines` (`accountlines_id`) ON DELETE SET NULL ON UPDATE CASCADE |
780 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
782 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
781 |
/*!40101 SET character_set_client = @saved_cs_client */; |
783 |
/*!40101 SET character_set_client = @saved_cs_client */; |
782 |
|
784 |
|
Lines 1632-1637
CREATE TABLE `categories` (
Link Here
|
1632 |
`min_password_length` smallint(6) DEFAULT NULL COMMENT 'set minimum password length for patrons in this category', |
1634 |
`min_password_length` smallint(6) DEFAULT NULL COMMENT 'set minimum password length for patrons in this category', |
1633 |
`require_strong_password` tinyint(1) DEFAULT NULL COMMENT 'set required password strength for patrons in this category', |
1635 |
`require_strong_password` tinyint(1) DEFAULT NULL COMMENT 'set required password strength for patrons in this category', |
1634 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude patrons of this category from local holds priority', |
1636 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude patrons of this category from local holds priority', |
|
|
1637 |
`article_request_fee` decimal(28,6) DEFAULT NULL COMMENT 'Cost for article scan request', |
1635 |
PRIMARY KEY (`categorycode`), |
1638 |
PRIMARY KEY (`categorycode`), |
1636 |
UNIQUE KEY `categorycode` (`categorycode`) |
1639 |
UNIQUE KEY `categorycode` (`categorycode`) |
1637 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1640 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |