]> git.evergreen-ils.org Git - Evergreen.git/blob - Open-ILS/src/sql/Pg/upgrade/XXXX.schema.actor_usr_usrname_unaccent_idx.sql
LP#1643932 - Fix search slowness when patron searching by username
[Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / XXXX.schema.actor_usr_usrname_unaccent_idx.sql
1 BEGIN;
2
3 SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); -- csharp/miker
4
5 CREATE INDEX actor_usr_usrname_unaccent_idx ON actor.usr (evergreen.unaccent_and_squash(usrname));
6
7
8 COMMIT;