Bug 35990

Summary: [OMNIBUS] Improvements for using tinyint authorised values
Product: Koha Reporter: Marcel de Rooy <m.de.rooy>
Component: Staff interfaceAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: david, gmcharlt
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Bug Depends on: 28869    
Bug Blocks:    

Description Marcel de Rooy 2024-02-05 09:44:26 UTC
This omnibus relates to the work done on bug 28869 making it possible to restrict AV categories to 'tinyint' values (signed tinyint, -128 to 127).
I am not doing all the work on that report. Bug 28869 is just the base point for further improvements.
Listing a few suggestions on next comments.
Comment 1 Marcel de Rooy 2024-02-05 09:55:44 UTC
Here are a few:

Apply tinyint restriction to installer files / sample data
en/mandatory/auth_values.yml
mandatory/auth_val_cat.sql
category: "YES_NO"
categories LOST DAMAGED WITHDRAWN RESTRICTED 
Correct/warn bad data (search_for_data_inconsistencies.pl, about page)
Form navigation improvement
Distinction between category code and title