Upgrade to 22.06.00.000 [18:54:10]: Increase DBRev for 22.06 📜 The road of excess 📜 leads to the palace of wisdom; 📜 for we never know what is enough 📜 until we know what is more than enough. Upgrade to 22.06.00.001 [18:54:10]: Bug 23659 - Allow hold pickup location to default to item home branch for item-level holds Added new system preference 'DefaultHoldPickupLocation' Upgrade to 22.06.00.002 [18:54:10]: Bug 30850 - Message about mappings changes for 110$a 110$a was added as a default mapping for biblio.author in MARC21. This will only change the mapping on new installations. If you wish to change the mappings on your existing installation, go to Administration > Koha to MARC mapping and add 110$a to biblio.author and then run batchRebuilBiblioTables.pl. Upgrade to 22.06.00.003 [18:54:10]: Bug 30924 - Add missing RecallCancellation option to branchtransfers.reason ENUM Upgrade to 22.06.00.004 [18:54:11]: Bug 12446 - Ability to allow guarantor relationship for all patron category types Added column 'categories.can_be_guarantee' Upgrade to 22.06.00.005 [18:54:11]: Bug 24239 - Let the ILL module set ad hoc hard due dates Added column 'illrequests.due_date' Upgrade to 22.06.00.006 [18:54:11]: Bug 21978 - Add middle_name to borrowers table Added column 'borrowers.middle_name' Added column 'deletedborrowers.middle_name' Added column 'borrower_modifications.middle_name' Added middle name to DefaultPatronSearchFields Upgrade to 22.06.00.007 [18:54:11]: Bug 29129 - Update the DisplayClearnScreenButton system pref to allow for a choice between ISSUESLIP and ISSUEQSLIP Upgrade to 22.06.00.008 [18:54:11]: Bug 30327 - Sort component parts Added new system preference 'ComponentSortField' Added new system preference 'ComponentSortOrder' Upgrade to 22.06.00.009 [18:54:11]: Bug 30889 - Add calling context information to background_jobs Added column 'background_jobs.context' Upgrade to 22.06.00.010 [18:54:11]: Bug 30823 - Replace recalls FULFILL actions with FILL in action logs Upgrade to 22.06.00.011 [18:54:11]: Bug 30275 - Add a checkout_renewals table Added new table 'checkout_renewals' Renamed `issues.renewals` to `issues.renewals_count` Renamed `old_issues.renewals` to `old_issues.renewals_count` Upgrade to 22.06.00.012 [18:54:11]: Bug 24010 - Make subscription.staffdisplaycount and opacdisplaycount integer columns Upgrade to 22.06.00.013 [18:54:11]: Bug 24865 - Customize the Accountlines Description Added new letter 'OVERDUE_FINE_DESC' (print) Upgrade to 22.06.00.014 [18:54:11]: Bug 24857 - Add ability to group items on a record Added new system preference 'EnableItemGroups' Added new permission 'manage_item_groups' Added new table 'item_groups' Added new table 'item_group_items' Upgrade to 22.06.00.015 [18:54:11]: Bug 28854 - Item bundles support Added new table 'item_bundles' Missing from bundle LOST AV added Added to bundle NOT_LOAN AV added Added new system preference 'BundleLostValue' Added new system preference 'BundleNotLoanValue' Dropped unique constraint on issue_id in return_claims Upgrade to 22.06.00.016 [18:54:11]: Bug 28854 - Add new 'item_issue' unique index to return claims Upgrade to 22.06.00.017 [18:54:11]: Bug 29632 - Add callnumber type to allow sorting Add callnumber to search_field type enum Upgrade to 22.06.00.018 [18:54:11]: Bug 11889 - Add option to keep public or shared lists when deleting patron Added new system preference 'ListOwnershipUponPatronDeletion' Upgrade to 22.06.00.019 [18:54:11]: Bug 30933 - Add a designated owner for shared and public lists at patron deletion Added new system preference 'ListOwnerDesignated' Updated system preference 'ListOwnershipUponPatronDeletion' Upgrade to 22.06.00.020 [18:54:11]: Bug 31086 - Do not allow NULL values in branchcodes for reserves Removed NULL option from branchcode for reserves Upgrade to 22.06.00.021 [18:54:11]: Bug 31157 - Make --frombranch option (overdue_notices.pl) available as a syspref Added new system preference 'OverdueNoticeFrom' Upgrade to 22.06.00.022 [18:54:11]: Bug 30650 - Add Curbside pickup feature Added new table 'curbside_pickup_policy' Added new table 'curbside_pickup_opening_slots' Added new table 'curbside_pickups' Added new table 'curbside_pickup_issues' Added new letter 'NEW_CURBSIDE_PICKUP' (email) Added new system preference 'CurbsidePickup' Added new permission 'manage_curbside_pickups' (circulation) Added new permission 'manage_curbside_pickups' (admin) Added column 'curbside_pickup_policy.enable_waiting_holds_only' Upgrade to 22.06.00.023 [18:54:11]: Bug 22456 - Allow cancelling waiting holds Added new table 'hold_cancellation_requests' Upgrade to 22.06.00.024 [18:54:11]: Bug 29012 - Some rules are not saved when left blank while editing a 'rule' line in smart-rules.pl Add default values for blank circulation rules that weren't saved to the database Upgrade to 22.06.00.025 [18:54:11]: Bug 14364 - Allow automatically canceled expired waiting holds to fill the next hold Added new system preference 'ExpireReservesAutoFill' Added new letter 'HOLD_CHANGED' (email) Upgrade to 22.06.00.026 [18:54:11]: Bug 30984 - Log the cron script that generated an action log if there is one Added column 'action_logs.script' Upgrade to 22.06.00.027 [18:54:11]: Bug 28269 - Make it possible to search orders with ISSN Added new system preference 'SearchWithISSNVariations' Upgrade to 22.06.00.028 [18:54:11]: Bug 30077 - Add option for library dropdown in search function for staff interface Added new system preference 'IntranetAddMastheadLibraryPulldown' Upgrade to 22.06.00.029 [18:54:11]: Bug 30392 - Add deleteditems.deleted_on Upgrade to 22.06.00.030 [18:54:11]: Bug 31274 - OPACSuggestionAutoFill must be 1 or 0 Updated system preference 'OPACSuggestionAutoFill' Upgrade to 22.06.00.031 [18:54:11]: Bug 30327 - Add biblionumber to ComponentSortField Added biblionumber option to ComponentSortField Upgrade to 22.06.00.032 [18:54:11]: Bug 30500 - Add option to allow user to change the pickup location while a hold is in transit Added new system preference 'OPACInTransitHoldPickupLocationChange' Upgrade to 22.06.00.033 [18:54:11]: Bug 27779 - Simplify credit descriptions Upgrade to 22.06.00.034 [18:54:11]: Bug 29897 - Display author identifiers for researchers Added new system preference 'OPACAuthorIdentifiers' Upgrade to 22.06.00.035 [18:54:11]: Bug 28787 - Send a notice with the TOTP token Added new letter '2FA_OTP_TOKEN' (email) Upgrade to 22.06.00.036 [18:54:11]: Bug 31017 - Add type option to vendors Added column 'aqbooksellers.type' Added VENDOR_TYPE authorised value category Upgrade to 22.06.00.037 [18:54:11]: Bug 23681 - Add customisable patron restriction types Added new table 'restriction_types' Added system restriction_types Added borrower_debarments relation Added new permission 'manage_patron_restrictions' Added new system preference 'PatronRestrictionTypes' Upgrade to 22.06.00.038 [18:54:11]: Bug 30335 - Add manual_invoice and manual_credit permissions Added new permission 'manual_credit' Added new permission 'manual_invoice' Upgrade to 22.06.00.039 [18:54:11]: Bug 31374 - Add a non-public note column to the suggestions table Added column 'suggestions.staff_note' Upgrade to 22.06.00.040 [18:54:11]: Bug 30619 - Add email notice for Point of Sale > RECEIPT Added new letter 'RECEIPT' (email) Upgrade to 22.06.00.041 [18:54:11]: Bug 30483 - Make issues.borrowernumber and issues.itemnumber NOT NULL Upgrade to 22.06.00.042 [18:54:11]: Bug 27981 - Make it possible to force 001 = biblionumber Added new system preference 'autoControlNumber' Upgrade to 22.06.00.043 [18:54:11]: Bug 20058 - Option to use shelving location instead of homebranch for sorting Added new system preference 'UseLocationAsAQInSIP' Upgrade to 22.06.00.044 [18:54:11]: Bug 26247 - Add new retain search terms preferences Added new system preference 'RetainCatalogSearchTerms' Added new system preference 'RetainPatronSearchTerms' Upgrade to 22.06.00.045 [18:54:11]: Bug 29144 - Copy and remove branches.opac_info Upgrade to 22.06.00.046 [18:54:11]: Bug 15348 - Add new column aqorders.estimated_delivery_date Upgrade to 22.06.00.047 [18:54:11]: Bug 30025 - Split and rename BiblioAddsAuthorities system preference Added new system preference 'RequireChoosingExistingAuthority' Added new system preference 'AutoLinkBiblios' Removed system preference 'BiblioAddsAuthorities' Upgrade to 22.06.00.048 [18:54:11]: Bug 30472 - borrower_relationships.guarantor_id NOT NULL Upgrade to 22.06.00.049 [18:54:11]: Bug 30490 - Adjust FK constraint for parent item type Upgrade to 22.06.00.050 [18:54:11]: Bug 30497 - Recreate old_reserves_ibfk_4 if cascading Upgrade to 22.06.00.051 [18:54:11]: Bug 7021 - Add patron category to the statistics table Added column 'statistics.categorycode' Upgrade to 22.06.00.052 [18:54:11]: Bug 25735 - Add Elasticsearch field 'available' Upgrade to 22.06.00.053 [18:54:11]: Bug 30484 - Add a notice template for ILL Update notices Added new letter 'ILL_REQUEST_UPDATE' (email) Added new letter 'ILL_REQUEST_UPDATE' (sms) Upgrade to 22.06.00.054 [18:54:11]: Bug 23538 - Add new system preferences EmailPatronRegistrations and EmailAddressForPatronRegistrations and new OPAC_REG letter Added new system preference 'EmailPatronRegistrations' Added new letter 'OPAC_REG' (email) Upgrade to 22.06.00.055 [18:54:11]: Bug 26368 - Add OCLC Encoding Levels system preference Added new system preference 'UseOCLCEncodingLevels' Upgrade to 22.06.00.056 [18:54:11]: Bug 30571 - Table z3950servers: three cols NOT NULL Upgrade to 22.06.00.057 [18:54:11]: Bug 29071 - Set HoldsQueueSplitNumbering where not set Added new system preference 'HoldsSplitQueueNumbering' Upgrade to 22.06.00.058 [18:54:11]: Bug 30944 - Replace branchtransfers.cancellation_reason CancelRecall with RecallCancellation Upgrade to 22.06.00.059 [18:54:11]: Bug 25936 - A password change notification feature Added new letter 'PASSWORD_CHANGE' (email) Added new system preference 'NotifyPasswordChange' Upgrade to 22.06.00.060 [18:54:11]: Bug 10950 - Add preferred pronoun field to patron record Added column 'borrowers.pronouns' Added column 'deletedborrowers.pronouns' Added column 'borrower_modifications.pronouns' Upgrade to 22.06.00.061 [18:54:11]: Bug 31333 - Add the ability to limit purchase suggestions by patron category Added new system preference 'suggestionPatronCategoryExceptions' Upgrade to 22.06.00.062 [18:54:11]: Bug 27136 - Add missing languages: Cree, Afrikaans and Multiple languages, Undetermined and No linguistic content Added missing languages Upgrade to 22.06.00.063 [18:54:11]: Bug 31569 - Add primary key for import_biblios Added primary key to import_biblios table Upgrade to 22.06.00.064 [18:54:11]: Bug 14783 - Allow patrons to change pickup location for non-waiting holds Added new system preference 'OPACAllowUserToChangeBranch' Removed system preference 'OPACInTransitHoldPickupLocationChange' Upgrade to 22.06.00.065 [18:54:11]: Bug 25426 - Add new syspref CircControlReturnsBranch Added new system preference 'CircControlReturnsBranch' Upgrade to 22.06.00.066 [18:54:12]: Bug 31626 - Add letter id to the message queue table Added column 'message_queue.letter_id' Upgrade to 22.06.00.067 [18:54:12]: Bug 17170 - Add saved search filters feature Added new permission 'manage_search_filters' Added new table 'search_filters' Added new system preference 'SavedSearchFilters' Upgrade to 22.06.00.068 [18:54:12]: Bug 30588 - Add an 'enforce' option for 'TwoFactorAuthentication' system preference Updated system preference 'TwoFactorAuthentication' Upgrade to 22.06.00.069 [18:54:12]: Bug 31715 - Add missing German (de) language translations German (de) translations were added Upgrade to 22.06.00.070 [18:54:12]: Bug 31577 - Add category list pull-down to OpacHiddenItemsExceptions Updated system preference 'OpacHiddenItemsExceptions' Upgrade to 22.06.00.071 [18:54:12]: Bug 23012 - Add PROCESSING_FOUND to account_credit_types Upgrade to 22.06.00.072 [18:54:12]: Bug 24381 - Update accounts notices Upgrade to 22.06.00.073 [18:54:12]: Bug 30036 - Add XSLT for authority results view in OPAC Added new system preference 'AuthorityXSLTOpacResultsDisplay' Upgrade to 22.06.00.074 [18:54:12]: Bug 30407 - Add ability to syspref UpdateNotForLoanStatusOnCheckin to show only the notforloan values message Upgrade to 22.06.00.075 [18:54:12]: Bug 31948 - Add timestamp to tmp_holdsqueue table Upgrade to 22.06.00.076 [18:54:12]: Bug 29792 - Fix transfers created from 'wrong transfer' checkin are not sent if modal dismissed Added new system preference 'AutomaticConfirmTransfer' Upgrade to 22.06.00.077 [18:54:12]: Bug 31713 - Add ACCOUNTS_SUMMARY slip notice Added new letter 'ACCOUNTS_SUMMARY' (print) Upgrade to 22.06.00.078 [18:54:12]: Bug 24860 - Add ability to place item group level holds Added new system preference 'EnableItemGroupHolds' Upgrade to 22.06.00.079 [18:54:12]: Bug 32030 - Add an ERM module Added new system preference 'ERMModule' Added new permission 'erm' Added new table 'erm_agreements' Added new table 'erm_agreement_periods' Added new table 'erm_licenses' Added new table 'erm_agreement_licenses' Added new table 'erm_user_roles' Added new table 'erm_agreement_relationships' Added new table 'erm_documents' Added new table 'erm_eholdings_packages' Added new table 'erm_eholdings_packages_agreements' Added new table 'erm_eholdings_titles' Added new table 'erm_eholdings_resources' Added column 'aqbooksellers.external_id' Added new system preference 'ERMProviders' Added new system preference 'ERMProviderEbscoCustomerID' Added new system preference 'ERMProviderEbscoApiKey' Upgrade to 22.06.00.080 [18:54:12]: Bug 30880 - Add branchonly option to OPACResultsUnavailableGroupingBy syspref Upgrade to 22.06.00.081 [18:54:12]: Bug 31378 - Add identity_provider and identity_provider_domains configuration tables Added new permission 'manage_identity_providers' Added new table 'identity_providers' Added new table 'identity_provider_domains' Upgrade to 22.06.00.082 [18:54:12]: Bug 30250 - Add new system preference ApplyFrameworkDefaults Added new system preference 'ApplyFrameworkDefaults' Upgrade to 22.06.00.083 [18:54:12]: Bug 24606 - Add new table item_editor_templates Added new table 'item_editor_templates' Added new permission 'manage_item_editor_templates' Upgrade to 22.06.00.084 [18:54:12]: Bug 31162 - Add primary key to erm_eholdings_packages_agreements Upgrade to 22.06.00.085 [18:54:12]: Bug 32030 - Add primary key to erm_user_roles