Avoid updating deleted call numbers for 2.0 -> 2.1 upgrade user/dbs/avoid_2.1_upgrade_pain_2_1
authorDan Scott <dscott@laurentian.ca>
Tue, 22 Nov 2011 17:00:06 +0000 (12:00 -0500)
committerDan Scott <dscott@laurentian.ca>
Tue, 22 Nov 2011 17:00:06 +0000 (12:00 -0500)
commit2809205a0cbe6effc19a3873cb0c67e77ea216cc
tree79fea0b8efeebc5303cd15d44f6df5c47fb04a14
parent22f7c28bbfe83b204cbc1107ed7d3bcd3b21ff2d
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>
Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql