Bug 41409 - Streetnumber has a different data type in borrower_modifications
Summary: Streetnumber has a different data type in borrower_modifications
Status: Passed QA
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement
Assignee: Matt Blenkinsop
QA Contact: Laura Escamilla
URL:
Keywords:
Depends on:
Blocks: 41411
  Show dependency treegraph
 
Reported: 2025-12-09 17:15 UTC by Matt Blenkinsop
Modified: 2025-12-22 16:29 UTC (History)
1 user (show)

See Also:
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:


Attachments
Bug 41409: Convert streetnumber and B_streetnumber to tinytext (3.29 KB, patch)
2025-12-09 17:26 UTC, Matt Blenkinsop
Details | Diff | Splinter Review
Bug 41409: Convert streetnumber and B_streetnumber to tinytext (3.34 KB, patch)
2025-12-09 17:27 UTC, Matt Blenkinsop
Details | Diff | Splinter Review
Bug 41409: Convert streetnumber and B_streetnumber to tinytext (3.38 KB, patch)
2025-12-10 20:39 UTC, Owen Leonard
Details | Diff | Splinter Review
Bug 41409: Convert streetnumber and B_streetnumber to tinytext (3.45 KB, patch)
2025-12-22 16:29 UTC, Laura Escamilla
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
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>