Avoid updating deleted call numbers for 2.0 -> 2.1 upgrade user/dbs/lp893683_redux
authorDan Scott <dscott@laurentian.ca>
Tue, 22 Nov 2011 16:55:45 +0000 (11:55 -0500)
committerDan Scott <dan@coffeecode.net>
Thu, 29 Dec 2011 18:22:48 +0000 (13:22 -0500)
commit540b070763ad12910495fca356c01eb27230b997
tree8db6839a89e2a4cafbb150e7cc31a81fed5b4d5c
parent21adee5d2d4ad32cfd299edf72e3d70ec1428939
Avoid updating deleted call numbers for 2.0 -> 2.1 upgrade

25% of the call numbers on our production system are deleted, so
filtering out the deleted call numbers from the update in the 2.0 -> 2.1
upgrade saves a significant amount of time.

Signed-off-by: Dan Scott <dscott@laurentian.ca>
Signed-off-by: Bill Erickson <berick@esilibrary.com>
Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql