|
Lines 1266-1271
CREATE TABLE `borrower_attribute_types` (
Link Here
|
| 1266 |
`keep_for_pseudonymization` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field is copied to anonymized_borrower_attributes (1 for yes, 0 for no)', |
1266 |
`keep_for_pseudonymization` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this field is copied to anonymized_borrower_attributes (1 for yes, 0 for no)', |
| 1267 |
`mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not in the staff interface', |
1267 |
`mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not in the staff interface', |
| 1268 |
`opac_mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not in the OPAC', |
1268 |
`opac_mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not in the OPAC', |
|
|
1269 |
`self_renewal_verification_check` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'use this attribute as a verification step for patron self-renewal', |
| 1269 |
PRIMARY KEY (`code`), |
1270 |
PRIMARY KEY (`code`), |
| 1270 |
KEY `auth_val_cat_idx` (`authorised_value_category`), |
1271 |
KEY `auth_val_cat_idx` (`authorised_value_category`), |
| 1271 |
KEY `category_code` (`category_code`), |
1272 |
KEY `category_code` (`category_code`), |
|
Lines 1827-1832
CREATE TABLE `categories` (
Link Here
|
| 1827 |
`noissueschargeguarantees` int(11) DEFAULT NULL COMMENT 'define maximum amount that the guarantees of a patron in this category can have outstanding before checkouts are blocked', |
1828 |
`noissueschargeguarantees` int(11) DEFAULT NULL COMMENT 'define maximum amount that the guarantees of a patron in this category can have outstanding before checkouts are blocked', |
| 1828 |
`noissueschargeguarantorswithguarantees` int(11) DEFAULT NULL COMMENT 'define maximum amount that the guarantors with guarantees of a patron in this category can have outstanding before checkouts are blocked', |
1829 |
`noissueschargeguarantorswithguarantees` int(11) DEFAULT NULL COMMENT 'define maximum amount that the guarantors with guarantees of a patron in this category can have outstanding before checkouts are blocked', |
| 1829 |
`enforce_expiry_notice` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'enforce the patron expiry notice for this category', |
1830 |
`enforce_expiry_notice` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'enforce the patron expiry notice for this category', |
|
|
1831 |
`self_renewal_enabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'allow self renewal for this category', |
| 1832 |
`self_renewal_availability_start` smallint(6) DEFAULT NULL COMMENT 'how long before the patron expiry date self-renewal should be made available (overrides system default of NotifyBorrowerDeparture)', |
| 1833 |
`self_renewal_fines_block` int(11) DEFAULT NULL COMMENT 'the amount owed in fines before self renewal is blocked (overrides system default of noissuescharge)', |
| 1834 |
`self_renewal_if_expired` smallint(6) DEFAULT 0 COMMENT 'how long after expiry a patron can self renew their account', |
| 1835 |
`self_renewal_failure_message` mediumtext DEFAULT NULL COMMENT 'the message to display if self renewal is not successful', |
| 1830 |
PRIMARY KEY (`categorycode`), |
1836 |
PRIMARY KEY (`categorycode`), |
| 1831 |
UNIQUE KEY `categorycode` (`categorycode`) |
1837 |
UNIQUE KEY `categorycode` (`categorycode`) |
| 1832 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
1838 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1833 |
- |
|
|