Lines 753-758
CREATE TABLE `article_requests` (
Link Here
|
753 |
`notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
753 |
`notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
754 |
`format` enum('PHOTOCOPY', 'SCAN') NOT NULL DEFAULT 'PHOTOCOPY', |
754 |
`format` enum('PHOTOCOPY', 'SCAN') NOT NULL DEFAULT 'PHOTOCOPY', |
755 |
`urls` MEDIUMTEXT, |
755 |
`urls` MEDIUMTEXT, |
|
|
756 |
`debit_line_id` int(11) DEFAULT NULL COMMENT 'Debit line with cost for article scan request', |
756 |
`created_on` timestamp NULL DEFAULT NULL COMMENT 'Be careful with two timestamps in one table not allowing NULL', |
757 |
`created_on` timestamp NULL DEFAULT NULL COMMENT 'Be careful with two timestamps in one table not allowing NULL', |
757 |
`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), |
758 |
`updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), |
758 |
PRIMARY KEY (`id`), |
759 |
PRIMARY KEY (`id`), |
Lines 763-769
CREATE TABLE `article_requests` (
Link Here
|
763 |
CONSTRAINT `article_requests_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
764 |
CONSTRAINT `article_requests_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
764 |
CONSTRAINT `article_requests_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
765 |
CONSTRAINT `article_requests_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
765 |
CONSTRAINT `article_requests_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
766 |
CONSTRAINT `article_requests_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
766 |
CONSTRAINT `article_requests_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE |
767 |
CONSTRAINT `article_requests_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE, |
|
|
768 |
CONSTRAINT `article_requests_ibfk_5` FOREIGN KEY (`debit_line_id`) REFERENCES `accountlines` (`accountlines_id`) ON DELETE SET NULL ON UPDATE CASCADE |
767 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
769 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
768 |
/*!40101 SET character_set_client = @saved_cs_client */; |
770 |
/*!40101 SET character_set_client = @saved_cs_client */; |
769 |
|
771 |
|
Lines 1621-1626
CREATE TABLE `categories` (
Link Here
|
1621 |
`min_password_length` smallint(6) DEFAULT NULL COMMENT 'set minimum password length for patrons in this category', |
1623 |
`min_password_length` smallint(6) DEFAULT NULL COMMENT 'set minimum password length for patrons in this category', |
1622 |
`require_strong_password` tinyint(1) DEFAULT NULL COMMENT 'set required password strength for patrons in this category', |
1624 |
`require_strong_password` tinyint(1) DEFAULT NULL COMMENT 'set required password strength for patrons in this category', |
1623 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude patrons of this category from local holds priority', |
1625 |
`exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude patrons of this category from local holds priority', |
|
|
1626 |
`article_request_fee` decimal(28,6) DEFAULT NULL COMMENT 'Cost for article scan request', |
1624 |
PRIMARY KEY (`categorycode`), |
1627 |
PRIMARY KEY (`categorycode`), |
1625 |
UNIQUE KEY `categorycode` (`categorycode`) |
1628 |
UNIQUE KEY `categorycode` (`categorycode`) |
1626 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1629 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |