Bug 41409

Summary: Streetnumber has a different data type in borrower_modifications
Product: Koha Reporter: Matt Blenkinsop <matt.blenkinsop>
Component: DatabaseAssignee: Matt Blenkinsop <matt.blenkinsop>
Status: Passed QA --- QA Contact: Laura Escamilla <Laura.escamilla>
Severity: enhancement    
Priority: P5 - low CC: Laura.escamilla
Version: Main   
Hardware: All   
OS: All   
GIT URL: Initiative type: ---
Sponsorship status: Sponsored Comma delimited list of Sponsors:
Crowdfunding goal: 0 Patch complexity: Trivial patch
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Bug Depends on:    
Bug Blocks: 41411    
Attachments: Bug 41409: Convert streetnumber and B_streetnumber to tinytext
Bug 41409: Convert streetnumber and B_streetnumber to tinytext
Bug 41409: Convert streetnumber and B_streetnumber to tinytext
Bug 41409: Convert streetnumber and B_streetnumber to tinytext

Description Matt Blenkinsop 2025-12-09 17:15:47 UTC
The streetnumber field is inconsistent between the borrowers and borrower_modifications table - tinytext and varchar(10) respectively
Comment 1 Matt Blenkinsop 2025-12-09 17:26:28 UTC
Created attachment 190378 [details] [review]
Bug 41409: Convert streetnumber and B_streetnumber to tinytext

Test plan:
1) Run 'updatedatabase'
2) No errors should be thrown
Comment 2 Matt Blenkinsop 2025-12-09 17:27:28 UTC
Created attachment 190381 [details] [review]
Bug 41409: Convert streetnumber and B_streetnumber to tinytext

Test plan:
1) Run 'updatedatabase'
2) No errors should be thrown

Sponsored-by: Cheshire West and Chester Council
Comment 3 Owen Leonard 2025-12-10 20:39:40 UTC
Created attachment 190419 [details] [review]
Bug 41409: Convert streetnumber and B_streetnumber to tinytext

Test plan:
1) Run 'updatedatabase'
2) No errors should be thrown

Sponsored-by: Cheshire West and Chester Council
Signed-off-by: Owen Leonard <oleonard@myacpl.org>
Comment 4 Laura Escamilla 2025-12-22 16:29:40 UTC
Created attachment 190682 [details] [review]
Bug 41409: Convert streetnumber and B_streetnumber to tinytext

Test plan:
1) Run 'updatedatabase'
2) No errors should be thrown

Sponsored-by: Cheshire West and Chester Council
Signed-off-by: Owen Leonard <oleonard@myacpl.org>
Signed-off-by: Laura_Escamilla <laura.escamilla@bywatersolutions.com>