]> 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)
committerArthur Suzuki <arthur.suzuki@biblibre.com>
Wed, 12 Oct 2022 11:12:37 +0000 (13:12 +0200)
commitf4926ef8d03a8bff7262c283a2ec0c9724e63d81
treecea16b968779f6722b0a750d1f137d6c399ca22b
parentffccde580af5bd5ce91c527d5aa71f55a8e585bb
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>
(cherry picked from commit 6106f6926ab64647f0e92c8f12fedb5da3e216f0)
Signed-off-by: Arthur Suzuki <arthur.suzuki@biblibre.com>
installer/data/mysql/atomicupdate/bug_30984.pl
installer/data/mysql/kohastructure.sql