Forward port 3.0.9 upgrade script
[working/Evergreen.git] / 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;