From 07f400b2da97067dae71fe47bbe14ed2a0a0a57e Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Wed, 11 Jan 2017 10:15:28 -0500 Subject: [PATCH] Adding usrname index to upgrade script --- Open-ILS/src/sql/Pg/version-upgrade/2.10.7-2.11.0-upgrade-db.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.10.7-2.11.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.10.7-2.11.0-upgrade-db.sql index 141ac8705b..0f76776b5b 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/2.10.7-2.11.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.10.7-2.11.0-upgrade-db.sql @@ -2240,6 +2240,8 @@ $$ LANGUAGE PLPGSQL; CREATE INDEX actor_usr_first_given_name_unaccent_idx ON actor.usr (evergreen.unaccent_and_squash(first_given_name)); CREATE INDEX actor_usr_second_given_name_unaccent_idx ON actor.usr (evergreen.unaccent_and_squash(second_given_name)); CREATE INDEX actor_usr_family_name_unaccent_idx ON actor.usr (evergreen.unaccent_and_squash(family_name)); +-- Adding index for usrname +CREATE INDEX actor_usr_usrname_unaccent_idx ON actor.usr (evergreen.unaccent_and_squash(usrname)); -- DB setting to control behavior; true by default INSERT INTO config.org_unit_setting_type -- 2.11.0