[Koha-bugs] [Bug 6175] Mismatch between auth_subfield_structure and authorised_values data type - varchar(32) vs. varchar(10)

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

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

Katrin Fischer <katrin.fischer at bsz-bw.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |katrin.fischer at bsz-bw.de
            Summary|Mismatch between            |Mismatch between
                   |marc_subfield_structure and |auth_subfield_structure and
                   |authorised_values tables    |authorised_values data type
                   |                            | - varchar(32) vs.
                   |                            |varchar(10)

--- Comment #8 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
marc_subfield_structure
 `authorised_value` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

auth_subfield_structure
 `authorised_value` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

authorised_value_categories
 `category_name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

authorised_values
  `category` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

I think there is still a issue for the auth_subfield_structure.

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