[Koha-bugs] [Bug 30899] Upgrade sometimes fails at "Upgrade to 21.11.05.004"

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30899

--- Comment #3 from Magnus Enger <magnus at libriotech.no> ---
This is from the site that succeeded, before the upgrade (taken from last
night's backup):

CREATE TABLE `borrower_attribute_types` (
  `code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `repeatable` tinyint(1) NOT NULL DEFAULT '0', 
  `unique_id` tinyint(1) NOT NULL DEFAULT '0', 
  `opac_display` tinyint(1) NOT NULL DEFAULT '0', 
  `opac_editable` tinyint(1) NOT NULL DEFAULT '0', 
  `staff_searchable` tinyint(1) NOT NULL DEFAULT '0', 
  `authorised_value_category` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT
NULL,
  `display_checkout` tinyint(1) NOT NULL DEFAULT '0', 
  `category_code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `class` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `keep_for_pseudonymization` tinyint(1) NOT NULL DEFAULT '0', 
  `mandatory` tinyint(1) NOT NULL DEFAULT '0', 
  PRIMARY KEY (`code`),
  KEY `auth_val_cat_idx` (`authorised_value_category`),
  KEY `category_code_fk` (`category_code`),
  CONSTRAINT `category_code_fk` FOREIGN KEY (`category_code`) REFERENCES
`categories` (`categorycode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

And this is the same for the site that failed:

CREATE TABLE `borrower_attribute_types` (
  `code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `repeatable` tinyint(1) NOT NULL DEFAULT '0', 
  `unique_id` tinyint(1) NOT NULL DEFAULT '0', 
  `opac_display` tinyint(1) NOT NULL DEFAULT '0', 
  `opac_editable` tinyint(1) NOT NULL DEFAULT '0', 
  `staff_searchable` tinyint(1) NOT NULL DEFAULT '0', 
  `authorised_value_category` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT
NULL,
  `display_checkout` tinyint(1) NOT NULL DEFAULT '0', 
  `category_code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `class` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `keep_for_pseudonymization` tinyint(1) NOT NULL DEFAULT '0', 
  `mandatory` tinyint(1) NOT NULL DEFAULT '0', 
  PRIMARY KEY (`code`),
  KEY `auth_val_cat_idx` (`authorised_value_category`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.