]> git.koha-community.org Git - koha.git/commit
Bug 30984: (QA follow-up) Switch from mediumtext to varchar(255)
authorKyle Hall <kyle@bywatersolutions.com>
Fri, 29 Jul 2022 10:53:06 +0000 (06:53 -0400)
committerLucas Gass <lucas@bywatersolutions.com>
Thu, 29 Sep 2022 15:26:14 +0000 (15:26 +0000)
commit6106f6926ab64647f0e92c8f12fedb5da3e216f0
tree10ec0673fac19e7daba4d5f599d827b2a56301cd
parent1fe48f965cb068bf707868600670a1d19fa09da2
Bug 30984: (QA follow-up) Switch from mediumtext to varchar(255)

My research indeicates that tinytext of less than 40 bytes uses
about the same storage as a varchar(255). Also, using
a TEXT field in a complex query may create a temp table.
varchar fields are also more efficient for sorting on.

Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
(cherry picked from commit 526606901626082831ab501609cf05e360551ce1)

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
installer/data/mysql/atomicupdate/bug_30984.pl
installer/data/mysql/kohastructure.sql