Open-ILS/src/sql/Pg/upgrade/XXXX.schema.auch-source_circ-index.sql

   1 BEGIN;
   2
   3 SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
   4
   5 -- Add an index to action.usr_circ_history (source_circ) to speed up aging circs and purging accounts
   6
   7 CREATE INDEX action_usr_circ_history_source_circ_idx
   8   ON action.usr_circ_history
   9   USING btree
  10   (source_circ);
  11
  12 COMMIT;