Open-ILS/src/sql/Pg/version-upgrade/3.0.8-3.0.9-upgrade-db.sql

   1 --Upgrade Script for 3.0.8 to 3.0.9
   2 \set eg_version '''3.0.9'''
   3 BEGIN;
   4 INSERT INTO config.upgrade_log (version, applied_to) VALUES ('3.0.9', :eg_version);
   5
   6 SELECT evergreen.upgrade_deps_block_check('1112', :eg_version);
   7
   8 -- Add an index to action.usr_circ_history (source_circ) to speed up aging circs and purging accounts
   9
  10 CREATE INDEX action_usr_circ_history_source_circ_idx
  11   ON action.usr_circ_history
  12   USING btree
  13   (source_circ);
  14
  15 COMMIT;