]> git.evergreen-ils.org Git - working/Evergreen.git/blob - Open-ILS/src/sql/Pg/upgrade/1112.schema.auch-source_circ-index.sql
LP 1758160: Bump version in upgrade_log.
[working/Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / 1112.schema.auch-source_circ-index.sql
1 BEGIN;
2
3 SELECT evergreen.upgrade_deps_block_check('1112', :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;