From 0605036fbd77afffcde68a57219ab1fce205a407 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Thu, 27 Oct 2011 14:46:38 -0400 Subject: [PATCH] slight customization of 1.6.1-2.0 upgrade script --- Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql index 467b7bbb0a..2cc4293a85 100644 --- a/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql @@ -7640,6 +7640,10 @@ ALTER TABLE action.hold_request DROP CONSTRAINT hold_request_hold_type_check; UPDATE config.index_normalizer SET param_count = 0 WHERE func = 'split_date_range'; +-- dropping the index - slight difference in PINES db + +DROP INDEX actor.actor_usr_usrgroup_idx; + CREATE INDEX actor_usr_usrgroup_idx ON actor.usr (usrgroup); -- Add claims_never_checked_out_count to actor.usr, related history -- 2.11.0