[Koha-bugs] [Bug 3777] Field Sizes Inconsistent

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

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

--- Comment #13 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
(In reply to Jon Knight from comment #12)
> I'm just trawling through old REOPENed cases and I see that the current
> (17.05) borrower schema still has the inconsistencies in the addresses.  As
> this was reopened because it was proving to be an issue for some addresses
> longer than 100 characters, is it worth just attacking just those fields to
> make them all match the address versions?
> 
> In other words make these field changes in the borrowers table schema:
> 
> B_address mediumtext NOT NULL,
> B_address2 text,
> B_city mediumtext NOT NULL,
> 
> and
> 
> altcontactaddress1 mediumtext NOT NULL,
> altcontactaddress2 text,
> altcontactaddress3 mediumtext NOT NULL,

I once tried to start a clean-up, but ended very confused. In your eample I
think there is probably no reason that ...address2 should not be mediumtext not
null too?
One thing I encountered back then was that some types can't be using not null
(iirc).

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