Open-ILS/src/sql/Pg/upgrade/XXXX.schema.usrname_index.sql

   1 -- Evergreen DB patch XXXX.schema.usrname_index.sql
   2 --
   3 -- Create search index on actor.usr.usrname
   4 --
   5 BEGIN;
   6
   7 SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
   8
   9 CREATE INDEX actor_usr_usrname_idx ON actor.usr (evergreen.lowercase(usrname));
  10
  11 COMMIT;