Avoid updating deleted call numbers for 2.0 -> 2.1 upgrade user/dbs/avoid_2.1_upgrade_pain
authorDan Scott <dscott@laurentian.ca>
Tue, 22 Nov 2011 16:55:45 +0000 (11:55 -0500)
committerDan Scott <dscott@laurentian.ca>
Tue, 22 Nov 2011 16:55:45 +0000 (11:55 -0500)
commit87985df97f6a1eea90a93a02777790254cccd11a
treec7b0d96654a2819be478e6033b56dcf7fe280450
parent04d57bca29380bfd648d38c28f5071f64118d293
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