Upgrade to 22.06.00.000 [08:17:08]: 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 [08:17:08]: Bug 23659 - Add DefaultHoldPickupLocation syspref Added DefaultHoldPickupLocation syspref Upgrade to 22.06.00.002 [08:17:08]: 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 [08:17:08]: Bug 30924 - Add missing RecallCancellation option to branchtransfers.reason ENUM Upgrade to 22.06.00.004 [08:17:08]: Bug 12446 - Ability to allow guarantor relationship for all patron category types Upgrade to 22.06.00.005 [08:17:08]: Bug 24239 - Add due_date to illrequests Upgrade to 22.06.00.006 [08:17:08]: Bug 21978 - Add middle_name to borrowers table Added middle name column to borrowers table Added middle name column to deletedborrowers table Added middle name column to borrower_modifications table Added middle name to DefaultPatronSearchFields Upgrade to 22.06.00.007 [08:17:08]: Bug 29129 - Update the DisplayClearnScreenButton system pref to allow for a choice between ISSUESLIP and ISSUEQSLIP Upgrade to 22.06.00.008 [08:17:08]: Bug 30327 - Add ComponentSortField and ComponentSortOrder sysprefs Added ComponentSortField and ComponentSortOrder sysprefs Upgrade to 22.06.00.009 [08:17:08]: Bug 30889 - Add calling context information to background_jobs Upgrade to 22.06.00.010 [08:17:08]: Bug 30823 - Replace recalls FULFILL actions with FILL in action logs Upgrade to 22.06.00.011 [08:17:08]: 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 [08:17:09]: Bug 24010 - Make subscription.staffdisplaycount and opacdisplaycount integer columns Upgrade to 22.06.00.013 [08:17:09]: Bug 24865 - Customize the Accountlines Description Upgrade to 22.06.00.014 [08:17:09]: Bug 24857 - Add ability to group items on a record Upgrade to 22.06.00.015 [08:17:09]: Bug 28854 - Item bundles support item_bundles table added Missing from bundle LOST AV added Added to bundle NOT_LOAN AV added System preferences added and set Dropped unique constraint on issue_id in return_claims Upgrade to 22.06.00.016 [08:17:09]: Bug 28854 - Add new unique index to return claims item_issue index added to return_claims Upgrade to 22.06.00.017 [08:17:09]: Bug 29632 - Add callnumber type to allow sorting Add callnumber to search_field type enum Upgrade to 22.06.00.018 [08:17:09]: Bug 11889 - Add pref ListOwnershipUponPatronDeletion Upgrade to 22.06.00.019 [08:17:09]: Bug 30933 - Add pref ListOwnerDesignated Upgrade to 22.06.00.020 [08:17:09]: Bug 31086 - Do not allow null values in branchcodes for reserves Removed NULL option from branchcode for reserves Upgrade to 22.06.00.021 [08:17:09]: Bug 31157 - Add OverdueNoticeFrom preference Upgrade to 22.06.00.022 [08:17:09]: Bug 30650 - Curbside pickup tables Upgrade to 22.06.00.023 [08:17:09]: Bug 22456 - Allow cancelling waiting holds Upgrade to 22.06.00.024 [08:17:09]: 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 [08:17:09]: Bug 14364 - Allow automatically canceled expired waiting holds to fill the next hold Added ExpireReservesAutoFill system preferences Added HOLD_CHANGED notice Upgrade to 22.06.00.026 [08:17:09]: Bug 30984 - Log the cron script that generated an action log if there is one Upgrade to 22.06.00.027 [08:17:09]: Bug 28269 - Add new system preference SearchWithISSNVariations Upgrade to 22.06.00.028 [08:17:09]: Bug 30077 - Add new system preference IntranetAddMastheadLibraryPulldown Upgrade to 22.06.00.029 [08:17:09]: Bug 30392 - Add deleteditems.deleted_on Upgrade to 22.06.00.030 [08:17:09]: Bug 31274 - OPACSuggestionAutoFill must be 1 or 0 Upgrade to 22.06.00.031 [08:17:09]: Bug 30327 - Add biblionumber to ComponentSortField Added biblionumber option to ComponentSortField Upgrade to 22.06.00.032 [08:17:09]: 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 [08:17:09]: Bug 27779 - Simplify credit descriptions Upgrade to 22.06.00.034 [08:17:09]: Bug 29897 - Add new system preference OPACAuthorIdentifiers Upgrade to 22.06.00.035 [08:17:09]: Bug 28787 - Add new letter 2FA_OTP_TOKEN Upgrade to 22.06.00.036 [08:17:09]: Bug 31017 - Add type option to vendors Added type column to aqbooksellers Added VENDOR_TYPE authorised value category Upgrade to 22.06.00.037 [08:17:09]: Bug 23681 - Add customisable patron restriction types Added restriction_types table Added system restriction_types Added borrower_debarments relation Added manage_patron_restrictions permission Added PatronRestrictionTypes preference Upgrade to 22.06.00.038 [08:17:09]: Bug 30335 - Add manual_invoice and manual_credit permissions Upgrade to 22.06.00.039 [08:17:09]: Bug 31374 - Add a non-public note column to the suggestions table Add staff_note column to suggestions table Upgrade to 22.06.00.040 [08:17:09]: Bug 30619 - Add email notice for Point of Sale > RECEIPT Upgrade to 22.06.00.041 [08:17:09]: Bug 30483 - Make issues.borrowernumber and issues.itemnumber NOT NULL Upgrade to 22.06.00.042 [08:17:09]: Bug 27981 - Make it possible to force 001 = biblionumber Added system preference autoControlNumber Upgrade to 22.06.00.043 [08:17:09]: Bug 20058 - Option to use shelving location instead of homebranch for sorting Syspref UseLocationAsAQInSIP has been added Upgrade to 22.06.00.044 [08:17:09]: Bug 26247 - Add new retain search terms preferences Added `RetainCatalogSearchTerms` preference Added `RetainPatronsSearchTerms` preference Upgrade to 22.06.00.045 [08:17:09]: Bug 29144 - Copy and remove branches.opac_info Upgrade to 22.06.00.046 [08:17:09]: Bug 15348 - Add new column aqorders.estimated_delivery_date Upgrade to 22.06.00.047 [08:17:09]: Bug 30025 - Split and rename BiblioAddsAuthorities system preference Added RequireChoosingExistingAuthority and AutoLinkBiblios BiblioAddsAuthorities removed Upgrade to 22.06.00.048 [08:17:09]: Bug 30472 - borrower_relationships.guarantor_id NOT NULL Upgrade to 22.06.00.049 [08:17:09]: Bug 30490 - Adjust FK constraint for parent item type Upgrade to 22.06.00.050 [08:17:09]: Bug 30497 - Recreate old_reserves_ibfk_4 if cascading Upgrade to 22.06.00.051 [08:17:09]: Bug 7021 - Add patron category to the statistics table Upgrade to 22.06.00.052 [08:17:09]: Bug 25735 - Add Elasticsearch field 'available' Upgrade to 22.06.00.053 [08:17:09]: Bug 30484 - Add a notice template for ILL Update notices Bug 30484 DB update complete Upgrade to 22.06.00.054 [08:17:09]: Bug 23538 - Add new system preferences EmailPatronRegistrations and EmailAddressForPatronRegistrations and new OPAC_REG letter Upgrade to 22.06.00.055 [08:17:09]: Bug 26368 - Add OCLC Encoding Levels system preference Added UseOCLCEncodingLevels system preference Upgrade to 22.06.00.056 [08:17:10]: Bug 30571 - Table z3950servers: three cols NOT NULL Upgrade to 22.06.00.057 [08:17:10]: Bug 29071 - Set HoldsQueueSplitNumbering where not set Added HoldsSplitQueueNumbering if not already there Upgrade to 22.06.00.058 [08:17:10]: Bug 30944 - Replace branchtransfers.cancellation_reason CancelRecall with RecallCancellation Upgrade to 22.06.00.059 [08:17:10]: Bug 25936 - A password change notification feature Upgrade to 22.06.00.060 [08:17:10]: Bug 10950 - Add pronouns to borrowers table Added pronouns column to borrowers table Added pronouns column to deletedborrowers table Added pronouns column to borrower_modifications table Upgrade to 22.06.00.061 [08:17:10]: Bug 31333 - Add new suggestionPatronCategoryExceptions system preference Upgrade to 22.06.00.062 [08:17:10]: Bug 27136 - Add missing languages: Cree, Afrikaans and Multiple languages, Undetermined and No linguistic content Added missing languages Upgrade to 22.06.00.063 [08:17:10]: Bug 31569 - Add primary key for import_biblios Added primary key to import_biblios table Upgrade to 22.06.00.064 [08:17:10]: 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 [08:17:10]: Bug 25426 - Add new syspref CircControlReturnsBranch Added new system preference 'CircControlReturnsBranch' Upgrade to 22.06.00.066 [08:17:10]: Bug 31626 - Add letter id to the message queue table Added 'letter_id' column to 'message_queue' table Upgrade to 22.06.00.067 [08:17:10]: Bug 17170 - Add permission for creating saved search filters Added manage_search_filters permission Added search_filters table Added SavedSearchFilters system preference Upgrade to 22.06.00.068 [08:17:10]: Bug 30588 - Add an 'enforce' option for TwoFactorAuthentication Upgrade to 22.06.00.069 [08:17:10]: Bug 31715 - Add missing German (de) language translations German (de) translations were added Upgrade to 22.06.00.070 [08:17:10]: Bug 31577 - Add category list pull-down to OpacHiddenItemsExceptions Settings for OpacHiddenItemsExceptions have been updated Upgrade to 22.06.00.071 [08:17:10]: Bug 23012 - Add PROCESSING_FOUND to account_credit_types Upgrade to 22.06.00.072 [08:17:10]: Bug 24381 - Update accounts notices Upgrade to 22.06.00.073 [08:17:10]: Bug 30036 - Add syspref AuthorityXSLTOpacResultsDisplay Upgrade to 22.06.00.074 [08:17:10]: Bug 30407 - Add ability to syspref UpdateNotForLoanStatusOnCheckin to show only the notforloan values message Update is going well so far Upgrade to 22.06.00.075 [08:17:10]: Bug 31948 - Add timestamp to tmp_holdsqueue table Upgrade to 22.06.00.076 [08:17:10]: Bug 29792 - Add AutomaticConfirmTransfer system preference AutomaticConfirmTransfer system preference added Upgrade to 22.06.00.077 [08:17:10]: Bug 31713 - Add ACCOUNTS_SUMMARY slip notice Notice added Upgrade to 22.06.00.078 [08:17:10]: Bug 24860 - Add ability to place item group level holds Added new system preference 'EnableItemGroupHolds' Upgrade to 22.06.00.079 [08:17:10]: Bug 32030 - Add an ERM module Upgrade to 22.06.00.080 [08:17:10]: Bug 30880 - Add branchonly option to OPACResultsUnavailableGroupingBy syspref Upgrade to 22.06.00.081 [08:17:10]: Bug 31378 - Add identity_provider and identity_provider_domains configuration tables manage_identity_providers permission added Upgrade to 22.06.00.082 [08:17:10]: Bug 30250 - Add new system preference ApplyFrameworkDefaults Added new system preference 'ApplyFrameworkDefaults' Upgrade to 22.06.00.083 [08:17:10]: Bug 24606 - Add new table item_editor_templates