Bug 33489: Add indices to default patron search fields
authorNick Clemens <nick@bywatersolutions.com>
Tue, 11 Apr 2023 17:33:55 +0000 (17:33 +0000)
committerTomas Cohen Arazi <tomascohen@theke.io>
Fri, 12 May 2023 20:50:03 +0000 (17:50 -0300)
commit1faf3bcf2a59f8e6a48a2b101d78d35843bf41dd
treee8191d950b0c0b28d1214149834b76f1b9f754e9
parent62f176d0799a3cf6422eb404646cbb17678f4c2a
Bug 33489: Add indices to default patron search fields

This patch adds indices to the borrowers table to match the default
search fields for patrons.

To test:
1 - Apply patch
2 - Update database
3 - Ensure patron searching works as before

Signed-off-by: David Nind <david@davidnind.com>
Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
installer/data/mysql/atomicupdate/bz_33489.pl [new file with mode: 0755]
installer/data/mysql/kohastructure.sql